I am receiving this error sometimes also, just received it now AFTER ADDING ITEM TO CART::
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 'or z2g.zone_id = 0 or z2g.zone_id IS NULL ) ' at line 5
SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id= or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id= or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="GR775"
[TEP STOP]
I also noticed in the admin panel, for the discount Amount: i typed in 10.00
and saved it
and then re-open and it shows it like this : 10.0000000
with a bunch of zeros after, could this be the problem? how do i fix?
see problem below, coupon is supposed to subtract $10.00 fixed amount, but it is not doing that!
products (Edit) Tax Total
1 x ************* 0% $0.00
1 x ************* 7.75% $5.48
1 x ************* 7.75% $6.25
1 x ************* 7.75% $11.95
Billing Information
Billing Address (Edit)
********
Payment Method (Edit)
Check/Money Order
Sub-Total: $1.69
Discount Coupon C002 applied: -$21.99
CA TAX 7.75%: $0.10
United States Postal Service (PRIORITY (2 - 3 Days)): $5.20
Total: $6.99