power Posted February 16, 2005 Share Posted February 16, 2005 Ive deleted all the default product's and now im getting these errors can anybody please help me out this is the first time ive tried setting this up and im lost!!! 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 '-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] Specials Products Products Price Status 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 '-20, 20' at line 1 select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20 [TEP STOP] 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 '-20, 20' 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 -20, 20 [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted February 16, 2005 Share Posted February 16, 2005 how did u delete things? Link to comment Share on other sites More sharing options...
power Posted February 16, 2005 Author Share Posted February 16, 2005 in the admin section i deleted all the Categories / Products so i could add my own and then i got those errors on the reveiws,specials,products expected Link to comment Share on other sites More sharing options...
power Posted February 16, 2005 Author Share Posted February 16, 2005 ive also just found this error when i clicked on tools it is showing at the top of the page Error: Backup directory does not exist. Please set this in configure.php. Link to comment Share on other sites More sharing options...
Guest Posted February 16, 2005 Share Posted February 16, 2005 you need to create the backups directory, per the knowledge base Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.