服务端启动后，服务端会开始报错

[nbyaya]

SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (53, 1494, 255) [ERROR]: [1062] Duplicate entry '53-1494' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (58, 1459, 255) [ERROR]: [1062] Duplicate entry '58-1459' for key 'character_spell.PRIMARY' Command: server info [Player: Yaya (GUID Full: 0x00000000000007d1 Type: Player Low: 2001) (Account: 201) X: -618.7858 Y: -4241.266 Z: 38.458996 Map: 1 (Kalimdor) Area: 363 (Valley of Trials) Zone: 14 (Durotar) Selected: (GUID Full: 0x0000000000000000 Type: None Low: 0)] Command: account onlinelist [Player: Yaya (GUID Full: 0x00000000000007d1 Type: Player Low: 2001) (Account: 201) X: -618.7858 Y: -4241.266 Z: 38.458996 Map: 1 (Kalimdor) Area: 363 (Valley of Trials) Zone: 14 (Durotar) Selected: (GUID Full: 0x0000000000000000 Type: None Low: 0)] SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (12, 53653, 255) [ERROR]: [1062] Duplicate entry '12-53653' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (28, 1459, 255) [ERROR]: [1062] Duplicate entry '28-1459' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (72, 53653, 255) [ERROR]: [1062] Duplicate entry '72-53653' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (51, 6673, 255) [ERROR]: [1062] Duplicate entry '51-6673' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (74, 1804, 255) [ERROR]: [1062] Duplicate entry '74-1804' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (23, 1494, 255) [ERROR]: [1062] Duplicate entry '23-1494' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (55, 1243, 255) [ERROR]: [1062] Duplicate entry '55-1243' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (5, 1243, 255) [ERROR]: [1062] Duplicate entry '5-1243' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (19, 348, 255) [ERROR]: [1062] Duplicate entry '19-348' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (39, 702, 255) [ERROR]: [1062] Duplicate entry '39-702' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (52, 53653, 255) [ERROR]: [1062] Duplicate entry '52-53653' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (61, 100, 255) [ERROR]: [1062] Duplicate entry '61-100' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (32, 53653, 255) [ERROR]: [1062] Duplicate entry '32-53653' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (11, 100, 255) [ERROR]: [1062] Duplicate entry '11-100' for key 'character_spell.PRIMARY' Saving reports for 75 players. Update time diff: 15. Players online: 1. Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (71, 6673, 255) [ERROR]: [1062] Duplicate entry '71-6673' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (22, 53653, 255) [ERROR]: [1062] Duplicate entry '22-53653' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (27, 8017, 255) [ERROR]: [1062] Duplicate entry '27-8017' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (44, 1804, 255) [ERROR]: [1062] Duplicate entry '44-1804' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (4, 1804, 255) [ERROR]: [1062] Duplicate entry '4-1804' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (62, 53653, 255) [ERROR]: [1062] Duplicate entry '62-53653' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (18, 116, 255) [ERROR]: [1062] Duplicate entry '18-116' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (68, 1459, 255) [ERROR]: [1062] Duplicate entry '68-1459' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (38, 1459, 255) [ERROR]: [1062] Duplicate entry '38-1459' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (2, 53653, 255) [ERROR]: [1062] Duplicate entry '2-53653' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (65, 589, 255) [ERROR]: [1062] Duplicate entry '65-589' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (21, 100, 255) [ERROR]: [1062] Duplicate entry '21-100' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (13, 1494, 255) [ERROR]: [1062] Duplicate entry '13-1494' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (42, 53653, 255) [ERROR]: [1062] Duplicate entry '42-53653' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (3, 1494, 255) [ERROR]: [1062] Duplicate entry '3-1494' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (49, 348, 255) [ERROR]: [1062] Duplicate entry '49-348' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (64, 1804, 255) [ERROR]: [1062] Duplicate entry '64-1804' for key 'character_spell.PRIMARY' Saving reports for 75 players. Update time diff: 13. Players online: 1. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (1, 6673, 255) [ERROR]: [1062] Duplicate entry '1-6673' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (63, 1494, 255) [ERROR]: [1062] Duplicate entry '63-1494' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (9, 348, 255) [ERROR]: [1062] Duplicate entry '9-348' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (40, 1126, 255) [ERROR]: [1062] Duplicate entry '40-1126' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (45, 1243, 255) [ERROR]: [1062] Duplicate entry '45-1243' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (31, 100, 255) [ERROR]: [1062] Duplicate entry '31-100' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (41, 6673, 255) [ERROR]: [1062] Duplicate entry '41-6673' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (59, 348, 255) [ERROR]: [1062] Duplicate entry '59-348' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (24, 1804, 255) [ERROR]: [1062] Duplicate entry '24-1804' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (43, 1494, 255) [ERROR]: [1062] Duplicate entry '43-1494' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (29, 348, 255) [ERROR]: [1062] Duplicate entry '29-348' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (8, 116, 255) [ERROR]: [1062] Duplicate entry '8-116' for key 'character_spell.PRIMARY' Command: server info [Player: Yaya (GUID Full: 0x00000000000007d1 Type: Player Low: 2001) (Account: 201) X: -613.649 Y: -4242.9224 Z: 38.956238 Map: 1 (Kalimdor) Area: 363 (Valley of Trials) Zone: 14 (Durotar) Selected: (GUID Full: 0x0000000000000000 Type: None Low: 0)] SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (35, 1243, 255) [ERROR]: [1062] Duplicate entry '35-1243' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (48, 1459, 255) [ERROR]: [1062] Duplicate entry '48-1459' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (25, 1243, 255) [ERROR]: [1062] Duplicate entry '25-1243' for key 'character_spell.PRIMARY' Saving reports for 75 players. Command: server info [Player: Yaya (GUID Full: 0x00000000000007d1 Type: Player Low: 2001) (Account: 201) X: -613.649 Y: -4242.9224 Z: 38.956238 Map: 1 (Kalimdor) Area: 363 (Valley of Trials) Zone: 14 (Durotar) Selected: (GUID Full: 0x0000000000000000 Type: None Low: 0)] SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (15, 1243, 255) [ERROR]: [1062] Duplicate entry '15-1243' for key 'character_spell.PRIMARY' Saving reports for 75 players. Update time diff: 17. Players online: 1. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (73, 1494, 255) [ERROR]: [1062] Duplicate entry '73-1494' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (54, 1804, 255) [ERROR]: [1062] Duplicate entry '54-1804' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (60, 1126, 255) [ERROR]: [1062] Duplicate entry '60-1126' for key 'character_spell.PRIMARY' Command: server info [Player: Yaya (GUID Full: 0x00000000000007d1 Type: Player Low: 2001) (Account: 201) X: -613.649 Y: -4242.9224 Z: 38.956238 Map: 1 (Kalimdor) Area: 363 (Valley of Trials) Zone: 14 (Durotar) Selected: (GUID Full: 0x0000000000000000 Type: None Low: 0)] Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (33, 1494, 255) [ERROR]: [1062] Duplicate entry '33-1494' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (34, 1804, 255) [ERROR]: [1062] Duplicate entry '34-1804' for key 'character_spell.PRIMARY' Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (57, 8017, 255) [ERROR]: [1062] Duplicate entry '57-8017' for key 'character_spell.PRIMARY' SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (14, 1804, 255) [ERROR]: [1062] Duplicate entry '14-1804' for key 'character_spell.PRIMARY' Command: server info [Player: Yaya (GUID Full: 0x00000000000007d1 Type: Player Low: 2001) (Account: 201) X: -613.649 Y: -4242.9224 Z: 38.956238 Map: 1 (Kalimdor) Area: 363 (Valley of Trials) Zone: 14 (Durotar) Selected: (GUID Full: 0x0000000000000000 Type: None Low: 0)] Saving reports for 75 players. SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (69, 348, 255) [ERROR]: [1062] Duplicate entry '69-348' for key 'character_spell.PRIMARY'

不知道这种错误会不会影响机器人的运行，另有什么办法能排除这种错误，我试着把机器人自动学技能关掉后，经过一段当是不报错了，感谢大神这么好的源码给魔兽添加了许多乐趣~

[nbyaya]

本来以为重新添加后不再出现上面的提示了，一段时间后这错误又出现了~

[dood2020]

主键重复了。 .\src\server\database\Database\Implementation\CharacterDatabase.cpp 519行加上ignore抛掉错误命令就行了 具体就是改成 INSERT IGNORE INTO 然后重新build一遍。 暂时不清楚会不会有别的问题。

[luchec]

这个就是造成NPC那里施放法术，然后就一直卡着放不出来

[GesiIvy128]

本来以为重新添加后不再出现上面的提示了，一段时间后这错误又出现了~

哥们这个问题你解决了吗

[GesiIvy128]

主键重复了。 .\src\server\database\Database\Implementation\CharacterDatabase.cpp 519行加上ignore抛掉错误命令就行了 具体就是改成 INSERT IGNORE INTO 然后重新build一遍。 暂时不清楚会不会有别的问题。

这么改的话也会报错： ERROR 1146 (42S02) at line 3 in file: 'D:\Azerothcore\Lyf\azerothcore-wotlk\data\sql\updates\db_characters\2023_05_23_00.sql': Table 'acore_characters.characters' doesn't exist

Applying of file 'D:/Azerothcore/Lyf/azerothcore-wotlk/data/sql/updates/db_characters/2023_05_23_00.sql' to database 'acore_characters' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from AzerothCore repository with your sql client. If you are a developer, please fix your sql query. Could not update the Character database, see log for details. Closing down DatabasePool 'acore_world'. Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections. All connections on DatabasePool 'acore_world' closed. Closing down DatabasePool 'acore_characters'. Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections. All connections on DatabasePool 'acore_characters' closed. Closing down DatabasePool 'acore_auth'. Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections. All connections on DatabasePool 'acore_auth' closed.

[alexyang-sea]

不知道你们解决没有，我也遇到同样的问题