SQLSTATE[42S02]: Base table or view not found: 1932 Table 'magento.core_config_data' doesn't exist i

[Jeeva Rathinam]

I am getting following when i try to run any comments, and also my webpage return error.

CMD error: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'magento.core_config_data' doesn't exist in engine, query was: SELECT main_table.* FROM core_config_data AS main_table

Webpage Error: PDOException: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'magento.core_config_data' doesn't exist in engine in C:\xampp\htdocs\magento\vendor\magento\framework\DB\Statement\Pdo\Mysql.php:90

Note: core_config_data available in DB

Any solution pls.

[johnwebdes40a5]

Hello @Jeeva Rathinam 

Create the table manually:

CREATE TABLE `core_config_data` (
  `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scope` varchar(8) NOT NULL DEFAULT 'default',
  `scope_id` int(11) NOT NULL DEFAULT '0',
  `path` varchar(255) NOT NULL DEFAULT '',
  `value` text DEFAULT NULL,
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `core_config_data_scope_scope_id_path` (`scope`,`scope_id`,`path`),
  KEY `CORE_CONFIG_DATA_PATH_SCOPE_SCOPE_ID` (`path`,`scope`,`scope_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Once the query is complete, run php bin/magento cache:flush to clear the cache, and then proceed to reindex Magento using php bin/magento indexer:reindex

Hope it helps ! 

If you find our reply helpful, please give us kudos.

A Leading Magento Development Agency That Delivers Powerful Results, Innovation, and Secure Digital Transformation.

WebDesk Solution Support Team

Get a Free Quote | | Adobe Commerce Partner | Hire Us | Call Us 877.536.3789

[Jeeva Rathinam]

May i know why this issue happened?

[Milople]

Hello @Jeeva Rathinam,

Check first if table exist or not and if exist it maybe corrupted

Run the following MySQL command to check and repair the table:

CHECK TABLE core_config_data;

REPAIR TABLE core_config_data;

Also Run Magento database repair tools and reindex:

php bin/magento setup:upgrade

php bin/magento setup:di:compile

php bin/magento setup:static-content:deploy -f

php bin/magento cache:flush

php bin/magento indexer:reindex

Restart MySQL and Apache (xampp in your case).

if it still not works then create table manually or reinstall Magento 2

If the issue will be resolved, Click Kudos & Accept as a Solution.