I have recently updated Joomla from v 3.2.3 to 3.3.6 but for some reason when I'm trying to install anything I'm now getting an error:
1146 Table 'dbname.ku42W_updates' doesn't exist SQL=SHOW COLUMNS IN `ku42W_updates`
I have tried the following SQL query but it's not working, it's saying table doesn't exist!
CREATE TABLE IF NOT EXISTS `ku42W_updates` ( `update_id` int(11) NOT NULL AUTO_INCREMENT, `update_site_id` int(11) DEFAULT 0, `extension_id` int(11) DEFAULT 0, `name` varchar(100) DEFAULT '', `description` text NOT NULL, `element` varchar(100) DEFAULT '', `type` varchar(20) DEFAULT '', `folder` varchar(20) DEFAULT '', `client_id` tinyint(3) DEFAULT 0, `version` varchar(32) DEFAULT '', `data` text NOT NULL, `detailsurl` text NOT NULL, `infourl` text NOT NULL, `extra_query` varchar(1000) DEFAULT '', PRIMARY KEY (`update_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Available Updates';
I have tried creating the database table manually, but then getting the same error.
If I go into Extensions >> Extension Manager >> Database >> Fix, I'm getting the following error:
1146 Table 'kingswood.kw_updates' doesn't exist SQL=SHOW COLUMNS IN `kw_updates` WHERE field = 'infourl'
Any ideas what I can do to resolve it? Thanks