Tablespace is missing for table ‘(null)’

In Joomla if you can’t install any extension and have error with table missing, you need to fix it like this:

In phpmyadmin, copy your database prefix and  in sql tab paste this code and hit button

DROP table IF EXISTS myprefix_updates;
CREATE TABLE `myprefix_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’;

 

 

Change myprefix_with your database prefix_

We’re a multi-featured small team, focused on designing and developing awesome themes and templates for multiple platforms such as Wordpress or Joomla, etc.