poffa Posted January 12, 2005 Posted January 12, 2005 Why do i get this error message? :'( I try to reach the reviews page from admin and get this message. I have not changed the reviews.php. 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 '-20, 20' at line 1 select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20 [TEP STOP] Help please!
Guest Posted January 12, 2005 Posted January 12, 2005 hhhmmm...might be an issue with the pagesplit. Try adding ?page=1 to the URL and see if that takes care of it. If so, you have to look at how the query is being returned by the pagesplit class. Bobby
tuffbwoy Posted January 12, 2005 Posted January 12, 2005 http://www.oscommerce.com/community/bugs,1...abase+(General) Hope this helps... -b :thumbsup:
poffa Posted January 12, 2005 Author Posted January 12, 2005 http://www.oscommerce.com/community/bugs,1...abase+(General) Hope this helps... -b :thumbsup: <{POST_SNAPBACK}> i changed it in file split_page_results.php and it's working. thanks. tuffbwoy and chemo :D
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.