1054 error?

[Alexi99]

I am making a new storefront, no fancy add-ons or modules. I add a new manufacturer, category and product with picture and description. When I go to the catalog site, and click on the category in the upper left corner,

I get this error message:

 

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'

 

[TEP STOP]

 

But if I click on the product image in the What's New area, the product comes up fine.

each time I go back to a category I get same error

 

What have I not done?

Alex

[Jan Zonjee]

What have I not done?

Using the latest version: osCommerce 2.2 Milestone 2 Update 060817 for your new shop.

[jpweber]

What you have not done is you have not upgraded your store for PHP 5.0, which your host is using! It's okay .... Follow this link: http://www.oscommerce.com/community/contributions,4654/ and download that contribution, follow the instructions. You'll need to make a minor change to your catalog/index.php page, and some others. This might be an immediate fix. But ....

 

Additionally, however, you MUST download the 060817 update located here: http://www.oscommerce.com/solutions/downloads and this will update your OSC so it's current and ready for php 5.0.

 

Good luck.