grantgee:
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.
-
Ensure you have set the zipcode/postcode under /admin/configuration/shipping+packaging before trying to install the ozpost module.
-
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:
-
You may need to perform an uninstall before doing another install (else there will be duplicate fields).
-
You will be able to modify/update the zipcode after the installation (if required).
-
"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
