Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Posts
    3
    Plugin Contributions
    0

    Default Help with Installing Discount Coupon

    I don't know what I did wrong.

    I have installed it from the Order Total Module, and when I go to the Gift Certificate/Coupon, I got this message:

    "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 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."

    Help!

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Help with Installing Discount Coupon

    Looks like you have upgraded to v1.3.8 and do not have the field coupon_zone_restriction in the coupons table ...

    How did you do the upgrade?

    Did you upgrade your database?
    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.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Dec 2008
    Posts
    3
    Plugin Contributions
    0

    Default Re: Help with Installing Discount Coupon

    I didn't do the upgrade so I'm not sure how it got upgraded to the v1.3.8 and not sure if the database has been upgraded or not.
    How can I found out?

    I'm very new to zen cart and if you could provide me with a few pointers, that would be awesome!

    Thank you!

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Help with Installing Discount Coupon

    You might want to read through the /docs directory that came with your Zen Cart software ...

    If you do not have this, you can download a clean Zen Cart v1.3.8 to obtain this ...

    NOTE: Before upgrading, you will want to backup your database first ...
    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.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. v139h Need help with group discount + restricted coupon
    By abcisme in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 9
    Last Post: 4 Apr 2014, 02:12 PM
  2. Replies: 6
    Last Post: 19 Jun 2011, 07:06 AM
  3. Discount coupon help
    By ddagmij in forum General Questions
    Replies: 0
    Last Post: 15 Aug 2010, 07:05 PM
  4. Discount Price per item with Free Shipping with Coupon Code?
    By JRayfield in forum Setting Up Specials and SaleMaker
    Replies: 9
    Last Post: 2 Mar 2010, 03:15 PM
  5. Need help with 1st Discount coupon
    By zerocool in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 5
    Last Post: 29 May 2007, 01:10 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR