New Zenner
- Join Date:
- Oct 2010
- Location:
- ireland
- Posts:
- 23
- Plugin Contributions:
- 0
Coupon Admin - 1064 You have an error in your SQL syntax
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,' at line 1
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 coupons where coupon_active='Y' and coupon_type != 'G' limit -0, ]
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.
Hi,
I am a newbie, with very little knowledge of sql etc :(
Version 1.3.9h upgraded recently from g.
add-on installed is jgallery
all changes made to site have been using the override with my own template.
I only recently started on zen cart and have been trying every aspect of the cart before going live...
i tried this evening to open coupon admin as part of this process and got the error message above...i'm lost... can anyone help me with this?
i went through the upgrade process from 1.3.9g to 1.3.9h a couple of days back, and it all seemed to work ok, so im unsure whether or not this has caused the issue. i don't know because this is my first time trying to use the coupon admin feature
thanks
donal