drock Posted December 11, 2006 Posted December 11, 2006 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' [TEP STOP] anyone know how you fix this problem or know what it is :)
jdvb Posted December 11, 2006 Posted December 11, 2006 guessing you installed easy coupon or some contribution alike? done that correctly?
drock Posted December 11, 2006 Author Posted December 11, 2006 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?
jdvb Posted December 11, 2006 Posted December 11, 2006 kinda doubt that, since the hole table used does not exist in a default oscomerce install, or I would be way offffffff
drock Posted December 11, 2006 Author Posted December 11, 2006 Bump anyone have any idea how to fix the problem :)
jdvb Posted December 11, 2006 Posted December 11, 2006 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).
drock Posted December 12, 2006 Author Posted December 12, 2006 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
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.