skip to Main Content

Following error occurs with my website address please help me out what to do:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin_newapmasala.core_config_data' doesn't exist in /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /usr/local/apache/htdocs/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array) #2 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): MagentoFrameworkDBStatementPdoMysql->_execute(Array) #3 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array) #5 /usr/local/apache/htdocs/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(533): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array) #6 /usr/local/apache/htdocs/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(596): MagentoFrameworkDBAdapterPdoMysql->_query('SELECT `main_ta...', Array) #7 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(737): MagentoFrameworkDBAdapterPdoMysql->query(Object(MagentoFrameworkDBSelect), Array) #8 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php(21): Zend_Db_Adapter_Abstract->fetchAll(Object(MagentoFrameworkDBSelect), Array) #9 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(774): MagentoFrameworkDataCollectionDbFetchStrategyQuery->fetchAll(Object(MagentoFrameworkDBSelect), Array) #10 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(670): MagentoFrameworkDataCollectionAbstractDb->_fetchAll(Object(MagentoFrameworkDBSelect)) #11 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(574): MagentoFrameworkDataCollectionAbstractDb->getData() #12 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(559): MagentoFrameworkDataCollectionAbstractDb->loadWithFilter(false, false) #13 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection.php(831): MagentoFrameworkDataCollectionAbstractDb->load() #14 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Source/RuntimeConfigSource.php(83): MagentoFrameworkDataCollection->getIterator() #15 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Source/RuntimeConfigSource.php(63): MagentoConfigAppConfigSourceRuntimeConfigSource->loadConfig() #16 /usr/local/apache/htdocs/vendor/magento/framework/App/Config/ConfigSourceAggregated.php(40): MagentoConfigAppConfigSourceRuntimeConfigSource->get('') #17 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System/Reader.php(60): MagentoFrameworkAppConfigConfigSourceAggregated->get() #18 /usr/local/apache/htdocs/generated/code/Magento/Config/App/Config/Type/System/Reader/Proxy.php(95): MagentoConfigAppConfigTypeSystemReader->read() #19 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System.php(292): MagentoConfigAppConfigTypeSystemReaderProxy->read() #20 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System.php(191): MagentoConfigAppConfigTypeSystem->readData() #21 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System.php(152): MagentoConfigAppConfigTypeSystem->loadDefaultScopeData('default') #22 /usr/local/apache/htdocs/vendor/magento/framework/App/Config.php(131): MagentoConfigAppConfigTypeSystem->get('default/newreli...') #23 /usr/local/apache/htdocs/vendor/magento/framework/App/Config.php(80): MagentoFrameworkAppConfig->get('system', 'default/newreli...') #24 /usr/local/apache/htdocs/vendor/magento/module-new-relic-reporting/Model/Config.php(91): MagentoFrameworkAppConfig->getValue('newrelicreporti...') #25 /usr/local/apache/htdocs/vendor/magento/module-new-relic-reporting/Plugin/HttpPlugin.php(49): MagentoNewRelicReportingModelConfig->isNewRelicEnabled() #26 /usr/local/apache/htdocs/vendor/magento/framework/Interception/Interceptor.php(121): MagentoNewRelicReportingPluginHttpPlugin->beforeCatchException(Object(MagentoFrameworkAppHttpInterceptor), Object(MagentoFrameworkAppBootstrap), Object(Zend_Db_Statement_Exception)) #27 /usr/local/apache/htdocs/vendor/magento/framework/Interception/Interceptor.php(153): MagentoFrameworkAppHttpInterceptor->MagentoFrameworkInterception{closure}(Object(MagentoFrameworkAppBootstrap), Object(Zend_Db_Statement_Exception)) #28 /usr/local/apache/htdocs/generated/code/Magento/Framework/App/Http/Interceptor.php(39): MagentoFrameworkAppHttpInterceptor->___callPlugins('catchException', Array, Array) #29 /usr/local/apache/htdocs/vendor/magento/framework/App/Bootstrap.php(261): MagentoFrameworkAppHttpInterceptor->catchException(Object(MagentoFrameworkAppBootstrap), Object(Zend_Db_Statement_Exception)) #30 /usr/local/apache/htdocs/index.php(39): MagentoFrameworkAppBootstrap->run(Object(MagentoFrameworkAppHttpInterceptor)) #31 {main} Next Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin_newapmasala.core_config_data' doesn't exist, query was: SELECT `main_table`.* FROM `core_config_data` AS `main_table` in /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235 Stack trace: #0 /usr/local/apache/htdocs/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array) #1 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): MagentoFrameworkDBStatementPdoMysql->_execute(Array) #2 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array) #4 /usr/local/apache/htdocs/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(533): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array) #5 /usr/local/apache/htdocs/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(596): MagentoFrameworkDBAdapterPdoMysql->_query('SELECT `main_ta...', Array) #6 /usr/local/apache/htdocs/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(737): MagentoFrameworkDBAdapterPdoMysql->query(Object(MagentoFrameworkDBSelect), Array) #7 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php(21): Zend_Db_Adapter_Abstract->fetchAll(Object(MagentoFrameworkDBSelect), Array) #8 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(774): MagentoFrameworkDataCollectionDbFetchStrategyQuery->fetchAll(Object(MagentoFrameworkDBSelect), Array) #9 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(670): MagentoFrameworkDataCollectionAbstractDb->_fetchAll(Object(MagentoFrameworkDBSelect)) #10 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(574): MagentoFrameworkDataCollectionAbstractDb->getData() #11 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection/AbstractDb.php(559): MagentoFrameworkDataCollectionAbstractDb->loadWithFilter(false, false) #12 /usr/local/apache/htdocs/vendor/magento/framework/Data/Collection.php(831): MagentoFrameworkDataCollectionAbstractDb->load() #13 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Source/RuntimeConfigSource.php(83): MagentoFrameworkDataCollection->getIterator() #14 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Source/RuntimeConfigSource.php(63): MagentoConfigAppConfigSourceRuntimeConfigSource->loadConfig() #15 /usr/local/apache/htdocs/vendor/magento/framework/App/Config/ConfigSourceAggregated.php(40): MagentoConfigAppConfigSourceRuntimeConfigSource->get('') #16 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System/Reader.php(60): MagentoFrameworkAppConfigConfigSourceAggregated->get() #17 /usr/local/apache/htdocs/generated/code/Magento/Config/App/Config/Type/System/Reader/Proxy.php(95): MagentoConfigAppConfigTypeSystemReader->read() #18 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System.php(292): MagentoConfigAppConfigTypeSystemReaderProxy->read() #19 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System.php(191): MagentoConfigAppConfigTypeSystem->readData() #20 /usr/local/apache/htdocs/vendor/magento/module-config/App/Config/Type/System.php(152): MagentoConfigAppConfigTypeSystem->loadDefaultScopeData('default') #21 /usr/local/apache/htdocs/vendor/magento/framework/App/Config.php(131): MagentoConfigAppConfigTypeSystem->get('default/newreli...') #22 /usr/local/apache/htdocs/vendor/magento/framework/App/Config.php(80): MagentoFrameworkAppConfig->get('system', 'default/newreli...') #23 /usr/local/apache/htdocs/vendor/magento/module-new-relic-reporting/Model/Config.php(91): MagentoFrameworkAppConfig->getValue('newrelicreporti...') #24 /usr/local/apache/htdocs/vendor/magento/module-new-relic-reporting/Plugin/HttpPlugin.php(49): MagentoNewRelicReportingModelConfig->isNewRelicEnabled() #25 /usr/local/apache/htdocs/vendor/magento/framework/Interception/Interceptor.php(121): MagentoNewRelicReportingPluginHttpPlugin->beforeCatchException(Object(MagentoFrameworkAppHttpInterceptor), Object(MagentoFrameworkAppBootstrap), Object(Zend_Db_Statement_Exception)) #26 /usr/local/apache/htdocs/vendor/magento/framework/Interception/Interceptor.php(153): MagentoFrameworkAppHttpInterceptor->MagentoFrameworkInterception{closure}(Object(MagentoFrameworkAppBootstrap), Object(Zend_Db_Statement_Exception)) #27 /usr/local/apache/htdocs/generated/code/Magento/Framework/App/Http/Interceptor.php(39): MagentoFrameworkAppHttpInterceptor->___callPlugins('catchException', Array, Array) #28 /usr/local/apache/htdocs/vendor/magento/framework/App/Bootstrap.php(261): MagentoFrameworkAppHttpInterceptor->catchException(Object(MagentoFrameworkAppBootstrap), Object(Zend_Db_Statement_Exception)) #29 /usr/local/apache/htdocs/index.php(39): MagentoFrameworkAppBootstrap->run(Object(MagentoFrameworkAppHttpInterceptor)) #30 {main}

2

Answers


  1. try to check that database admin_newapmasala and table core_config_data inside that database exist. Check magento db configuration app/etc/env.php , amy be db configuration was changed by someone, or database was erased.
    Thanks,
    Pavel S.

    Login or Signup to reply.
  2. try and check weather you installed magento correctly and have ran all the commands
    the following command worked for mr

    php -dmemory_limit=1G bin/magento setup:upgrade
    

    php -dmemory_limit=1G bin/magento setup:di:compile

    rm -rf pub/static/frontend/

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

    php bin/magento cache:clean

    chmod -R 777 pub/static/

    chmod -R 777 generated/

    chmod -R 777 var/

    chown -R www-data:www-data generated/

    chown -R www-data:www-data var

    chown -R www-data:www-data pub/static/

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search