Aus Post 2.02c Help - SQL error #1067

[tom_4090497]

Hey

Ive been trying to install the Australian Shipping Module (http://www.oscommerce.com/community/contributions,648)

 

However when i run the sql statement i get the following error

 

SQL query:

 

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 ;

 

 

MySQL said:

#1067 - Invalid default value for 'date_added'[/i]

 

Im no expert when it comes to sql but i really need help in making this contribution work.

 

Thanks In advance

 

Thomas Bryant

[tom_4090497]

Please anyone?

 

 

Cheers

 

Thomas Bryant