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