0

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

Any solution pls.

Improve this question
2
  • check "core_config_data" table exists or nor Commented Feb 11 at 12:58
  • @RonakRathod Yes, it is available. Commented Feb 11 at 14:01

1 Answer 1

Reset to default
0

Use $this->_stmt->queryString to see exactly what SQL statement is being run.

Open vendor/magento/framework/DB/Statement/Pdo/Mysql.php and around line 90 add debug code:

 89 return $this->tryExecute(function () use ($params) { 90 $writer = new \Zend_Log_Writer_Stream(BP . '/var/log/QB.log'); 91 $logger = new \Zend_Log(); 92 $logger->addWriter($writer); 93 $logger->info($this->_stmt->queryString); 94 return !empty($params) ? $this->_stmt->execute($params) : $this->_stmt->execute();

Then access your site to see the error you mentioned.

Then open up var/log/QB.log and inspect the last SQL statement. Login to the database and run that statement - does it return the result or throws an error?

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.