Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Click a category and get error


rubygirl

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

 

[TEP STOP]

 

 

the default.php page presents correctly when not calling category

 

any idea on where to even start????

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...