1054 Unknown column error

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.

Did you review the Similar Threads at the bottom of this page?

I'm assisting someone right now with that same error message. I have reviewed the responses and some speak to data base corruption.

The error seems to indicate that you'd want to check out the parent_id on the category table. I've done that and it's there, any other suggestions?

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

FYI, things were working fine a few days ago; they are saying it's the Ultimate SEO url's module but once I disable it and clear the cache that should fix it shouldn't it? Also, just for more information, the hosting provider is Wired Tree

what version of the cart
what version of mysql

also if using seo urls turn OFF the display category