Help! Error when trying to add zone to my Table Shipping Module

[Tiff13]

I was trying to make my table rate be for US only. My Tables shipping modules were working fine. But when I added the Zone US to one of them I get this error and can't even modify in ADMIN now to remove that module. Please help no one can place orders now.

 

1146 - Table 'waybent1_hoashop2.TABLEPREMIUM_ZONES_TO_GEO_ZONES' doesn't exist

 

select zone_id from TABLEPREMIUM_ZONES_TO_GEO_ZONES where geo_zone_id = '2' and zone_country_id = '' order by zone_id

[germ]

When you get UPPERCASE_ERRORS like that it normally means you're missing a define in a php file somewhere.

 

In this case you're probably missing the define for TABLEPREMIUM_ZONES_TO_GEO_ZONES in /includes/database_tables.php.

 

It will need defined in the catalog and admin files.

[Tiff13]

When you get UPPERCASE_ERRORS like that it normally means you're missing a define in a php file somewhere.

 

In this case you're probably missing the define for TABLEPREMIUM_ZONES_TO_GEO_ZONES in /includes/database_tables.php.

 

It will need defined in the catalog and admin files.

 

Thank you ... so now I get

1054 - Unknown column 'geo_zone_id' in 'where clause'

[Tiff13]

Never mind .... i found a tiny spelling error in my sql table ....ugh!!

 

OK breathing again

Thank you Jim - Live Saver!