Duplicate Guild Names Bug

There is currently a bug where sometimes a guild can be created twice with the same name and server. I have been unable to track down this bug so far, but I am making a change to the database structure that will prevent entries with duplicate names from occurring. This means when the bug does occur in the future, users should see an exception message, and this may help me figure out what is causing it.

If you are one of the guilds affected by this bug, I resolved duplicates using the following automated code:

(1) If one of the guilds in the set had no reports, I deleted that guild.
(2) If both guilds had reports (which means the members of the guild messed up and uploaded to both for some reason), I renamed the old guild by adding the suffix “Buggy Duplicate” to the end.

If you are affected by this change in a negative way, i.e., the guild marked as the Buggy Duplicate is actually the real one, let me know, and I can invert the naming. One of them has to be marked with a bogus name though… you don’t get to use both. :slight_smile:

Part 2, The Saga Continues:

After fixing the database to disallow duplicate guild names, I realized there was a second problem. People have made guilds whose names only differ in case, e.g., PARADOX vs. Paradox, or Hard In The Paint vs. Hard in the Paint. I just made a second pass to eliminate these duplicates as well. This hit WAY more guilds than the 1st check did.

Hi,

our guild has the dublicate name bug. Our name is “Dragonguard of War” we are on EU server Garrosh, but it isshown as “Dragonguard of War Buggy Lowercase Duplicate”. In our case its your second option, a old version of our guilde exists, including two old logs. no one can delete the two hellfire logs. If ist possible pls change our name, I tried it and get a error:
“Unhandled Exception
Message:
Undefined variable: region_id
Location:
/var/app/current/laravel/view.php(354) : eval()'d code on line 67”

Best regards

Kop

Hey,

Our guild was affected by this bug. But the wrong one was renamed :slight_smile:

Wrong one :
https://www.warcraftlogs.com/guilds/122761

Right one:
https://www.warcraftlogs.com/guilds/249795

Having what seems to be a related issue when trying to update characters.

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘Paradox-123’ for key ‘NameServer’

SQL: INSERT INTO groups (name, lowercase_name, server_id, battlenet, validated) VALUES (?, ?, ?, ?, ?)

Bindings: array (
0 => ‘Paradox’,
1 => ‘paradox’,
2 => 123,
3 => 1,
4 => 2,
)
Location:

/var/app/current/laravel/database/connection.php on line 263

This is the exact error message I receive.

Hey,
I handle the logs for the guild Wargasm on US-The Underbog and we got hit with the duplicate name bug and have been relabeled with “Buggy Lowercase Duplicate”. There is also another Wargasm guild with a “Buggy Duplicate” suffix but I have no idea who that is (they have no logs in the past two years and their guild website link is something I’ve never seen before)

The real Wargasm US-The Underbog is https://www.warcraftlogs.com/guilds/266555 and has a couple months of logs that I uploaded.

The WRONG Wargasm is https://www.warcraftlogs.com/guilds/45415.

Thanks

My guild has the duplicate name bug. I have been trying to update my characters and I get this message.