SQL syntax error in creating discount coupons

[Del]

I have the following problem when creating discount coupons.
Problem:
Admin ..> Gift Certificate/Coupons ..> Coupon Admin
Generates this error

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, 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_p roducts, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from zen_coupons where coupon_active='Y' and coupon_type != 'G' limit -0, 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.


Environment:
Zen Cart version: 1.3.7.1
Database Patch Level: v1.3.7.1 [2007-07-24 18:21:19] (Fresh Installation)
PHP Version: 5.2.3 (Zend: 2.2.0)

Mysql
Active Persistent Links 0
Active Links 1
Client API version 5.0.45
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient

Client API version 5.0.45

Server Host: web304.opentransfer.com (76.163.252.84)
Server OS: Linux 2.6.18-53.1.7.el5.erekPAE
Database Host: mysql301.ixwebhosting.com (76.162.254.148)
HTTP Server: Apache/1.3.37 (Unix) mod_throttle/3.1.2 FrontPage/5.0.2.2635 mod_psoft_traffic/0.2 mod_ssl/2.8.28 OpenSSL/0.9.8b

Action taken:
Looked at the code /zencart/admin/coupon_admin.php

Not being a coder I did not see anything wrong.
Renamed the file and then went to the support site and downloaded
zen-cart-1.3.7.1-full-patched-07052007.zip extracted the coupon-admin.php file and uploaded to the web server.

Tried the Admin ..> Gift Certificate/Coupons ..> Coupon Admin
Again and got the same error.

Any ideas

[DrByte]

Admin->Configuration->GV Coupons->Maximum Discount Coupons Per Page ... set it to something NOT 0 and NOT blank.

[Del]

Thanks that did the trick. would never guessed.

Love working with the zen cart

Del