duplicate entries on required SQL updates
 

Updating my source finally to bring bots back and add in queryserv, I'm updating from 2136. I made it all the way to 2176_required_aa_updates.sql. Every line is giving me a 1062 - Duplicate entry '1587-1' for key 'NewIndex' error (obviously the number changes, but still).

I'm under the impression I shouldn't be receiving these errors for this update since I'm updating from a vastly older version.

Should I ignore it and press on or alter it some how?

there were a few things redone on the AA updates as I recall. something might just be in there twice.

I figured as much, just skipped the duplicates and moved on.

from 2176 to 2188 there are a few conflicts but a quick edit of the .sql will take care of that for you. Cant find my notes on it but didnt take but a minute to manually edit.

Yeah I know. I edited out the duplicates. There was another sql file around the 2180 range that was erroring out due to bad syntax so had to edit that one too.

Yeah it happens I guess. Tbh that was the first time I think I had to edit the sql other then as instructed on the changelog. Hows your project coming along?

My project has been live for 4 years. The population on the other hand has it's ups and downs :D

There shouldn't be too many duplicates with the AA sql's, maybe a handful in the early ones for a few redundancies.

Almost everything in those files are new entries for the aa_effects table for AA's that are now handled via the table and not the source.

Take a look at your table and make sure it is filled with what is in those sql's, obviously if you ran it twice by accident you would be getting those errors that is really the only way I could see that occurring. If you think something else is going on, feel free to send me a dump of your table and I will check it out.

Without those SQL your AA's will not be working correctly.

Kayen

My server doesn't use AA's (yet) so it's a minor inconvenience.

This is what I see and I got duplicate entries the very first time I ran the sql updates:

I thought I'd chime in, I've found multiple of the AA sql updates to give me warnings about duplicate entries (I didn't check to see if anything was actually inserted twice).