Coupons no longer working.

**Peter Homann** · 8 Feb 2007, 01:16 AM

Hi,

I upgraded from 1.3.5 to 1.3.7 last week. I thought everyting was fine, But, when I went to Admin-> Coupon Admin, none of my coupons were displayed.

Instead the following error was displayed above the heading.

Code:

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_products, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from zen_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.

Can anyone help out please.

Cheers,

Peter.

**Ajeh** · 8 Feb 2007, 02:09 AM

Sounds like you did not upgrade your database with the /zc_install

Did you Upgrade your database AFTER making a backup of it?

**Peter Homann** · 8 Feb 2007, 02:33 AM

Originally Posted by Ajeh

Sounds like you did not upgrade your database with the /zc_install

Did you Upgrade your database AFTER making a backup of it?

Hi Linda,

Thanks for the reply. I did the upgrade via fantastico that creates a backup. After the upgrade, Zencart complained that the DB was at ver 1.3.6 so I uploaded ZC_install and ran that, only doing a db upgrade. Everything seemed to be OK after that.

I now realise that using Fantasticio is not required or the correct way to go.

Cheers,

Peter.

**Ajeh** · 8 Feb 2007, 02:45 AM

Thanks for the update and glad you have things back up and running ...

Fantastico is nice for a test run or a first install ... but after that it is best to manage things on your own with nice clean downloads via the Downloads link at the top of your screen ...

**Peter Homann** · 8 Feb 2007, 03:39 AM

Originally Posted by Ajeh

Thanks for the update and glad you have things back up and running ...

Fantastico is nice for a test run or a first install ... but after that it is best to manage things on your own with nice clean downloads via the Downloads link at the top of your screen ...

Hi Linda,

No things are not OK.

I ran the ZC_Install after I did the Fantastico installation and I though all was well.

Today I discovered that the coupons are not working.

I had a look in the database by using phpMyAdmin, (I'm using cpanel) and the field 'coupon_zone_restriction' does not exist.

Is it possible to insert it into the database? Mind you I'm no database developer.

Also I looked in the Fantastico backup, no database.

Thanks

Peter.

**Ajeh** · 8 Feb 2007, 03:42 AM

Make sure you loaded all the files for Zen Cart v1.3.7 to your site ...

Backup your database ...

Re-run the Upgrade Database ...

See who is checked ... and run each 1 by 1 ...

Then ...

Check your Discount Coupons ...

If you have restrictions ... add the Restriction for:

Top Category Deny

This should get them running again ...

**Peter Homann** · 8 Feb 2007, 03:57 AM

Originally Posted by Ajeh

Make sure you loaded all the files for Zen Cart v1.3.7 to your site ...

Backup your database ...

Re-run the Upgrade Database ...

See who is checked ... and run each 1 by 1 ...

Then ...

Check your Discount Coupons ...

If you have restrictions ... add the Restriction for:

Top Category Deny

This should get them running again ...

I re-ran the upgrade database, just to see what was checked, and none of the database upgrades a checked. It indicates that the database is at 1.3.7

Cheers,

Peter.

**Ajeh** · 8 Feb 2007, 04:01 AM

For giggles ... backup your database and run the Upgrade Database and check the checkbox for:
Upgrade DB from 1.3.6 to 1.3.7

You will recieve messages on things done but it should also fix the things not done ...

**Peter Homann** · 8 Feb 2007, 04:14 AM

OK, did that but no joy...

Messages were;
at top of DB Upgrade page

Code:

12 statements processed.
Note: 7 statements ignored. See "upgrade_exceptions" table for additional details.

at bottom of DB Upgrade page

Code:

SKIPPED: Cannot insert configuration_key "USE_SPLIT_LOGIN_MODE" because it already exists
SKIPPED: Cannot ADD column customers_paypal_payerid because it already exists.
SKIPPED: Cannot ADD column customers_paypal_ec because it already exists.
SKIPPED: Cannot insert configuration_key "CC_ENABLED_SOLO" because it already exists
SKIPPED: Cannot insert configuration_key "CC_ENABLED_SWITCH" because it already exists
SKIPPED: Cannot insert configuration_key "CC_ENABLED_MAESTRO" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists
SKIPPED: Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists

Thanks,

Peter.

**Ajeh** · 8 Feb 2007, 04:37 AM

Are you sure you have the right database and prefix being used?

Look at your database in phpMyAdmin and make sure you are using the same database in both configure.php files:
/includes/configure.php
/admin/includes/configure.php

Same prefix, server, database, username, password, domain and paths ...