Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

error 1064


Recommended Posts

I have this errothat pops up and i was wondering if it was related to PHP5. this is waht i get:


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


I get this error on about a dozen pages. It only shows when the page i'm looking at is trying to list something that there are not any of. For example i deleted all of the Special off my new install and when the last one was gone i got that error. I does it on a few other pages too. This is weird. I just don't get it.


Because of the error i can't add more of what ever i don't have so i'm sort of screwed.

Every thing else works just fine though.


What's wrong? :blink:

Link to comment
Share on other sites

There is a contrib (and at least a few threads) on getting osC to work properly under PHP5. Have you installed the contrib and read the threads?



Link to comment
Share on other sites


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

  • Create New...