1054 error?

[xtreme-mobile]

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

[FIMBLE]

i take it that its from a contribution?

Look over the install instructions for am SQL update, either with the instructions as a few lines or as a separate file

[xtreme-mobile]

been through it twice but could t find any faults, ive un installed and will reinstall again see if it works

[xtreme-mobile]

still no better, there is definatly nothing wrong with the contribution.

 

just wont let show products

 

any ideas?

[xtreme-mobile]

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?