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

Cannot checkout Due to coupon code error
 
diybrewing
Jr. Member
 
Total Posts:  26
Joined:  2008-11-06
 

So I think that I finally have gotten the upgrade working but now when you go to check out I get the following error,

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘coupon_code’ in ‘field list’

I cannot figure out why this is happening? Any clues?

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

I have similar problem.
The issue is with a broken upgrade file mysql4-upgrade-0.7.11-0.7.12.php.
You have to run the file manually on your database . I am think how I can do it.

$installer $this;
/* @var $installer Mage_Sales_Model_Mysql4_Setup */
$installer->startSetup();
$installer->getConnection()->changeColumn($this->getTable('sales/order'), 'coupon_code''coupon_code''varchar(255) DEFAULT NULL');
$installer->endSetup();

Any help is appreciated

 
Magento Community Magento Community
Magento Community
Magento Community
 
DCAlmeida
Sr. Member
 
Avatar
Total Posts:  164
Joined:  2008-12-28
PRT
 

Remove Reward Points extension!

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

I dont have the reward point extension. It is just a corrupt upgrade and if I can run the code on my database it will work.

Just trying to figure out what is the sql to run .

 
Magento Community Magento Community
Magento Community
Magento Community
 
DCAlmeida
Sr. Member
 
Avatar
Total Posts:  164
Joined:  2008-12-28
PRT
 

How do you upgrade? Ftp and the full package or via Magento Connect?

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

Upgraded via ssh Pear upgrade
Once upraded I could not access the admin or front end because it was showing an error.
So checked the error reports and problem was caused by the file mysql4-upgrade-0.7.11-0.7.12.php
So deleted that file from app/code/core/Mage/Core/sql/core_setup
and got the admin and front end back .  Done index updates etc and thought website was working fine.
Then we started getting order failures SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘coupon_code’ in ‘field list’

So the guess is ther is some sorta field added during the update wich has not been added . So just trying to figure how how can manually do manually by phpmyadmin

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

Thank you power PT for your time and quick replies

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

This issue is sorted now.
Created a new field in sales_order named coupon_code varchar 255 default null .
and now working perfect.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dltr_org
Sr. Member
 
Avatar
Total Posts:  167
Joined:  2008-09-12
rockdale, sydney, australia
 
onesimpleman - 01 March 2010 04:10 PM

This issue is sorted now.
Created a new field in sales_order named coupon_code varchar 255 default null .
and now working perfect.

wow thats a life saver. Thanks.

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