Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.6.x
Author Message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3191
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Thu Jul 03, 2008 10:56 am Reply with quote

I got an error while I upgraded to this NS version.

Populate nuke_nsnst_harvesters: ERROR


I guess it was only because I had one entry already there:

July 3, 2008, 1:18 am 1062 : Duplicate entry 'linkwalker' for key 1
SQL was: INSERT INTO `nuke_nsnst_harvesters` (`harvester`) VALUES ('linkwalker')


So next step I removed LinkWalker from my Harvester block after the NukeSentinel upgrade was done. Next Step ?
Run NS upgrade again or how to handle this error normally ?
How would the insert for the harvester blocker in NS 2.6.00 looks like ?

Btw: I installed a fresh NukeSentinel version it took only a few minutes.
 
View user's profile Send private message
Guardian2003
Site Admin


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

PostPosted: Thu Jul 03, 2008 11:20 am Reply with quote

Hi Susann, Yes the error seems to be because there was already data in row 1.
Running the installer again should insert the list of default harvesters (ignore errors for other tables as they will have already been done).
The sql you posted should work for adding that harvester back in but it is already in the 'default' list of 221 harvesters.

Perhaps as a future feature, NS should just add the harvesters without a 'hid' number because as you have found, it gives an error when there is already data there. As 'hid' is an auto-increment field, mySQL should automatically assign a row number but there would also be a need for NS to do a check for duplicates in the event you already had one or more harvesters in the DB and the NS added it again.

Good find thanks!
 
View user's profile Send private message Send e-mail
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.6.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 ©