mySQL error

[Flyer5]

Hi

 

I have just got a dedicated server and am moving a site. Currently on the shared server I have Mysql 3.23 and it works just fine;

 

When I try to run the mysql dump on the new server running Mysql version 4 it fails immediately with

 

"Invalid default value for 'address_format_id'.

 

Query: CREATE TABLE address_format ( address_format_id int(11) DEFAULT '' NOT NULL auto_increment, address_format varchar(128) DEFAULT '' NOT NULL , address_summary varchar(48) DEFAULT '' NOT NULL , PRIMARY KEY (address_format_id) )

 

 

Has something changed in ver 4 that causes this and is there a fix?

 

Thanks

 

 

F5

[Flyer5]

Hi

 

I have just got a dedicated server and am moving a site. Currently on the shared server I have Mysql 3.23 and it works just fine;

 

When I try to run the mysql dump on the new server running Mysql version 4 it fails immediately with

 

"Invalid default value for 'address_format_id'.

 

Query: CREATE TABLE address_format ( address_format_id int(11) DEFAULT '' NOT NULL auto_increment, address_format varchar(128) DEFAULT '' NOT NULL , address_summary varchar(48) DEFAULT '' NOT NULL , PRIMARY KEY (address_format_id) )

Has something changed in ver 4 that causes this and is there a fix?

 

Thanks

F5

 

 

I fixed it. For anyone else in the future that has the same issue - version 4 and higher of MySQL doesnt allow default values to be set with Auto_increment. *

 

Just delet all the defaults and re run the dump and all should be fine.

 

*apparantly.

 

F5