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
