Coupon_redeem doesn't exist

I get the following error when I try and upgrade I've searched through the posts, and from what I can gather is that this needs to be created in the database. Is this correct? and if it is, can anyone let me know how to do this.

Any help would be great, thanks.

what have you upgraded to?

coupon_reddem table is removed.

I am trying to upgrade from 1.2.6 to 1.2.8

I'm still having no luck with this, anyone got any ideas of what to do to fix this problem?

Hi,

I had this same problem in a locally tested site after upgrading.

The only way i found to fix it so you can import your backup sql file, is to go into phpmyadmin ( or whatever you use to manage/edit the database) and create an additional table called coupon_redeem (if you have an old database to look at, see what fields are needed by clicking on the coupon_redeem table). Then import your sq l backup via admin. Then go back into phpmyadmin and drop the coupond_redeem table you just created.

After that take another backup of your sql file and everything should be Ok if you need to import it again.

WARNING: BE VERY CAREFUL WHEN EDITING THE DATABASE AS YOU MAY END UP DESTROYING IT

hope that helps
Ian (rincerofwinds)

I'm getting this error message when testing a coupon:

Coupon is ethier invalid, expired or reached its usage limit!

Using v1.2.8 - I've checked the start/end dates and double checked the coupon codes I created in the Admin section. Does anyone have a fix for this or any ideas as to why?

Thanks.

After further investigation it doesn't seem when a coupon is created in the admin area that it is written to the proper database tables for coupons.

try setting date start to a previous date.

I just tested the system myself and its working fine.

i thinbk you must have made the eerro your self some how.

Thank you. That seems to have done it.

Thanks again.