Coupon has 1064 error

[apster]

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_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.

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?

Mel

[TheOracle]

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.

[DrByte]

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.

[apster]

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

[DrByte]

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.

[apster]

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.