1054 - Unknown column 'p.products_id' in 'on clause'

[Guest]

I was got this error for a few days ago:

 

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

 

[TEP STOP]

 

The error was occored whne i click on the category menu on index page.

 

And i was read the resoleve of this error on this very useful forum. But i don't do following their idea.

I just install the oscommerce store in differrent folder (on my server). For example, the existing of my store is www.a.com/shop1 , and the new store folder is www.a.com/shop2 . Then i was copy an index.php and stylesheet.css from shop2, then put them into the shop1 catalog.

After i put them, my store (www.a.com/shop1) was work properly.