Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

new product error out of nowhere


leahwest

Recommended Posts

everything on my clients site was working fine and now when i click on the product category i get this error message

 

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 = '67'

 

what happened and how do i fix it? thanks in advance. if you want to see it in action its at www.nattieb.com

Link to comment
Share on other sites

everything on my clients site was working fine and now when i click on the product category i get this error message

 

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 = '67'

 

what happened and how do i fix it? thanks in advance. if you want to see it in action its at www.nattieb.com

There are a few threads about this, here is one of them.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...