Upgrade problems (Again)

[Guest]

Ok, so moved to a different server due to a couple of features we wanted to make use of (such as an external link for price updates etc) and now i'm getting this error message

 

 

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

[TEP STOP]

 

http://www.cleantech.co.uk/catalog/index.php?cPath=22_56

 

 

the error only appears on the catogory pages, product descriptions, home page etc all work perfectly, and i really can't work out whats going on.

 

i'm not sure in that query what the ",products p" part is about either, just seems to be trying to do a lot of things in one query to simply return a total.

 

now - here is the thing, i have manually checked the info in the database, and all tables and indeed the info held in those tables seems to be 100% in tact, but i ran a repair table on each one mentioned anyway, just to be sure.

 

The site is, and was before the move running on php 5, but the new host is running mysql 5, the old one was on 4 - so i am assuming the issue lies here, but i not sure since it only seems to be effecting the query quoted above.

[Guest]

nobody got any thoughts?

 

Been messing around some more with this, and i STILL really can't figure it out.