SQL syntax 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 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

[Guest]

Check your query strig. you have 2 order by. That could be the problem.

 

order by order by pd.products_name limit 20, 20

[mleeney]

Check your query strig. you have 2 order by. That could be the problem.

 

order by order by pd.products_name limit 20, 20

 

 

Thanks Brian I did see that but I don't know where that query string exsists in the coding. Do you?

[pvarsha]

Hi martin,

 

The following thread can help you :

http://www.oscommerce.com/forums/index.php?sho...p;mode=threaded

 

there is a patch to avoid this problem in oscommerce.

 

pvarsha

[mleeney]

Hi martin,

 

The following thread can help you :

http://www.oscommerce.com/forums/index.php?sho...p;mode=threaded

 

there is a patch to avoid this problem in oscommerce.

 

pvarsha

Hi Pvarsha,

 

Thank you for the info but I already tried it and it didn't work. I have fixed the problem now by replacing index.php in the catalog with the latest version of oscommerce and that fixed it.

 

Thanks

 

M