Complete Osc Noob Needs Help

[StayGold]

Hi to all! I posted this post earlier but i think in the wrong forum , so excuse me "double posting" , i tried to move my post , but couldn't make it work.

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

[Qihun]

here is a good way to solve problems with osc

[StayGold]

Hi and thanks for your links...

I tried all, i editted the code as being explained, but still the same error messsages :angry:

I have absolutely no idea what the problem could be... my server indeed is myql5.

But like i said, i did the replacement of the code snippets but unfortunately no solution yet!

[Qihun]

may be you have cache function enabled. See this in admin panel and clean cache from browser as well.

 

this what i can think of

[StayGold]

Well... i think it's solved now... Again thanks for your help miclosh!