Forums / General Questions / Coupon Restriction

Coupon Restriction

Locked

Started by enzo_ita on 28 Nov 2010, 8:05 PM · Views: 1,700

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
28 Nov 2010, 8:05 PM
#1
enzo_ita avatar

enzo_ita

Zen Follower

Join Date:
Jul 2009
Posts:
402
Plugin Contributions:
0

Coupon Restriction

Hi,
I have a problem with coupons.
I can enter coupons without problems, but when I try to set a restriction I get this error message:

"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, MAX_DISPLAY_RESTRICT_ENTRIES' at line 1
in:
[select * from coupon_restrict where coupon_id = '17' and category_id != '0' limit -0, MAX_DISPLAY_RESTRICT_ENTRIES]
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 am not able to understand the sense of this message.
How can I fix this?
Thanks
enzo

29 Nov 2010, 2:19 AM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Coupon Restriction

Peek at this thread:
http://www.zen-cart.com/forum/showthread.php?t=169079&highlight=MAX_DISPLAY_RESTRICT_ENTRIES

and see if that helps you on this ... sounds like a missing define statement ...

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!

29 Nov 2010, 8:28 AM
#3
enzo_ita avatar

enzo_ita

Zen Follower

Join Date:
Jul 2009
Posts:
402
Plugin Contributions:
0

Re: Coupon Restriction

Aaand that just did it!!!!
Thanks a million.
enzo