Can’t login in admin: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘sdjzuser_mgtd.sales_order’ doesn’t exist

Please LogIn to Reply!

Post By: admin | 26-01-2012 06:35 Reply

 

Since a few days I get this error when I try to login in the backend of my Magento webshop. I can’t remember changing anything that could cause this error. The strange thing is the error only shows up in Firefox. Internet Explorer and Safari just return to the login page.

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘sdjzuser_mgtd.sales_order’ doesn’t exist

Trace:
#0 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT SUM((mai...’, Array)
#3 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT SUM((mai...’, Array)
#4 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Zend/Db/Adapter/Abstract.php(706): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Varien/Data/Collection/Db.php(707): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Varien/Data/Collection/Db.php(620): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /home/sdjzuser/domains/tasjesdieven.nl/public_html/lib/Varien/Data/Collection/Db.php(590): Varien_Data_Collection_Db->getData()
#8 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Adminhtml/Block/Dashboard/Totals.php(68): Varien_Data_Collection_Db->load()
#9 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Block/Abstract.php(218): Mage_Adminhtml_Block_Dashboard_Totals->_prepareLayout()
#10 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Model/Layout.php(430): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#11 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Adminhtml/Block/Dashboard.php(45): Mage_Core_Model_Layout->createBlock(’adminhtml/dashb...’)
#12 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Block/Abstract.php(218): Mage_Adminhtml_Block_Dashboard->_prepareLayout()
#13 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Model/Layout.php(430): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#14 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Model/Layout.php(446): Mage_Core_Model_Layout->createBlock(’adminhtml/dashb...’, ‘dashboard’)
#15 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Model/Layout.php(238): Mage_Core_Model_Layout->addBlock(’adminhtml/dashb...’, ‘dashboard’)
#16 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Model/Layout.php(204): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#17 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Model/Layout.php(209): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#18 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(343): Mage_Core_Model_Layout->generateBlocks()
#19 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(270): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#20 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Adminhtml/Controller/Action.php(263): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)
#21 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(40): Mage_Adminhtml_Controller_Action->loadLayout()
#22 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_DashboardController->indexAction()
#23 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#24 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#25 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#26 /home/sdjzuser/domains/tasjesdieven.nl/public_html/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#27 /home/sdjzuser/domains/tasjesdieven.nl/public_html/index.php(78): Mage::run(’’, ‘store’)
#28 {main}

`Reply Or Comment!
Please LogIn to Reply!