Jsawyer Posted May 6, 2005 Share Posted May 6, 2005 I just installed the ccgv_v5_13 and every thing works as long as I email a voucher to a customer. I can not seem to create them when I go to the admin screen because when I do I get this SQL error: +++++++++++++++++++++++++++++++++++ Coupon Name Coupon Amount Coupon Code Action 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 '-20, 20' 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 from coupons where coupon_active='Y' and coupon_type != 'G' limit -20, 20 ++++++++++++++++++++++++++++++++++++ Have you seen this before? If so what do I need to do to correct it? TIA Josh Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.