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 |
Jump to:
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
Oops! It should be '0'.
#2