Got problem with my link to categories n manufacturers

[conselfa]

hi all!! i'm a new user here...after installing osC, the page comes out, then ok. but when i go to the link ( categories n manufacturers) on the left side of the page, this errors appear-->

 

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

 

i've install 2 templates from osC b4, but i still got this same problem with my link.

can anyone plss help me!!

thnx

[tarheit]

You may want to check out the bug (and fix) here:

http://www.oscommerce.com/community/bugs,3259

 

-Tim

[conselfa]

You may want to check out the bug (and fix) here:

http://www.oscommerce.com/community/bugs,3259

 

-Tim

 

thanks tim!! i've already fix the problem.

recently after installing new template, i have this warning...

 

Warning: The sessions directory does not exist: /tmp. Sessions will not work until this directory is created.

 

can u pls help me how to get rid of this??

 

-mior-