Database · high severity · found in the database
New players freeze on join from a unique-column collision
Found by reading the database rather than the console.
What it means
N duplicate values in a column that must be unique (N blank). New character creation collides and the player hangs.
How to fix it
- Find the duplicated values and give each row its own.
- Blank and NULL both count as duplicates once a unique index exists — fill them before adding the constraint.
- A freeze on join is also caused by a missing appearance dependency; rule out both before blaming either.
When it is not this
Only meaningful when the column is actually meant to be unique. Some servers never use unique_ssn at all, in which case duplicates are harmless — which is why this reports the duplicate COUNT rather than declaring the server broken.