Coupon has 1064 error

Hi
I have version 1.3.7
I have gone to create Coupons and at the top of the page it reads

Warning: Division by zero in /home/apsorgau/public_html/join/admin/includes/classes/split_page_results.php on line 48
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_products, 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.The MySQL version is 5.0.27-standard

I checked that the Maximum Values in Admin/Configuration were all greater than 0.

Can someone help please? :smile:

Mel

mySQL v.5.0.x builds used to be problematics in the past. I'd recommend to send a support ticket note to your web hosting service by requesting an upgrade to the latest version of mySQL v5.x.

Mel, the SQL error you reported seems to have been constructed based on a setting of 0 in your admin area. It shouldn't have anything to do with your MySQL version on your server.

In Admin->Configuration->GV Coupons, what is your setting for "Maximum Discount Coupons Per Page" ?
It really should be set to something greater than 0. The default is 20.

Thank you DrByte.

I did as you suggested and changed it to 1.

I have now gone up to Gift Certificate/Coupons and the option of Coupon Admin is not there! Mmmm, must be doing something wrong ...

Mel

apster:

I have now gone up to Gift Certificate/Coupons and the option of Coupon Admin is not there!That means you've turned off the Coupon system.

Admin->Modules->Order Total->Discount Coupons ... click Install if it's not already enabled.

OK, thanks so much.
PS. My cart is working very nicely. It has been a pleasure to configure compared to other carts.
A credit to you all.