Quote Originally Posted by mirage View Post
Hi,

I've been reading up on Austpost, and in installing it, I've managed to get myself the following error (at the point of uploading the auspost.sql file):

1067 Invalid default value for 'date_added'
in:
[CREATE TABLE geo_zones ( geo_zone_id int(11) NOT NULL auto_increment, geo_zone_name varchar(32) NOT NULL default '', geo_zone_description varchar(255) NOT NULL default '', last_modified datetime default NULL, date_added datetime NOT NULL default '', PRIMARY KEY (geo_zone_id) ) TYPE=MyISAM;]
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.

There was a solution that someone found regarding dumping a database, however I am extremely new to this and have no idea how to do so - and if I tried I would probably muck something important up. Any help would be much appreciated!

Michael
I suggest you revert your system back to the same state that it was before you tried this install, and then download and install the "Austpost Improved" module instead.

I can't offer any support for the module you have downloaded, but can give you lots of help (if you need it) with the Improved version. They are totally different modules.

Although both modules are compatible with each other (meaning that you can install both at the same time) it will tend to get a wee bit confusing for both yourself and your customers (which is also why I suggest you remove the original before installing the new).

Tip. Before installing any *useful* modules (such as the shipping estimators) I strongly suggest you play around with a few different templates to customise the look of your store.
The reason being is that the template you finally decide upon will determine where you need to place some of the files from other modules. IOW, if you install the Austpost shipping estimator (and many other modules) first, and THEN decide to use a different template you'll need to either re-install or relocate everything you've already done.

Cheers
Rod.