Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

My SQL errors?


Recommended Posts

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

Looks like your using an older version of osCom? Check the update for a fix to your problem:




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


This topic is now archived and is closed to further replies.

  • Create New...