cancel
Showing results for 
Search instead for 
Did you mean: 

how to fix error tablespace is missing??

how to fix error tablespace is missing??


how to resolve error SQLSTATE[HY000]: General error: 1812 Tablespace is missing for table `magento`.`design_config_grid_flat`., query was: SELECT COUNT(*) FROM `design_config_grid_flat` AS `main_table` ??

i can't found table design_config_grid_flat in phpMmyadmin Smiley Frustrated

a1.jpg

 

 

 

1 REPLY

Re: how to fix error tablespace is missing??

Hi @kasumo,

 

Maybe you got an error at the installation?

Try to create the table with this script:

 

CREATE TABLE IF NOT EXISTS `design_config_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `store_website_id` int(11) DEFAULT NULL COMMENT 'Store_website_id',
  `store_group_id` int(11) DEFAULT NULL COMMENT 'Store_group_id',
  `store_id` int(11) DEFAULT NULL COMMENT 'Store_id',
  `theme_theme_id` varchar(255) DEFAULT NULL COMMENT 'Theme_theme_id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='design_config_grid_flat';

ALTER TABLE `design_config_grid_flat`
 ADD PRIMARY KEY (`entity_id`), ADD KEY `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`), ADD KEY `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`), ADD KEY `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`), ADD FULLTEXT KEY `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`);

That's from a Magento 2.1.9 vanilla installation.

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"