Hello,
when login admin, I get this error below. I have no backup and noone could help me with this. Please try your best to find a solution to fix this error. Site works find, but i need to login admin to make changes and updates. Please help!!!!!
There has been an error processing your request
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘pcs_maindb.catalogsearch_query’ doesn’t exist
Trace:
#0 /home3/pcs/public_html/includes/src/__default.php(47388): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home3/pcs/public_html/includes/src/__default.php(39317): Zend_Db_Statement->execute(Array)
#2 /home3/pcs/public_html/includes/src/__default.php(40338): Zend_Db_Adapter_Abstract->query(‘SELECT COUNT(*)…’, Array)
#3 /home3/pcs/public_html/includes/src/__default.php(41088): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT COUNT(*)…’, Array)
#4 /home3/pcs/public_html/includes/src/__default.php(39648): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home3/pcs/public_html/includes/src/__default.php(26602): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#6 /home3/pcs/public_html/includes/src/__default.php(25813): Varien_Data_Collection_Db->getSize()
#7 /home3/pcs/public_html/includes/src/__default.php(25799): Varien_Data_Collection->getLastPageNumber()
#8 /home3/pcs/public_html/includes/src/__default.php(26937): Varien_Data_Collection->getCurPage()
#9 /home3/pcs/public_html/includes/src/__default.php(26967): Varien_Data_Collection_Db->_renderLimit()
#10 /home3/pcs/public_html/includes/src/__default.php(27367): Varien_Data_Collection_Db->load(false, false)
#11 /home3/pcs/public_html/includes/src/Mage_Adminhtml_Block_Widget_Grid.php(484): Mage_Core_Model_Mysql4_Collection_Abstract->load()
#12 /home3/pcs/public_html/includes/src/Mage_Adminhtml_Block_Dashboard_Searches_Last.php(6 3): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()
#13 /home3/pcs/public_html/includes/src/Mage_Adminhtml_Block_Widget_Grid.php(576): Mage_Adminhtml_Block_Dashboard_Searches_Last->_prepareCollection()
#14 /home3/pcs/public_html/includes/src/Mage_Adminhtml_Block_Widget_Grid.php(582): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()
#15 /home3/pcs/public_html/includes/src/__default.php(2073): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()
#16 /home3/pcs/public_html/includes/src/__default.php(1916): Mage_Core_Block_Abstract->toHtml()
#17 /home3/pcs/public_html/includes/src/__default.php(1867): Mage_Core_Block_Abstract->_getChildHtml(‘lastSearches’, true)
#18 /home3/pcs/public_html/app/design/adminhtml/default/default/template/dashboard/index.phtml(107): Mage_Core_Block_Abstract->getChildHtml(‘lastSearches’)
#19 /home3/pcs/public_html/includes/src/__default.php(2634): include(‘/home3/pcs/publ…’)
#20 /home3/pcs/public_html/includes/src/__default.php(2670): Mage_Core_Block_Template->fetchView(‘adminhtml/defau…’)
#21 /home3/pcs/public_html/includes/src/__default.php(2687): Mage_Core_Block_Template->renderView()
#22 /home3/pcs/public_html/includes/src/Mage_Adminhtml_Block_Template.php(81): Mage_Core_Block_Template->_toHtml()
#23 /home3/pcs/public_html/includes/src/__default.php(2074): Mage_Adminhtml_Block_Template->_toHtml()
#24 /home3/pcs/public_html/includes/src/__default.php(10830): Mage_Core_Block_Abstract->toHtml()
#25 /home3/pcs/public_html/includes/src/__default.php(2074): Mage_Core_Block_Text_List->_toHtml()
#26 /home3/pcs/public_html/includes/src/__default.php(1916): Mage_Core_Block_Abstract->toHtml()
#27 /home3/pcs/public_html/includes/src/__default.php(1867): Mage_Core_Block_Abstract->_getChildHtml(‘content’, true)
#28 /home3/pcs/public_html/app/design/adminhtml/default/default/template/page.phtml(74): Mage_Core_Block_Abstract->getChildHtml(‘content’)
#29 /home3/pcs/public_html/includes/src/__default.php(2634): include(‘/home3/pcs/publ…’)
#30 /home3/pcs/public_html/includes/src/__default.php(2670): Mage_Core_Block_Template->fetchView(‘adminhtml/defau…’)
#31 /home3/pcs/public_html/includes/src/__default.php(2687): Mage_Core_Block_Template->renderView()
#32 /home3/pcs/public_html/includes/src/Mage_Adminhtml_Block_Template.php(81): Mage_Core_Block_Template->_toHtml()
#33 /home3/pcs/public_html/includes/src/__default.php(2074): Mage_Adminhtml_Block_Template->_toHtml()
#34 /home3/pcs/public_html/includes/src/__default.php(23811): Mage_Core_Block_Abstract->toHtml()
#35 /home3/pcs/public_html/includes/src/__default.php(11222): Mage_Core_Model_Layout->getOutput()
#36 /home3/pcs/public_html/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(43): Mage_Core_Controller_Varien_Action->renderLayout()
#37 /home3/pcs/public_html/includes/src/__default.php(11251): Mage_Adminhtml_DashboardController->indexAction()
#38 /home3/pcs/public_html/includes/src/__default.php(15150): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#39 /home3/pcs/public_html/includes/src/__default.php(14752): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http) )
#40 /home3/pcs/public_html/includes/src/__default.php(16949): Mage_Core_Controller_Varien_Front->dispatch()
#41 /home3/pcs/public_html/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#42 /home3/pcs/public_html/index.php(84): Mage::run(”, ‘store’)
#43 {main}
Error log record number: 262089687182
1 answer
Hi florinel,
if this issue has just happened recently then I think you can check again and revert those changes were made recently, also I just tried to access your back-end url of http://salonfurnish.com/admin but it seem does not exist, do you mind check it again.
