Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

errors in SQL syntax


dtr

Recommended Posts

Posted

Hi all, if anybody could offer me a bit of assistance it would really help my case, i don't seem to be getting anywhere :-(

 

I have errors when I enter 3 sections from my shop/admin. When I click on Reviews or Specials or Products Expected the errors below show up. I don't think its a problem in these files themselves but perhaps something that they are referencing. I just don't understand what to look for and I've spent hours looking but I don't think I'm getting there.

 

Please help and save my site!

 

thx

DT

 

 

 

Reviews

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

 

 

Specials

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

 

Products Expected

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

Posted

These are related to a mysql version issue. Get the MS2 security fixes put out by the devbelopment team here:

 

http://www.oscommerce.com/forums/index.php?sho...40entry806270

 

is the topic covering this contribution

 

cheers

Peter M

Peter McGrath

-----------------------------

See my Profile (click here) for more information and to contact me for professional osCommerce support that includes SEO development, custom development and security implementation

Archived

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

×
×
  • Create New...