Face Posted February 17, 2006 Posted February 17, 2006 Hey guys, new to the forum here. Installed osCommerce last night and I receive the following errors when selecting options from Administration: Administration>>Products Expected: Products Date Expected Action 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 '-6, 6' 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 -6, 6 [TEP STOP] I get a similiar message in the Reviews selection of Administration... Administration>>Reviews Products Rating Date Added Action 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 '-6, 6' at line 1 select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -6, 6 [TEP STOP] I'm not sure how to fix this, or if I should continue on the site if I should have to start over. I've tried installing twice (virgin install - no tweaks) with the same errors. Any help is appreciated!
kgt Posted February 17, 2006 Posted February 17, 2006 Read the last comment: http://www.oscommerce.com/community/bugs,1605 Contributions Discount Coupon Codes Donations
Face Posted February 17, 2006 Author Posted February 17, 2006 Read the last comment: http://www.oscommerce.com/community/bugs,1605 You, my friend - saved the day! Thanks!!!! :P
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.