Transfer from plesk to cpanel, my categories have stopped working

[lightercompany]

Hello all.

 

I'm still a newbie on the forum but I wonder if I can ask your help.

 

I bought the following website a while ago which was being hosting on plesk.

 

http://www.lightercompany.co.uk

 

I've had it transfered to cpanel on a different server.

 

The seo optimised links are activated and the product pages appear however the category pages dont.

 

Can anyone please advice me if they have any idea what the problem could be?

 

It comes up with the following error

 

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

 

When I hover above a category link, I get the following, does it look correct? http://www.lightercompany.co.uk/-c-125.html

 

If its a .htaccess problem, can you let me know exactly what I should put in there?

 

Cheers Mally

[diy]

Hello all.

 

I'm still a newbie on the forum but I wonder if I can ask your help.

 

I bought the following website a while ago which was being hosting on plesk.

 

http://www.lightercompany.co.uk

 

I've had it transfered to cpanel on a different server.

 

The seo optimised links are activated and the product pages appear however the category pages dont.

 

Can anyone please advice me if they have any idea what the problem could be?

 

It comes up with the following error

 

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

 

When I hover above a category link, I get the following, does it look correct? http://www.lightercompany.co.uk/-c-125.html

 

If its a .htaccess problem, can you let me know exactly what I should put in there?

 

Cheers Mally

 

try looking in thiw thread http://www.oscommerce.com/forums/index.php?showtopic=230304 and this contrib http://www.oscommerce.com/community/contributions,4654

and check the mysql version on your new server