Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Specials. Error Message


hunty3

Recommended Posts

I am trying to set up a couple of specials on my site but I am getting this error message

 

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

 

Any advice would be appreciated.

 

Thanks

 

Chris

Link to comment
Share on other sites

this is probably a database problem - the place to start would be to run the your mysql backup for those tables mentioned. or if its a new install redo the mysql upload.

 

hope that helps

Link to comment
Share on other sites

Follow the first link in my signature block below.

 

There is a patch in it for the -20, 20 problem

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...