Product reviews error message

[Derek Bryant]

Hi

When enabling product reviews and writing a sample review, I get the following error mesage when trying to submit:

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 6
in:
[SELECT r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name FROM reviews r, reviews_description rd WHERE r.products_id = 6 AND r.reviews_id = rd.reviews_id AND rd.languages_id = 1 and r.status = 1 ORDER BY r.reviews_id desc limit -0, 0]

please can anyone help

Derek

[Ajeh]

Go to your Zen Cart Admin and look in the Configuration ... Maximum Values ... where you will find a few settings addressing Reviews ...

Make sure that these are not set to 0 ...

[Derek Bryant]

thanks Ajeh Oba-san

the "New products review number per page" was set to 0

thanks again

Derek

[Ajeh]

Not a problem ...

Thanks for posting back that the issue was do to one of your configuration settings where the Maximum Value was set to 0 ...