Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 Error using reviews


Recommended Posts

Hi, I have seen some forum postings for 1064 errors which relate to either products new or similar but my errors are when trying to do a product review.


I am guessing from what I have read that I need to change something in the database but can anyone tell from my error which part I need to change.


The error is showing as:


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 1

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 = '218' and 
r.reviews_id = rd.reviews_id and  rd.languages_id = '1' order by r.reviews_id desc limit -0, 0


Thanks, Michael

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...