Invalid default value for 'as_number'

j9 - March 7, 2007 - 18:30
Project:IP to Country
Version:4.7.x-1.0
Component:Code
Category:bug report
Priority:normal
Assigned:sugree
Status:closed
Description

iHi, I've seen this on the 5.x branch but I'm not sure if it's my version of mysql.

MySQL - 5.0.24a-standard-log
MySQL - 5.0.24a-standard-log
MySQL client version: 5.0.16

I get this error on trying to import the ip2cc.mysql file:

Error

SQL query:

CREATE TABLE ip2cc(
ip_from double NOT NULL default '0',
ip_to double NOT NULL default '0',
country_code char( 2 ) NOT NULL default '',
net_name char( 128 ) NOT NULL default '',
as_number int( 10 ) NOT NULL default '',
PRIMARY KEY ( ip_from, ip_to )
) TYPE = MYISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

MySQL said: Documentation
#1067 - Invalid default value for 'as_number'

It looks like as_number is expecting '0' instead of default?

Thanks a lot!

#1

sugree - March 13, 2007 - 15:10
Assigned to:Anonymous» sugree
Status:active» fixed

Oops! It should be '0'.

#2

Anonymous - March 27, 2007 - 15:15
Status:fixed» closed
 
 

Drupal is a registered trademark of Dries Buytaert.