Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 Error using reviews


offie

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

[TEP STOP]

Thanks, Michael

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...