1064 - You have an error in your SQL syntax

[Tomee]

On the product listing page the first page shows up correctly, but when you click on the next button or page number 2,3... it gives you this sql error.

 

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 'p.products_sort_order , pd.products_name asc' at line 1

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id = '37'p.products_sort_order , pd.products_name asc

 

The page in question can be accessed here, if anyone wants to see the problem live: http://www.hana.ro/sso/index.php?cPath=25_37

 

It is a modified product_listing.php page but a tried with the original nad it gives me the same error... :( any ideea where should I look or for what ? All other next page links works fine, as I checked them.

 

Thanks in advance !

[♥stubbsy]

take a look here, there is a whole topic related to this error

 

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

 

HTH

 

Dave