Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 error?


xtreme-mobile

Recommended Posts

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

 

[TEP STOP]

 

thats all i get when going to a subcategory where there should be a product

 

any ideas whats causing it? all ive installed is a template and the Ultimate seo URLs mod thats it

 

cheers

 

dean

Visit my website in my profile for prices on woodburning stoves

Link to comment
Share on other sites

ive even changed the theme to a new skin thinking it was a dodgy skin i installed but its the same again.

 

Is there another mod that works similar to ultimate seo urls?

Visit my website in my profile for prices on woodburning stoves

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...