Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.5.x
Author Message
NoFantasy
Worker
Worker


Joined: Apr 26, 2005
Posts: 114

PostPosted: Sat Dec 23, 2006 3:51 pm Reply with quote

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


Last edited by NoFantasy on Sat Dec 23, 2006 4:19 pm; edited 1 time in total 
View user's profile Send private message
NoFantasy
PostPosted: Sat Dec 23, 2006 4:12 pm Reply with quote

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
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Sat Dec 23, 2006 4:58 pm Reply with quote

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.
 
View user's profile Send private message Send e-mail
NoFantasy
PostPosted: Sat Dec 23, 2006 5:27 pm Reply with quote

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.
 
NoFantasy
PostPosted: Sat Dec 23, 2006 5:53 pm Reply with quote

...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
 
NoFantasy
PostPosted: Sat Dec 23, 2006 5:56 pm Reply with quote

Oh, forget the last post...*mumbling some words not suited for any Xmas and starts all over*
 
NoFantasy
PostPosted: Sat Dec 23, 2006 6:54 pm Reply with quote

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

Merry Xmas guys'n-girls
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.5.x

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©