1064 You have an error in your SQL syntax

Gentlemen,

the following appears while trying to restrict the coupon within the ZenCart admin panel:

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 data_coupon_restrict where coupon_id = '1' and category_id != '0' limit -0, MAX_DISPLAY_RESTRICT_ENTRIES]

Last steps i been doing before having this issue:
Moving entire zen cart (open source shopping card) onto another server, including mySQL

I assume, while reading the output, there is a new syntax necessary as of another mySQL version?

All other functions of the website are 100% working.

Thanks for your assistance

You can’t limit 0 or -0. 0 returns No values, and -0 isn’t even a number.

Sponsor our Newsletter | Privacy Policy | Terms of Service