SQL | Fresh Database / 2020_12_18_00_world.sql ERROR
Closed this issue · 1 comments
DuelistRag3 commented
Description:
Worldserver Crashes while applying update file 2020_12_18_00_world.sql duo duplicate entry
"ERROR 1062 (23000) at line 49452: Duplicate entry '140253-2276' for key 'PRIMARY'"
Current behaviour:
Worldserver Crashes
Expected behaviour:
Worldserver shouldn´t crash on Fresh Databases
TC rev. hash/commit:
AshamaneCore, revision c142185 2021-01-04 15:42:17 +0100 (master branch) (Win64, RelWithDebInfo, Static) (worldserver-daemon)
Database version
ADB_world_820.00
Operating system: Windows 10
DuelistRag3 commented
In this file are a high amount of issues, i bypassed the first couple of issues, by replacing "INSERT INTO" with "INSERT IGNORE INTO", to ignore duplicated keys while Insertion