cancel
Showing results for 
Search instead for 
Did you mean: 

Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exit

Highlighted

Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exit

Hi,

I am currently facing an issue related to page crash and after sometimes page crash issue is resolved automatically.

System Errors:
a:5:{i:0;s:251:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'safecol_mstaging.mg_catalog_category_flat_store_1' doesn't exist, query was: SELECT `mg_catalog_category_flat_store_1`.`entity_id` FROM `mg_catalog_category_flat_store_1` WHERE (entity_id='6')";i:1;s:5154:"#0 /home/safecol/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/safecol/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/safecol/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/safecol/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `mg_cata...', Array)
#4 /home/safecol/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `mg_cata...', Array)
#5 /home/safecol/public_html/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `mg_cata...', Array)
#6 /home/safecol/public_html/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(1357): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select))
#7 /home/safecol/public_html/app/code/core/Mage/Catalog/Model/Category.php(671): Mage_Catalog_Model_Resource_Category_Flat->checkId('6')
#8 /home/safecol/public_html/app/code/core/Mage/Catalog/Helper/Category.php(74): Mage_Catalog_Model_Category->checkId('6')
#9 /home/safecol/public_html/app/code/core/Mage/Catalog/Block/Navigation.php(133): Mage_Catalog_Helper_Category->getStoreCategories()
#10 /home/safecol/public_html/app/code/local/Smartwave/Megamenu/Helper/Data.php(55): Mage_Catalog_Block_Navigation->getStoreCategories()
#11 /home/safecol/public_html/app/code/local/Smartwave/Megamenu/Helper/Data.php(126): Smartwave_Megamenu_Helper_Data->getMenuData()
#12 /home/safecol/public_html/app/design/frontend/smartwave/porto/template/smartwave/megamenu/html/mobilemenu.phtml(7): Smartwave_Megamenu_Helper_Data->getMobileMenuContent(NULL)
#13 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/safecol/p...')
#14 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/smartw...')
#15 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#16 /home/safecol/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#17 /home/safecol/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#18 /home/safecol/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('mobile.nav', true)
#19 /home/safecol/public_html/app/design/frontend/smartwave/safe/template/page/html/header_type2.phtml(81): Mage_Core_Block_Abstract->getChildHtml('mobile.nav')
#20 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/safecol/p...')
#21 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/smartw...')
#22 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#23 /home/safecol/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#24 /home/safecol/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#25 /home/safecol/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('header', true)
#26 /home/safecol/public_html/app/design/frontend/smartwave/porto/template/page/2columns-left.phtml(43): Mage_Core_Block_Abstract->getChildHtml('header')
#27 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/safecol/p...')
#28 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/smartw...')
#29 /home/safecol/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#30 /home/safecol/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#31 /home/safecol/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#32 /home/safecol/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#33 /home/safecol/public_html/app/code/local/Smartwave/Ajaxcatalog/controllers/Catalog/CategoryController.php(111): Mage_Core_Controller_Varien_Action->renderLayout()
#34 /home/safecol/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Smartwave_Ajaxcatalog_Catalog_CategoryController->viewAction()
#35 /home/safecol/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#36 /home/safecol/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#37 /home/safecol/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#38 /home/safecol/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#39 /home/safecol/public_html/index.php(83): Mage::run('', 'store')
#40 {main}";s:3:"url";s:41:"/stamp-collecting-supplies?album_type=235";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

Please let me know what kind of fix help me to get it fix

Thanks

1 REPLY

Re: Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exit

Faced this issue previously , i have resolved it by doing reindexing. referr below links !!

 

https://magento.stackexchange.com/questions/112128/how-to-get-rid-of-base-table-or-view-not-found-11...

 

Also refer this - https://stackoverflow.com/questions/19398361/magento-catalog-category-flat-store-1-does-not-exist

if issue solved,Click Kudos & Accept as Solution