Categories not linking to products

[Terry Mitchell]

Hi guys

 

I hope someone can help me - I'm sure its a simple mistake I've made during the migration process. After migrating the categories links in the left hand column just bring up a [TEP STOP] error. I'm also having the same problem with the labels(manufacturers) search facility directly underneath in the same column.

 

Here's my url....

 

http://theelectric-underground.com/catalog/default.php

 

If anyone's got any ideas would be much appreciated.

 

Thanks in advance

 

Terry

[spax]

The full error is actually

 

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

 

[TEP STOP]

 

you just can't see it all as the text is black.

 

You have a very old version of osC, which, at least, isn't compatible with the MySQL 5 that your new host uses. You have a lot of patching to do. This link will start you off but you would be advised to download your entire site and do it on your PC. You should always keep a backup anyway.

 

http://www.oscommerce.com/ext/update-20051113.html

 

If you haven't already got a local environment set up, you will need something like XAMPP also so you can view php files.

 

http://www.apachefriends.org/en/xampp.html

[spax]

Just thinking about it, I'm not sure if that update page I linked to will be totally helpful to you. It is for MS2 where your files are MS1. You have default.php instead of index.php, for example. Check it anyway but like I said before, keep copies of any file you are going to change. That includes the database.

If it isn't any good for you, you may need to consider using the latest update of RC2.

[Terry Mitchell]

Just thinking about it, I'm not sure if that update page I linked to will be totally helpful to you. It is for MS2 where your files are MS1. You have default.php instead of index.php, for example. Check it anyway but like I said before, keep copies of any file you are going to change. That includes the database.

If it isn't any good for you, you may need to consider using the latest update of RC2.

 

Ok!!

 

Thanks so much for your help - I'm on it!!

 

I'll come screaming if I need any more help.

 

Thanks again

 

Terry