Site loads but not store

I just moved the site from one hosting to another and all the data and info moved perfectly except one item. I am getting the following error when I click on the store link:

1146 Table 'scp1131401305352.zen_zones_to_geo_zones' doesn't exist
in:
[select sum(tax_rate) as tax_rate from (zen_tax_rates tr left join zen_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zen_geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) ) where (za.zone_country_id is null or za.zone_country_id = 0 or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '1') and tr.tax_class_id = '1' group by tr.tax_priority]

I checked if the table actually exists and it does so I'm thinking there is another issue? I did analyze and repair and it is reporting fine. Anyone have any ideas?

If it's saying the table doesn't exist, then ... it doesn't exist.

So, maybe what you "checked" was a table by a different name, or in a differently-named database than what your Zen Cart store is actually accessing.