1064 Error in MS2.2

[aharzand]

I'm running OSC MS2.2 and I'm receiving the following error anytime I click to view "page 2" of products in a category.

 

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 'order by p.products_recent_sales desc, pd.products_name desc limit 20, 20' at line 1

 

Can anyone help or offer any suggestions? Thanks.

[Mav666]

Have you tried this: Magic Knowledge Link

[♥geoffreywalton]

You could also try the updates.

 

Here is the index of my updates fle.

 

osCommerce 2.2 Milestone 2 Update 051113

Update Package 13th November 2005

 

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

Table of Contents

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

 

## Update 051113

 

customer_country_id in addressbook

 

## Update 051112

 

Cannot re-assign $this

limit -20, 20

Database Input Enhancement

Adding Non-Existing Products To Cart

Session ID XSS Issue

Validate Session ID

File Manager Problem

HTTP Header Injection

E-Mail Header Injection

Contact Us Form XSS Issue

Open Redirector

Extra Slashes In New Products

Order Status Filtering

MySQL 5.0 Compatibility

 

This is a link to a later one

 

http://www.oscommerce.com/ext/update-20060817.txt

[muadmz]

Im sorry but how do I install the updates? Do I have to do a fresh installation? Or do I have to upload a few files and overwrite the existing ones? If so which ones?

 

Sorry Im not used to this and have tried reading all of the post I found by searching on this error, but nothing helped. Tried changing the split_page_results.php page codes a bit as well as shown in some posts in this forum.. but again didnt help.

 

I still get the following error at the bottom of my main page:

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

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 '' at line 1

 

select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit

 

[TEP STOP]

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