ozpost shipping module

[jeking]

I just found your module but am getting an error when I try to enable it.

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())]

[RodG]

I just found your module but am getting an error when I try to enable it.
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())]

First question... What version of ozpost are you using? (please let me know, even though the following suggestion will probably fix this issue for you).

Suggestion for probable fix:

Go to your configuration settings -> shipping/packaging and set your Postal Code.

Then try installing the ozpost module again.

The error you are getting *shouldn't* be happening, because if the postcode isn't set the module should be using a default value of "9999" .. for some reason it appears that you don't have a valid postcode set, and the module isn't correctly detecting this fact, so it is trying to set a value of 'NONE' in a place where NONE isn't allowed.

This was a 'bug' that I noticed in the code a few versions back, which is why I added code to set a default value if the postcode wasn't already set, which is why I'm interested in know what version you are using.. If the current version then I need to take another look at the code, if an older version then I don't need to worry about it any longer.

Cheers
Rod