Complete Osc Noob Needs Help :blink:

[StayGold]

Hi to all! I'm a complete OSC noob and the only thing i know is how to install, add products and such.

But right now i'm getting some error messages which i can't explain...

This is one of them...( i get these when i click on a category)

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

 

[TEP STOP]

 

I'm getting these everytime i click on a category and even when entering the shop i get such a message at the right hand side of my site.

Can someone maybe put me in the right direction with this?

Thanks in advance! The site is to be found at www.staygoldstudio.com/kgb

Greets Roy

[Jack_mcs]

Take a look at this.

 

Jack