cancel
Showing results for 
Search instead for 
Did you mean: 

Error when clicking on Payment Methods

Error when clicking on Payment Methods

When clicking on Payment Methods on the Configuration page i get this error.

 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'photocha_magento64.sales_order_status' doesn't exist, query was: SELECT `main_table`.*, `state_table`.`state`, `state_table`.`is_default` FROM `sales_order_status` AS `main_table`
 LEFT JOIN `sales_order_status_state` AS `state_table` ON main_table.status=state_table.status WHERE (state_table.state='new') ORDER BY `main_table`.`label` ASC

Trace:
#0 /home/photocharms/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/photocharms/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/photocharms/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/photocharms/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /home/photocharms/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /home/photocharms/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 /home/photocharms/public_html/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 /home/photocharms/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 /home/photocharms/public_html/lib/Varien/Data/Collection/Db.php(572): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /home/photocharms/public_html/lib/Varien/Data/Collection.php(741): Varien_Data_Collection_Db->load()
#10 /home/photocharms/public_html/app/code/core/Mage/Sales/Model/Order/Config.php(173): Varien_Data_Collection->getIterator()
#11 /home/photocharms/public_html/app/code/core/Mage/Adminhtml/Model/System/Config/Source/Order/Status.php(46): Mage_Sales_Model_Order_Config->getStateStatuses('new')
#12 /home/photocharms/public_html/app/code/core/Mage/Adminhtml/Block/System/Config/Form.php(463): Mage_Adminhtml_Model_System_Config_Source_Order_Status->toOptionArray(false)
#13 /home/photocharms/public_html/app/code/core/Mage/Adminhtml/Block/System/Config/Form.php(229): Mage_Adminhtml_Block_System_Config_Form->initFields(Object(Varien_Data_Form_Element_Fieldset), Object(Mage_Core_Model_Config_Element), Object(Mage_Core_Model_Config_Element))
#14 /home/photocharms/public_html/app/code/core/Mage/Adminhtml/Block/System/Config/Form.php(164): Mage_Adminhtml_Block_System_Config_Form->_initGroup(Object(Varien_Data_Form), Object(Mage_Core_Model_Config_Element), Object(Mage_Core_Model_Config_Element))
#15 /home/photocharms/public_html/app/code/core/Mage/Adminhtml/Block/System/Config/Edit.php(92): Mage_Adminhtml_Block_System_Config_Form->initForm()
#16 /home/photocharms/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(107): Mage_Adminhtml_Block_System_Config_Edit->initForm()
#17 /home/photocharms/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_System_ConfigController->editAction()
#18 /home/photocharms/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('edit')
#19 /home/photocharms/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))
#20 /home/photocharms/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#21 /home/photocharms/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#22 /home/photocharms/public_html/index.php(83): Mage::run('', 'store')
#23 {main}

I have only 250 tables, the last table being 'persistent_session'

 

I have reinstalled the database previously and still only get 250 tables, reinstalling is not ideal as we have imported customer data from another store. Ideally we would like to write the new tabes.

 

Any help would be great

1 REPLY

Re: Error when clicking on Payment Methods

Bump, any help?