Coupon Admin not working after Update.
I knew it: No update without trouble :) This one I have just found out after i had my shop updated 3 weeks ago and it was running find, cuz i didn't check the coupon admin. Wehn I enter the coupon admin on my I get the following error and don't know what the heck is wrong there:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS' at line 1
[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 zen_coupons where coupon_active='Y' and coupon_type != 'G' limit -0, MAX_DISPLAY_SEARCH_RESULTS_DISCOUNT_COUPONS]
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.
Please Please help me.
By CascianoLtd in forum Setting Up Categories, Products, Attributes
Last Post: 30 Jun 2009, 05:05 AM
By stomm in forum Currencies & Sales Taxes, VAT, GST, etc.
Last Post: 18 Jun 2009, 02:55 PM
By jeking in forum Creating Discounts/Coupons, Gift Certificates, Newsletters
Last Post: 11 Nov 2008, 07:41 PM
By chillout_buddha in forum General Questions
Last Post: 24 Jul 2008, 02:27 AM
By paperthreads in forum Templates, Stylesheets, Page Layout
Last Post: 16 Oct 2007, 03:30 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC