Auspost Install Error

[lucky__starre]

When installing the auspost module I get this message after clicking on upload in Admin/Tools/Install SQL patches

#
# Table structure for table `geo_zones`
#

DROP TABLE IF EXISTS geo_zones;
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;

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.

What does this mean?

Thanks
Katie

[superprg]

date_added datetime NOT NULL default '',


1067 Invalid default value for 'date_added'

Katie

It means you are trying to insert wrong default value of date
Well, where is this script placed?>
San

[blind1]

I have had the same problem. I added the provided SQL patch into the tools>SQL Patches in Administration and got that error.
Part of the provided script is as follows:




#
# Table structure for table `geo_zones`
#

DROP TABLE IF EXISTS geo_zones;
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;

#
# Dumping data for table `geo_zones`
#

INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('1', 'Australian Zones', 'All Local Zones', NULL, '');
INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('2', 'World Zones', 'All International Zones', NULL, '');



#
# Table structure for table `zones_to_geo_zones`
#

DROP TABLE IF EXISTS zones_to_geo_zones;
CREATE TABLE zones_to_geo_zones (
association_id int(11) NOT NULL auto_increment,
zone_country_id int(11) NOT NULL default '0',
zone_id int(11) default NULL,
geo_zone_id int(11) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '',
PRIMARY KEY (association_id)
) TYPE=MyISAM;

#
# Dumping data for table `zones_to_geo_zones`
#

INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 2, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 3, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 4, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 5, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 6, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 7, NULL, 2, 'NULL', '');
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 8, NULL, 2, 'NULL', '');



Is there some adjustment needed before submitting this Patch?

What happens is this throws my zen cart web site all over the place.
This happened two days ago and I had to dump my database and restore it.

I tried installing this module again with the same frustrating result.
I am getting nowhere

[blind1]

This is an image of the result.
It took all the right side boxes off and centre info etc and left this:

[blind1]

Ok, I dumped the database again and restored my back up.
This time before i added the SQL Patched I changed the following (in RED) and it worked. Phew!
There needs to be a note on this in the download section


DROP TABLE IF EXISTS geo_zones;
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 '0001-01-01 00:00:00',
PRIMARY KEY (geo_zone_id)
) TYPE=MyISAM;

#
# Dumping data for table `geo_zones`
#

INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('1', 'Australian Zones', 'All Local Zones', NULL, '');
INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('2', 'World Zones', 'All International Zones', NULL, '');



#
# Table structure for table `zones_to_geo_zones`
#

DROP TABLE IF EXISTS zones_to_geo_zones;
CREATE TABLE zones_to_geo_zones (
association_id int(11) NOT NULL auto_increment,
zone_country_id int(11) NOT NULL default '0',
zone_id int(11) default NULL,
geo_zone_id int(11) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '0001-01-01 00:00:00',
PRIMARY KEY (association_id)
) TYPE=MyISAM;

[superprg]

Glad that it worked for you!

[blind1]

Thanks so am I

[theslydog]

Well done on that fix.

Worked for me too.

Only wish I found this post yesterday...

[blind1]

No problem I am sure I found the answer from somewhere - I am no database expert at all

[Snype]

Thanks for the help.

I only just downloaded this module and it a shame to see that an existing bug has not been fixed. I downloaded it fom the zen cart site.

Also the instructions told me to add my database prefix to the table names. Then when I ran the sql patch the prefix was doubling up. Zen cart must be smart enough to add them in on it's own.

Argh thank god for this forum.