FlawedKid Posted April 27, 2006 Posted April 27, 2006 I have just done a fresh install and when I view the 'Reviews' and 'Products Expected' pages in my admin i get the following errors: On the reviews page: 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 '-4, 4' at line 1 select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -4, 4 And on the products expected page i get this as well: 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 '-4, 4' at line 1 select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -4, 4 I have looked through the forums and there was a post for a simular problem but with -20,20. But I have no idea how to fix these errors. I'd appreciate any help.
kgt Posted April 27, 2006 Posted April 27, 2006 http://www.oscommerce.com/forums/index.php?showtopic=144095 Contributions Discount Coupon Codes Donations
Recommended Posts
Archived
This topic is now archived and is closed to further replies.