osCommerce 2.2-MS2 problems

[Tony C]

Hi everyone, a newbie needs some help :-)

my web host package comes complete with a osCommerce shop package,

 

today we decide to set up the shop,

after setting the db up and going to the shop, we noticed we are getting an error before we have even changed anything for our own use,

 

the error message we 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 = '4'

 

[TEP STOP]

 

im new to this so any help would be handy please.

[MrPhil]

You are using MySQL 5 on your server, and need to update osC. See http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors . But, before you go through the trouble, 2.2 MS2 is very very old. You'd be better off removing it and installing the final osC release of 2.2 RC2a (obtain from this site). It's likely that your host is now (or soon will be) at PHP 5, which will cause other problems with 2.2 MS2, that have already been fixed in 2.2 RC2a. The MySQL 5 fixes need to be made, either way.