Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    11
    Plugin Contributions
    0

    database error 1054 Error - Coupon Code Zones - HELP!!!

    When I try to run the Coupon Admin I get this error:

    1054 Unknown column 'coupon_zone_restriction' in 'field list'

    Sure enough, this column doesn't exist in the zc_coupons table.

    The question is...why not?

    If someone can tell me the specifics (type, length, etc.) I can add it, but I'm really wondering why it isn't there already - ZC is otherwise great for me.

    I'm using Zen Cart 1.3.5.

    Many thanks!

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1054 Error - Coupon Code Zones - HELP!!!

    The zone-restrictions feature for coupons was added in Zen Cart v1.3.6.

    Since you're using v1.3.5, I'm not surprised that you'd be having problems if you're using code snippets from a newer version.

    Have you installed an addon that changed the /admin/coupon_admin.php file but isn't compatible with your version of Zen Cart?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. How to perform bulk import of coupon codes? Getting error code 1054.
    By rmickus in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 25
    Last Post: 1 Dec 2012, 03:04 PM
  2. coupon code error
    By wowemall in forum Addon Payment Modules
    Replies: 0
    Last Post: 6 Jun 2012, 11:03 AM
  3. ccavenue coupon code error
    By wowemall in forum Addon Payment Modules
    Replies: 0
    Last Post: 31 May 2012, 09:06 AM
  4. Coupon error code
    By Henrietta in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 3
    Last Post: 29 Oct 2009, 12:09 AM

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