Problem after migration, need help

[mlowrey]

Dear,

 

I have moved the shop to a new server, with the last mysql5 and php5.

 

Only when i try to make a search i get this error:

 

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 = '5' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%test%' or p.products_model like '%test%' or m.manufacturers_name like '%test%') )

 

[TEP STOP]

 

And with m PDF document contribution, when i click on make pdf ( of the productpage) i get this error:

 

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

 

select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.products_status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, s.expires_date, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id where p.products_id = '860' and p.products_id = pd.products_id and pd.language_id = '5'

 

[TEP STOP]

 

 

 

any help would be great !

[FIMBLE]

Hello

You need this

http://www.oscommerce.com/community/contributions,4654

[FIMBLE]

Yep it does

This one

 

http://addons.oscommerce.com/info/5321