Forums / Installing on a Windows Server / failed install of Auspost module - now a geo table error

failed install of Auspost module - now a geo table error

Locked
Results 1 to 2 of 2
This thread is locked. New replies are disabled.
25 Dec 2008, 06:47
#1
bacc avatar

bacc

New Zenner

Join Date:
Dec 2008
Posts:
1
Plugin Contributions:
0

failed install of Auspost module - now a geo table error

Hi
As a new user I thought I was doing well and had the site basically running until I tried (without success) installing the Auspost module.

Now I get the following error message on nearly every page and get a blank page when I try to add new products. I've removed every mention of Auspost I can find. Stupidly, I hadn't backed up all of the recent work.

Any help please!



1146 Table 'strike zone.geo_zones' doesn't exist
in:
[select sum(tax_rate) as tax_rate from (tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join 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 = '13') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '185') and tr.tax_class_id = '1' group by tr.tax_priority]
26 Dec 2008, 01:00
#2
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Posts:
6,263
Plugin Contributions:
3

Re: failed install of Auspost module - now a geo table error

bacc:

Hi
As a new user I thought I was doing well and had the site basically running until I tried (without success) installing the Auspost module.

Now I get the following error message on nearly every page and get a blank page when I try to add new products. I've removed every mention of Auspost I can find. Stupidly, I hadn't backed up all of the recent work.

Any help please!


1146 Table 'strike zone.geo_zones' doesn't exist
in:
[select sum(tax_rate) as tax_rate from (tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join 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 = '13') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '185') and tr.tax_class_id = '1' group by tr.tax_priority]


Question: What else did you install (or try to install) besides the Austpost module?

I ask, because the austpost (improved) module has absolutely no connection or relationship with the geo_zones tables.

*However* if the austpost module that you tried to install was the original version (not the improved version) there IS a connection, in which case I can't really help due to lack of experience in this area).

Cheers
RodG