We have used the coupon module for six months without any problems. Then suddenly we started getting a warning message:

user warning: Unknown column 'products' in 'field list' query: INSERT INTO uc_coupons (name, code, value, type, status, valid_until, max_uses, products, users, roles, minimum_order) VALUES ('Test Coupon 2', 'TEST002', '10', 'percentage', '1', '1242802800', '0', '0', '', '1', 0) in /[site path]/includes/database.mysql.inc on line 174.

Nothing changed on our site except upgrade to Drupal 5.17.

I updated the uc_coupons module to the latest version and am still getting that error.

Any help would be much apprecaited.

Comments

TSE’s picture

TSE commented

same thing here, supscribing

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented

Did you run update.php after upgrading the module? If the update doesn't work with the default settings, try selecting version 1 from the uc_coupon dropdown and updating again.

TSE’s picture

TSE commented

many thX longwave,

"Did you run update.php after upgrading the module? If the update doesn't work with the default settings, try selecting version 1 from the uc_coupon dropdown and updating again."

worked fine, everything is ok now.

TSE

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Status: Active » Fixed
jdblank’s picture

jdblank commented
Status: Fixed » Closed (fixed)

That worked for me too!