SQL error #1067 -

[Guest]

HI,

I am trying to use the Auspost contribution "auspost_v2[1].0.2_1"

 

I get an error message when i try to run the SQL strings

 

string:

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;

 

error message:

#1067 - Invalid default value for 'date_added'

 

I dont know SQL well enough to decipher what the problem may be can some please give me a hand with this.

Kind regards,

raph

[MOBASS]

I had exactly the same problem today and I found the solution by searching the forum (it took a while)

 

The answer is:

 

You would need to remove the default '' from the date_added line to make that work

 

Good Luck

 

Simon Guest

[♥John W]

try changing it to this

date_added datetime NOT NULL,

or you can put a real date in for the default like below, but I would try the first one.

date_added datetime DEFAULT '1970-01-01 00:00:01' NOT NULL,

 

[tgely]

set session sql_mode="";

 

[Dan Cole]

You guys know that this post is from 2006 right?  Otherwise the update seems to be a shameless plug.

Dan

[♥John W]

No Dan, I missed that  I was looking at unread posts and this one was in the list.  I guess lucas must have dug this up.