Zen Follower
- Join Date:
- Jan 2007
- Posts:
- 226
- Plugin Contributions:
- 0
Erro after installing Auspost V3.02 - 1146 Table zen_geo_zones' doesn't exist
Hello,
I currently have an issue that occurred after I installed the old Auspost mod.
In Admin --> Localisation --> Zone Definitions, it has the error message:
1146 Table 'ironboy_zc1.zen_geo_zones' doesn't exist
in:
[select count(*) as total from zen_geo_zones]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
And when I try to create a new product, it produces a blank space (where I normally would be able to create my product).
The admin debugging tool doesn't produce anything in the cache folder.
And in the source code for the 'create new products' page, it has the following at the bottom:
"<div class="systemError">1146 Table 'ironboy_zc1.zen_zones_to_geo_zones' doesn't exist<br />in:<br />[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 = '13')
AND (za.zone_id IS NULL OR za.zone_id = 0
OR za.zone_id = '189')
AND tr.tax_class_id = '1'
GROUP BY tr.tax_priority]<br />If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br /></div>
Does anyone know a fix for this - I would be happy just to get rid of the Auspost mod if it will fix the issue.
Does anyone know how to delete it totally?
Thanks for any help.
Kind regards,
Anthony