Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Upgrade from 1.5.1 to 1.7.2 = SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘sr.website_ids’ in ‘on clause’
 
jaming
Jr. Member
 
Total Posts:  4
Joined:  2007-12-19
 

Hi I can get the site back up by running cron.php but when i refresh the cache I get this error message. Please if anyone has any info that will help thanks in advance.

Error in file: \"/home/farmer/public_html/app/code/core/Mage/SalesRule/sql/salesrule_setup/upgrade-1.6.0.2-1.6.0.3.php\" - SQLSTATE[42S22]: Column not found: 1054 Unknown column \’sr.website_ids\’ in \’on clause\’

Trace:
#0 /home/farmer/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception(\’Mage_Core\’, \’Error in file: ...\’)
#1 /home/farmer/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb(\’upgrade\’, \’1.6.0.2\’, \’1.6.0.3\’)
#2 /home/farmer/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(\’1.6.0.2\’, \’1.6.0.3\’)
#3 /home/farmer/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/farmer/public_html/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/farmer/public_html/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
#6 /home/farmer/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home/farmer/public_html/index.php(87): Mage::run(\’\’, \’store\’)
#8 {main}

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