dtr Posted March 6, 2006 Posted March 6, 2006 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
cannuck1964 Posted March 6, 2006 Posted March 6, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.