My host changed to a new server and now I'm getting this error on one of my zencart sites:

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id='116' AND cd.categories_id='116' AND cd.language_id='1' LIMIT 1]

The site is http://megaturnkeys.com

My host says its the script and they don't offer support for zencart, I don't think its the script because I have several other zencart sites that are working just fine. I actually copied this site to another and the other one is working fine.

I appreciate any help or advise.