Magento Forum

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘main_table.label’ in ‘order clause’
 
ROTABS
Jr. Member
 
Avatar
Total Posts:  6
Joined:  2009-02-23
 

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘main_table.label’ in ‘order clause’

Trace:
#0 /home4/shoppit8/public_html/par31shopnew/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home4/shoppit8/public_html/par31shopnew/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home4/shoppit8/public_html/par31shopnew/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT `main_ta...’, Array)
#3 /home4/shoppit8/public_html/par31shopnew/lib/Varien/Db/Adapter/Pdo/Mysql.php(337): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT `main_ta...’, Array)
#4 /home4/shoppit8/public_html/par31shopnew/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home4/shoppit8/public_html/par31shopnew/lib/Varien/Data/Collection/Db.php(787): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /home4/shoppit8/public_html/par31shopnew/lib/Varien/Data/Collection/Db.php(700): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /home4/shoppit8/public_html/par31shopnew/lib/Varien/Data/Collection/Db.php(621): Varien_Data_Collection_Db->getData()
#8 /home4/shoppit8/public_html/par31shopnew/lib/Varien/Data/Collection.php(729): Varien_Data_Collection_Db->load()
#9 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Sales/Model/Order/Config.php(158): Varien_Data_Collection->getIterator()
#10 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Adminhtml/Model/System/Config/Source/Order/Status.php(46): Mage_Sales_Model_Order_Config->getStateStatuses(’new’)
#11 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Adminhtml/Block/System/Config/Form.php(399): Mage_Adminhtml_Model_System_Config_Source_Order_Status->toOptionArray(false)
#12 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Adminhtml/Block/System/Config/Form.php(204): 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))
#13 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Adminhtml/Block/System/Config/Edit.php(92): Mage_Adminhtml_Block_System_Config_Form->initForm()
#14 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(101): Mage_Adminhtml_Block_System_Config_Edit->initForm()
#15 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Adminhtml_System_ConfigController->editAction()
#16 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(’edit’)
#17 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#18 /home4/shoppit8/public_html/par31shopnew/app/code/core/Mage/Core/Model/App.php(340): Mage_Core_Controller_Varien_Front->dispatch()
#19 /home4/shoppit8/public_html/par31shopnew/app/Mage.php(627): Mage_Core_Model_App->run(Array)
#20 /home4/shoppit8/public_html/par31shopnew/index.php(80): Mage::run(’’, ‘store’)
#21 {main}

got this when updating to 1.5 , what can i do, googled but no succes yet

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top