Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help with errors when show a products


Guest

Recommended Posts

Posted

Hello forum.

I need please some help with some errors when Im add products on categories, I upload a picture with specification then go and make a click on Mens clothes and the picture with specifications doesn't show up, something show on page like:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total 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 = '62'

 

Please let me know what I have to do to fix the problem.

 

Thank you so much

Posted
Hello forum.

I need please some help with some errors when Im add products on categories, I upload a picture with specification then go and make a click on Mens clothes and the picture with specifications doesn't show up, something show on page like:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total 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 = '62'

 

Please let me know what I have to do to fix the problem.

 

Thank you so much

Look here

Posted

Woww, Thank you so much you are so nice and fast too,

and thanks to all forum too.

Archived

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

×
×
  • Create New...