Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Join Date
    Jun 2006
    Location
    Melbourne, VIC
    Posts
    99
    Plugin Contributions
    0

    Default Coupons no longer working.

    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.

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    64,717
    Plugin Contributions
    6

    Default Re: Coupons no longer working.

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

    Did you Upgrade your database AFTER making a backup of it?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  3. #3
    Join Date
    Jun 2006
    Location
    Melbourne, VIC
    Posts
    99
    Plugin Contributions
    0

    Default Re: Coupons no longer working.

    Quote Originally Posted by Ajeh View Post
    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.

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    64,717
    Plugin Contributions
    6

    Default Re: Coupons no longer working.

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  5. #5
    Join Date
    Jun 2006
    Location
    Melbourne, VIC
    Posts
    99
    Plugin Contributions
    0

    Default Re: Coupons no longer working.

    Quote Originally Posted by Ajeh View Post
    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.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    64,717
    Plugin Contributions
    6

    Default Re: Coupons no longer working.

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  7. #7
    Join Date
    Jun 2006
    Location
    Melbourne, VIC
    Posts
    99
    Plugin Contributions
    0

    Default Re: Coupons no longer working.

    Quote Originally Posted by Ajeh View Post
    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.

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    64,717
    Plugin Contributions
    6

    Default Re: Coupons no longer working.

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  9. #9
    Join Date
    Jun 2006
    Location
    Melbourne, VIC
    Posts
    99
    Plugin Contributions
    0

    Default Re: Coupons no longer working.

    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.

  10. #10
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    64,717
    Plugin Contributions
    6

    Default Re: Coupons no longer working.

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Mass edit of coupons
    By stevehare in forum Creating Discounts/Coupons, Gift Certificates, Newsletters
    Replies: 4
    Last Post: 20 Oct 2006, 06:53 PM
  2. Problems Setting Up Coupons
    By j-slice in forum Creating Discounts/Coupons, Gift Certificates, Newsletters
    Replies: 6
    Last Post: 29 May 2006, 01:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •