Coupon error code

Locked

Started by henrietta on 5 Jun 2009, 8:55 PM · Views: 2,680

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
5 Jun 2009, 8:55 PM
#1
henrietta avatar

henrietta

New Zenner

Join Date:
Mar 2007
Location:
WAY out West
Posts:
86
Plugin Contributions:
0

Coupon error code

I have Zen 1.3.7

Trying to set up a coupon on a cart that previously had none.
I have installed the discount coupons module and get this message

Warning: Division by zero in /home/xxxxyz/public_html/xxx/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,' 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, ]
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.

I cant find a zero anywhere near line 48 in the **split_page_results.php
nor can I find the text "**select coupon_id" anywhere in that file.

Removed the module and reinstalled with no change.
Replaced the file on the server and reinstalled module with no change.

A clue for the clueless would be appreciated.
Thanks

Henrietta

7 Jun 2009, 4:29 AM
#2
henrietta avatar

henrietta

New Zenner

Join Date:
Mar 2007
Location:
WAY out West
Posts:
86
Plugin Contributions:
0

Re: Coupon error code

I renamed coupon_admin.php to oldcoupon_admin.php and uploaded coupon_admin.php from the original file set. This gave me a new drop down menu in the Gift Certificate/Coupons tab in the dashboard (which had not been there before.)

I then deleted oldcoupon_admin.php

Next I went to the Configuration tab >> GV Coupons and put the number 20 in both Maximum Discount Coupons per page and Maximum Discount Coupon Report Results per page.

This removed the error message.

I do not know which of my actions removed the error code.

Henrietta

7 Jun 2009, 4:08 PM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Coupon error code

If you set the Maximums to 20 and they were 0, that is part of the problem ...

Reloading the file: coupon_admin.php could have corrected other issues ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

28 Oct 2009, 11:09 PM
#4
bonkycat avatar

bonkycat

New Zenner

Join Date:
Aug 2009
Location:
Washington State
Posts:
54
Plugin Contributions:
0

Re: Coupon error code

Hello,

Using:
Zen Cart 1.3.8a
Patch: 1::

Had the exact error message as original poster.

I applied the second part of the original poster's solution:
"Next I went to the Configuration tab >> GV Coupons and put the number 20 in both Maximum Discount Coupons per page and Maximum Discount Coupon Report Results per page."

And this solved the problem for me.

Thanks!:bigups: