AUSTPost module

[Lissy]

thanks Rod.
You were quite right, 2 files had been overwritten when the new module was installed, so goodbye postal information.
I have no idea how to merge 2 php files, but I went through them line by line and did a cut and paste to add in the post stuff and it seems to be fine again.
Phew!

[anaesthesiac]

Hi,

i've attempted unsuccessfully to install the AusPost module on my ZenCart 1.38. I've followed the instructions to the letter in the readme files and now i can't view any products i have, nor can i add new products. One of the error messages i'm getting is:

1146 Table 'sitesynt_sukastore.geo_zones' doesn't exist
in:
[select geo_zone_id, geo_zone_name from geo_zones order by geo_zone_name]
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.


Another error message is:

1146 Table 'sitesynt_sukastore.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]


This "geo_zones" error comes up consistantly. As i said i read through the instructions, checked the sql database, installed the files and now i'm at a loss what to do.


Any help anyone could give me would be GREATLY appreciated, i'm starting to think it's beyond repair.

Cheers.

[RodG]

i've attempted unsuccessfully to install the AusPost module on my ZenCart 1.38.
<snip>
As i said i read through the instructions, checked the sql database, installed the files and now i'm at a loss what to do.

1. AusPost (The module you are using) and AustPost (the topic of this thread) are NOT the same (or even related) modules.

AusPost is very ancient, and hasn't been updated since zencart V1.3.0. (July 2006). Only AusPost uses GeoZones.

AustPost is a newer module that works with zencart V1.3.7 & 1.3.8. It doesn't use GeoZones.

2. AustPost is now also obsolete (no updates since Feb 2008). It has been superceded by 'ozpost'.

http://www.zen-cart.com/index.php?ma...oducts_id=1286

I suggest you uninstall your AusPost module(s) and install ozpost instead.

Cheers
Rod

[anaesthesiac]

Thanks a lot for the info, i am new to ZenCart and have only worked with the graphic side of design before, this is an amazing system but aside from HTML and a tiny bit of PHP it kinda gets over my head.

I appreciate you taking the time to respond, i'll install the new module and hopefully the system will be functioning again.

cheers

[anaesthesiac]

I've installed the OZPOST module, but in my ADMIN section i can't add or change products. By installing the outdated AUSPOST addon i think i've damaged something, i get this error message any time i try to add or change a product:

1146 Table 'sitesynt_sukastore.geo_zones' doesn't exist<br />in:<br />[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]

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.

My question now is, can i fix this? or do i need to re-install ZenCart? It has affected the products in the ADMIN section and on the WEBSITE itself.

Any advice would be appreciated.

Cheers
Shayne

[RodG]

By installing the outdated AUSPOST addon i think i've damaged something, i get this error message any time i try to add or change a product:
<snip>
1146 Table 'sitesynt_sukastore.geo_zones' doesn't exist<br />in:<br
My question now is, can i fix this? or do i need to re-install ZenCart? It has affected the products in the ADMIN section and on the WEBSITE itself.

Any advice would be appreciated.

Cheers
Shayne

You shouldn't need to re-install zen-cart, but you certainly do need to uninstall the original AusPost module, along with any other changes or patches that you applied (or attempted to apply) when installing it.

Cheers
Rod