Upgrading Austpost to latest on ZC1.37

[grantgee]

Hi,
currently I have Austpost v0.91 on Zencart v1.37 and am having trouble with the UK Postcode bug mentioned elsewhere in this forum .
I have no time at the moment to upgrade the whole shop and wondered if I could just upgrade the module to austpost__improved_2-1-3 and what problems might be encountered.
Thanks,
grantgee

[RodG]

Hi,
currently I have Austpost v0.91 on Zencart v1.37 and am having trouble with the UK Postcode bug mentioned elsewhere in this forum .
I have no time at the moment to upgrade the whole shop and wondered if I could just upgrade the module to austpost__improved_2-1-3 and what problems might be encountered.
Thanks,
grantgee

Wow! v0.91 its been years since that was released.

As for upgrading, you should be able to upgrade to V2.1.3 without any hassles, but I would suggest you upgrade to the 'ozpost' module instead.
http://www.zen-cart.com/index.php?ma...oducts_id=1286

This module can be installed alongside your existing postage module (although somewhat pointless) so if you do happen to run into any problems you can simply disable or uninstall it. No downtime.

Cheers
Rod

[grantgee]

Hi Rod,
thanks for your response.
Yep that's an old version allright but it's been no trouble until now.

I attempted to install Ozpost onto ZC 1.38a and got the following message

1054 Unknown column 'NONE' in 'field list' in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Dispatch Postcode', 'MODULE_SHIPPING_OZPOST_SPCODE', NONE, 'Dispatch Postcode?', '6', '2', now())]

Thanks,
grantgee


<><><><><><><><><><><>><><><><><><><
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
PHP Version: 5.2.3 (Zend: 2.2.0)
MySQL 5.0.77-community
Server OS: Linux 2.6.9-023stab046.2-enterprise
HTTP Server: Apache/1.3.37 (Unix)
1 external module installed: group_pricing_per_item_1-3-1
<><><><><><><><><><><>><><><><><><><

[RodG]

I attempted to install Ozpost onto ZC 1.38a and got the following message

1054 Unknown column 'NONE' in 'field list' in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Dispatch Postcode', 'MODULE_SHIPPING_OZPOST_SPCODE', NONE, 'Dispatch Postcode?', '6', '2', now())]

As this is the first time this error has been reported I can only guess at the cause and offer a couple of possible solutions.

The cause appears to be missing data during the install process, or more specifically, it is missing the dispatch postcode.

The installation routine is supposed to obtain this data from an existing zencart configuration value, so this means either the data hasn't been set yet, or there is something amiss with the code that is supposed to retrieve this data.

This gives gives us two possible solutions.

1. Ensure you have set the zipcode/postcode under /admin/configuration/shipping+packaging before trying to install the ozpost module.

2. If the zipcode/postcode has been set and you still get this same error you will need to manually edit the ozpost.php file (at least until I can figure out why the zipcode/postcode isn't being retrieved). Anyway, you'll need to load the ozpost.php file into a text editor, and near the end of the file you will see some code that starts with:

function install()

A few lines below this is a line that reads:

$pcode = $result->fields['configuration_value'] ;

Replace this line with

$pcode = "1234" (or whatever postcode you ship from).

Save the file and then try reinstalling.

Points to note:
1. You may need to perform an uninstall before doing another install (else there will be duplicate fields).

2. You will be able to modify/update the zipcode after the installation (if required).

3. "Uninstall" and "reinstall" doesn't mean that you need to remove and re-install the entire module. All you'll need to do is click on the remove/install button(s) from the admin interface.

Cheers
Rod

[grantgee]

It was the zip code that was defaulting to 'NONE'.
Entered that and all was well.
Thanks Rod - it's a great module.
Grant

[RodG]

It was the zip code that was defaulting to 'NONE'.

Just to clarify (and make it easier if the problem is reported again), was it defaulting to 'NONE' because you hadn't yet entered a zip code in the shipping/packaging area, or was it defaulting to 'NONE' because the ozpost install routine was unable to read the zipcode for some reason?

If the former, I'll probably need to document this in the installation instructions. If the latter then I have a bug that needs fixing.

Thanks for your help.
Rod

[grantgee]

No bug Rod, I just hadn't got around to setting the postcode on the new ZC install before trying to install the Ozpost module.
Cheers,
Grant

[RodG]

No bug Rod, I just hadn't got around to setting the postcode on the new ZC install before trying to install the Ozpost module.
Cheers,
Grant

Thanks for that, and although not technically a bug, I really should to the 'right' thing with the next update and add a check to see if the postcode has been set, and if not, just insert some dummy data instead of letting it produce an error.

Cheers
Rod