Error Message Associated with Customer Review

[AnitaB]

I received a review I approved through my admin, but I cannot see it on my website. When I click on "Reviews [more]" in the review box on my website, I get the following message:

-4 -3 -2 -1 0
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 9
in:
[SELECT r.reviews_id, left(rd.reviews_text, 100) AS reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name FROM zen_reviews r, zen_reviews_description rd, zen_products p, zen_products_description pd WHERE p.products_status = '1' AND p.products_id = r.products_id AND r.reviews_id = rd.reviews_id AND p.products_id = pd.products_id AND pd.language_id = 1 AND rd.languages_id = 1 AND r.status = 1 ORDER BY r.reviews_id DESC limit -0, 0]

Can anyone help me figure out what I need to do?
Thanks in advance!!

[AnitaB]

A little more information to the above post:

The above error only appears after I change the status of the review to "Enable". When the review is disabled and I click on "Reviews [more]", the message I get is "There are currently no product reviews."

[AnitaB]

Can anyone help me figure out what I need to do to reconcile the above error message so that the customer reviews are visible on my zen cart?

Thanks in advance!!

[DrByte]

...for the right syntax to use near '-0, 0' ...

In Admin->Configuration->Maximum Values, what settings do you have set to 0? And why?
Do any of those relate to Reviews? If yes, try setting it to 10 instead.

[AnitaB]

I don't recall setting it to zero, but it was! And I changed the value as you indicated, and it works now!!

whew...I thought I had been hacked!