Site loads but not store

[booghaboobaby]

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?

[DrByte]

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.