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