Please help Categories problem

[ewd]

I have a problem with my catergories page. It is the only page that I'm having trouble with. here is my error

[error]

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 = '22'[/error]

[minghoo]

I have a problem with my catergories page. It is the only page that I'm having trouble with. here is my error

[error]

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 = '22'[/error]

 

 

i assume you are talking about admin/categories.php,

 

open the file in notepad or dreamweaver, it seems you miss the p. p.products_id on some lines.

[ewd]

Its not the file admin/catogories.php just the catorgories.php file. And where exactly should I add the p.products_id line? Thanks I'm really confised as the rest of the site views fine and I can even view the products and add them to the cart I just can't see the main catofiers page.