Harvester blocker in NS 2.6.00

Susann · Posted: Thu Jul 03, 2008 10:56 am

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.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4813

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!