MYSQL error on paging. or sql error

[mleeney]

Hi When i select sanyo from my manafacturer dropdown I have 22 items in the list. The first page shows fine when I select page 2 i get the following 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 'order by pd.products_name limit 20, 20' at line 1

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '10' order by order by pd.products_name limit 20, 20

 

you can see the error at

 

http://www.projectorsandparts.co.uk/index....t=2a&page=2

 

The highlighted part of the query doesn't seem right to me. I am using a template version of oscommerce by 7dana i have updated split_page_results.php in includes/classes and admin/includes/classes with the current release but that hasn't worked.

 

Help would be appreciated.

 

Thanks

 

Martin

[burt]

Contact Template Vendor.

[mleeney]

I tried that but nothing happened.