Auspost Install Error

25 Sep 2006, 02:45

#1

New Zenner

Join Date:: Sep 2006
Posts:: 80
Plugin Contributions:: 0

Auspost Install Error

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

02 Oct 2006, 20:18

#2

superprg

Totally Zenned

Join Date:: Feb 2006
Posts:: 1,349
Plugin Contributions:: 0

Re: Auspost Install Error

lucky__starre:

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

18 Dec 2006, 23:31

#3

blind1

Zen Follower

Join Date:: Dec 2006
Posts:: 351
Plugin Contributions:: 0

Re: Auspost Install Error

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:bored:

18 Dec 2006, 23:37

#4

blind1

Zen Follower

Join Date:: Dec 2006
Posts:: 351
Plugin Contributions:: 0

Re: Auspost Install Error

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

19 Dec 2006, 00:00

#5

blind1

Zen Follower

Join Date:: Dec 2006
Posts:: 351
Plugin Contributions:: 0

Re: Auspost Install Error

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;

19 Dec 2006, 06:48

#6

superprg

Totally Zenned

Join Date:: Feb 2006
Posts:: 1,349
Plugin Contributions:: 0

Re: Auspost Install Error

Glad that it worked for you!

19 Dec 2006, 06:50

#7

blind1

Zen Follower

Join Date:: Dec 2006
Posts:: 351
Plugin Contributions:: 0

Re: Auspost Install Error

Thanks so am I:yes:

18 May 2007, 06:25

#8

theslydog

New Zenner

Join Date:: May 2007
Posts:: 10
Plugin Contributions:: 0

Re: Auspost Install Error

Well done on that fix.

Worked for me too.

Only wish I found this post yesterday...

24 Jun 2007, 03:58

#9

blind1

Zen Follower

Join Date:: Dec 2006
Posts:: 351
Plugin Contributions:: 0

Re: Auspost Install Error

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

08 Sep 2008, 12:35

#10

snype

New Zenner

Join Date:: Mar 2008
Posts:: 32
Plugin Contributions:: 0

Re: Auspost Install Error

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. :clap: