Error in ip 2 country data

Worker Joined: Apr 26, 2005 Posts: 114

Data in ireland.data (in tables shipped with NS 2.5.03) at
1422917632||1423441919||1109653200||ie||
(84.208.0.0-84.215.255.255)
is belonging to Norway, not Ireland.

Not really sure where this data actually comes from originally, but i wanted you to know in any case.

registered · Posted: Sat Nov 04, 2006 3:47 am

I'll make that change for the next ip2country dump. A large part of the ip2county db came from http://ip-to-country.webhosting.info/downloads/ip-to-country.csv.zip . It didn't take long to figure out that it wasn't updated as well as updating from users so we stopped getting it from that source.

Everyso often I clear ranges to get updated info and I also collect info from people like yourself Smile

Client Joined: Jan 29, 2004 Posts: 624

I have a problem with the 'date' field in the ip2country table. I was importing the IP sql and got this error:

Code:




Error


SQL query: 


INSERT INTO `nuke_nsnst_ip2country` ( `ip_lo` , `ip_hi` , `date` , `c2c` ) 


VALUES ( 982745088, 982753279, 1139120757, 'af' ) ;





MySQL said:  


#1054 - Unknown column 'date' in 'field list'

It seems I have no 'date' field. I looked at the nuke_nsnst_ip2country structure and I have:

Code:




ip_lo int(10)   UNSIGNED No 0                


ip_hi int(10)   UNSIGNED No 0                


c2c char(2) latin1_swedish_ci  No

So I need to fix it and insert the 'date' fueld before I can import the IP sql. Anyone got the code for this? Thanks!

Posted: Mon Nov 06, 2006 5:36 am

Code:

ALTER TABLE `nuke_nsnst_ip2country` ADD  `date` int(20) NOT NULL default '0' AFTER `ip_hi`

Posted: Mon Nov 06, 2006 5:40 am

Hm, a bit in a hurry there, sorry...it will work, however it won't add any key like it's supposed to. Drop the nuke_nsnst_ip2country table, run

Code:

CREATE TABLE `nuke_nsnst_ip2country` (`ip_lo` int(10) unsigned NOT NULL default '0', `ip_hi` int(10) unsigned NOT NULL default '0', `date` int(20) NOT NULL default '0', `c2c` char(2) NOT NULL default '', PRIMARY KEY (`ip_lo`,`ip_hi`), KEY `c2c` (`c2c`), KEY `date` (`date`))

Posted: Mon Nov 06, 2006 12:46 pm

NoFantasy wrote:

Hm, a bit in a hurry there, sorry...it will work, however it won't add any key like it's supposed to. Drop the nuke_nsnst_ip2country table, run

Code:

CREATE TABLE `nuke_nsnst_ip2country` (`ip_lo` int(10) unsigned NOT NULL default '0', `ip_hi` int(10) unsigned NOT NULL default '0', `date` int(20) NOT NULL default '0', `c2c` char(2) NOT NULL default '', PRIMARY KEY (`ip_lo`,`ip_hi`), KEY `c2c` (`c2c`), KEY `date` (`date`))

Thanks very much, NoFantasy. I'll do this Smile

Posted: Mon Nov 06, 2006 1:24 pm

Worked perfect. I can now import IP sql all day lol