Hi,
I am getting a mysql error when trying to list coupons error as follows;
Code:
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 '' at line 1
in:
[select count(*) as total from coupons where coupon_active='Y' and coupon_type !=]
In configuartion my mdcpp and mdcrrpp are set at 100 each, have tried 20 and 10 and 50 to no avail.
Interestingly I am getting the following error
Code:
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 '' at line 1
in:
[select count(*) as total from]
When I select group pricing.
I am running v 1.3.8a and MySQL 4.1.22-standard and php 4.4.8.
Any thoughts other than to upgrade the code and server which I plan to do in the next couple of weeks?
Thanks
Bookmarks