Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

MYSQL error on paging. or sql error


Recommended Posts

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




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.





Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...