Problem wirh Coupon Admin

[BreaJR]

I thought I had all of my problems sorted out after my upgrade tp 1.3.6, but it looks like there is one more. When I lick on the Coupon Admin I get this under Discount Coupons:

1054 Unknown column 'coupon_zone_restriction' in 'field list' in:
[select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p roducts, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from store_coupons where coupon_active='Y' and coupon_type != 'G' limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Something may have been corrupted in the upload, but I don't know what files to reupload.

Any Help is appreciated.

Thanks, Jack

[Ajeh]

When you did the Upgrade, did you Upgrade the database with /zc_install

If you go to /zc_install and click on Upgraded database ... are any of the boxes checked?

If so, backup your database then run the Updates that are checked 1 by 1 ...

Does this if the problem?

Peek via phpMyAdmin at your database to see what the structure of the coupons table looks like ... as it appears you are missing an update to the table and do not have a new field in there called: coupon_zone_restriction

[BreaJR]

As far as I remember, when I upgraded the database all went well. Everything was back as it was before the upgrade. At this point, the store has been open and selling for the past 2 weeks, so I do not want to try upgrading the database with the backup copy as it will wipe out all of the newacconts.

Is there a way to add this field to the existing database without deleting any of the entries that are there now? Or are you saying to backup my exsiting database now, then run the installer again to fix this problem?


Jack

[DrByte]

Is there a way to add this field to the existing database without deleting any of the entries that are there now? Or are you saying to backup my exsiting database now, then run the installer again to fix this problem?

Yes -- that should resolve it.

[BreaJR]

OK, thank you very much. I will do this on Saturday evening which is the slowest time for the store. I will report back then as to the success I have.

Jack

[DrByte]

Of course, be sure to use the v1.3.6 version of the zc_install folder in order to do this.

And of course, make a full database backup before doing the upgrade.