database error after migration to another host provider

[Guest]

Hello,

 

I had to move my shop to another machine due to owner's changes. Unfortunatelly after copying all oscommerce structure and dumping database to new location, the following errors appears while going down into subcategories through category tree:

 

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 = '141')

 

Same happens when I try to use a search function:

 

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

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%ol%' or p.products_model like '%ol%' or m.manufacturers_name like '%ol%') )

 

I appreciate your help on that issue.

 

Regards,

Wojciech

[Guest]

Hello,

 

I had to move my shop to another machine due to owner's changes. Unfortunatelly after copying all oscommerce structure and dumping database to new location, the following errors appears while going down into subcategories through category tree:

 

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 = '141')

 

Same happens when I try to use a search function:

 

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

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%ol%' or p.products_model like '%ol%' or m.manufacturers_name like '%ol%') )

 

I appreciate your help on that issue.

 

Regards,

Wojciech

What version MYSQL was on your old machine and what version MYSQL is on your new?

[Guest]

What version MYSQL was on your old machine and what version MYSQL is on your new?

 

new one is 5.x, old one probably 3.x

 

regards,

Wojciech

[Guest]

new one is 5.x, old one probably 3.x

 

regards,

Wojciech

There's your problem. Check out this contribution http://addons.oscommerce.com/info/4654

[Guest]

There's your problem. Check out this contribution http://addons.oscommerce.com/info/4654

 

Thanks a lot, I appreciate your support. My problem is solved :)

 

regards,

Wojciech