hookahlife Posted June 25, 2006 Share Posted June 25, 2006 We have recently installed an OSCommerce template with or hosting company and are having SQL issues. Everytime we attempt to add items such as banners, newsletters, reports and many of the localization functions we experience an SQL error(copy pasted at the bottom of this post). How do we fix this??? SQL Error: 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, pd.products_viewed, l.name from products p, products_description pd, languages l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC limit -20, 20 Link to comment Share on other sites More sharing options...
Terra Posted June 25, 2006 Share Posted June 25, 2006 Looks like your using an older version of osCom? Check the update for a fix to your problem: http://www.oscommerce.com/ext/update-20051113.html Terr My code for combining PayPal IPN with ** QTPro 4.25 ** osC Affiliate ** CCGV(trad) and how to solve the invoice already paid error General info: Allow customer to delete order comment ** FTP Programs & Text Editors ** Amending order email ** 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.