IP2C v22.12.06, error in Norway.sql and China.sql

Worker Joined: Apr 26, 2005 Posts: 114

Line 130:
INSERT INTO `nuke_nsnst_ip2country` (`ip_lo`, `ip_hi`, `date`, `c2c`) VALUES (1422917632, 1423441919, 1162701417, 'no');

Will generate:
MySQL said
Duplicate entry '1422917632-1423441919' for key 1

...duplicate of what? Rolling Eyes

Posted: Sat Dec 23, 2006 4:12 pm

Hm...found another one too...in China.sql

Line 239
INSERT INTO `nuke_nsnst_ip2country` (`ip_lo`, `ip_hi`, `date`, `c2c`) VALUES (3400790016, 3400794111, 1166140988, 'cn');

MySQL said:
Duplicate entry '3400790016-3400794111' for key 1

Posted: Sat Dec 23, 2006 4:58 pm

The error indicates the database already has that data stored.
The best way to do these updates is to remove all the data from the table to make sure they are updated correctly.

Posted: Sat Dec 23, 2006 5:27 pm

Hm...i belived the first line in every sql file would do that...
DELETE FROM `nuke_nsnst_ip2country` WHERE `c2c`='no';

Will have a look anyways, thanks so far.

Posted: Sat Dec 23, 2006 5:53 pm

...but hey, if i did a search in the NS admin on 84.%.%.% wouldn't the duplicate show up?
3400790016 - 3400794111 = 84.208.0.0 - 84.215.255.255

Only range showing up in IP2C results are 84.0.0.0 - 84.3.255.255

Posted: Sat Dec 23, 2006 5:56 pm

Oh, forget the last post...*mumbling some words not suited for any Xmas and starts all over*

Posted: Sat Dec 23, 2006 6:54 pm

...couple of beers, truncate and lots of copy'n-paste=problem solved

Merry Xmas guys'n-girls