Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Discount coupon codes HELP!!


Recommended Posts

I am trying to install the Discount coupon codes module and i am having this issue on the checkout_confirmation.php page


1054 - Unknown column 'max_use' in 'field list'


select max_use,coupons_discount_percent, min_order, number_available from discount_coupons where coupons_id = '222'




anyone know how you fix this problem or know what it is :)

Link to comment
Share on other sites

guessing you installed easy coupon or some contribution alike?

done that correctly?



Yeah i installed Discount Coupon Codes. I got it to work with another site but when i installed in on another one i got this error. could it be that i am getting this error because it is an older version of oscommerce. The site was set up in June of 06?

Link to comment
Share on other sites

I could tell you how to remove the error shown here, but somehow the contrib might then not work properly still...


in phpmyadmin insert the field max_use to the table discount_coupons. Could even write you a script that does that for you.


set the field to show a default value of 1, so every coupon code can then be used only once.

set the type of field to be int(11) (alows for numbers only).

Link to comment
Share on other sites

I resolved my issue. the person who tried to install a coupon code last left some old code in the page. I found it and removed it all and it works properly now :)


thank you for your help though

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...