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

[baukiki]

osCommerce 2.2-MS2

 

I moved my site to another hosting company. I copied everything and database is uploaded correctly. I set the config file correctly.

 

Website open up very well. registration, admin area everything.... but there is one problem

 

This error appeared on every Subcategory page:

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

 

[TEP STOP]

 

 

The top category works fine...only the subcategory

 

Please help.

 

Baukiki

[MrPhil]

If you had done a search before asking, you would have found that this is a very common problem caused by an incompatibility with MySQL version 5. The fix is very easy: http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors

 

P.S. 2.2 MS2 is way, way, way old. Upgrade to 2.2 RC2a. Search for suggestions on security improvements. Consider looking at the github development repository for the latest changes and fixes.

[satish]

osCommerce 2.2-MS2

 

I moved my site to another hosting company. I copied everything and database is uploaded correctly. I set the config file correctly.

 

Website open up very well. registration, admin area everything.... but there is one problem

 

This error appeared on every Subcategory page:

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

 

[TEP STOP]

 

 

The top category works fine...only the subcategory

 

Please help.

 

Baukiki

 

Apply Mysql5 patches for osCommerce.

 

Satish