Magento 2 Error – Base Table or View Not Found

databasemagento2

I started getting this error suddenly and I checked and the table does exist. I'm not sure how to start fixing this issue. I have attached a picture below:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_e.catalog_category_flat_store_1' doesn't exist, query was: SELECT main_table.entity_id, main_table.name, main_table.path, main_table.is_active, main_table.is_anchor, url_rewrite.request_path FROM catalog_category_flat_store_1 AS main_table
LEFT JOIN url_rewrite ON url_rewrite.entity_id = main_table.entity_id AND url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category' WHERE (main_table.is_active = 1) AND (main_table.path like '1/2/15/%') AND (level <= 3) ORDER BY main_table.position ASC

Best Answer

In order to resolve this issue,you need to create flat table catalog_category_flat_store_1.

disable magento Catalog Flat for Category from Admin>Stores>Configuration>Catalog>Catalog>StoreFront>Use Flat Catalog Category make it NO

Then Flush magento Cache by php bin/magento cache:flush

Then you should drop table catalog_category_flat_store_1, if it is exists in db by drop table catalog_category_flat_store_1

Next enable Catalog Flat for Category by Use Flat Catalog Category make it yes

Final,you need to indexing from magento cli : php bin/magento indexer:reindex

Related Solutions

Magento – SQLSTATE[42S02]: Base table or view not found: 1146

First of all - create backup of all database that you have right now.

Looks like you haven't basic table. Without this table Magento can't work at all.

If you have other tables, only this one missing - you can try to install Magento to OTHER database and copy this table with mysqldump & mysql .

If websites data is not important for you (as example if it's new website, or test website) - you can just re-install Magento.

Anyway, best of all - to perform any actions only by Magento developer.

Magento 2 Database Error – SQLSTATE[42S02]: Base Table or View Not Found

Table is missing. Run in sql console below sql query. After run sql query run php bin/magento indexer:reindex

CREATE TABLE `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',
  PRIMARY KEY (`entity_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
  FULLTEXT KEY `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='design_config_grid_flat';

Best Answer

Related Solutions

Magento – SQLSTATE[42S02]: Base table or view not found: 1146

Magento 2 Database Error – SQLSTATE[42S02]: Base Table or View Not Found

Related Topic