Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Click a category and get error


Recommended Posts

This is very strange - when I click on any category in my menu and am redirected to default.php?cpath=XX I get this error:


Let's See What We Have Here



1064 - You have an error in your SQL syntax near 'select pd.products_name, p.products_image, p.products_quantity, p.products_weigh' at line 1


select count(select pd.products_name, p.products_image, p.products_quantity, p.products_weight, 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_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' order by pd.products_name) as total





the default.php page presents correctly when not calling category


any idea on where to even start????

Link to comment
Share on other sites


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

  • Create New...