1054 Product Catagory Error

[hercnutrition]

Hello

 

I have installed a fresh new version of osCommerce and removed the old placeholder data so that I can upload our own products to the store.

 

I have created three categories and added 2 products to each category. I went back to the site to see how they would like and at the home page I see the items under new products and latest added. But when I click on any of the categories all I get is

 

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

 

[TEP STOP]

 

Does anyone have any idea of what this is related to? If so I would really appreciate the feedback.

 

Thanks in advance for any help

BG

[Hotclutch]

How to fix 1054 error

http://addons.oscommerce.com/info/4654

[hercnutrition]

How to fix 1054 error

http://addons.oscommerce.com/info/4654

 

Hey Ashley

 

Thanks so much. I followed things through and it is all good now. I did search for a while on the forum for info on this but with no luck.

 

Your input is greatly appreciated.

 

Brad

[ray_trace]

Perfecto.

 

Thanks for saving my butt on this one too :-)