After compiling the latest source code, when starting worldserver there will be a lot of red characters reporting errors, with chatgpt check said that the primary key duplicate write, such as the following error:
[ERROR]: [1062] Duplicate entry '5670' for key 'characters.PRIMARY' SQL(p): INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, skin, face, hairStyle, hairColor, facialStyle, bankSlots, restState, playerFlags, map, instance_id, instance_mode_mask, position_x, position_y, position_z, orientation, trans_x, trans_y, trans_z, trans_o, transguid, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, latency, talentGroupsCount, activeTalentGroup, exploredZones, equipmentCache, ammoId, knownTitles, actionBars, grantableLevels, innTriggerId, extraBonusTalentCount) VALUES (5671,1133,Gainko,4,11,1,1,0,0,2,16,11,7,4,0,2,0,1,0,0,10311.3,832.463,1326.41,5.69632,0,0,0,0,0,100663296 0 0 8 0 0 0 0 0 0 0 0 0 0 ,2,0,0,0,1698234784,0,0,0,4,0,0,0,0,,0,0,0,0,0,0,0,0,0,4294967295,0,64,110,0,0,100,0,0,0,0,1,0,0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,0 0 0 0 0 0 0 0 6123 0 0 0 6124 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3661 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,0,0 0 0 0 0 0 ,0,0,0, 0) [ERROR]: [1062] Duplicate entry '5671' for key 'characters.PRIMARY'
The databases that should be imported have been imported, the last version is no longer red error, I hope the big brother can be fixed.
I wonder if others are having the same problem as me?
After compiling the latest source code, when starting worldserver there will be a lot of red characters reporting errors, with chatgpt check said that the primary key duplicate write, such as the following error:
[ERROR]: [1062] Duplicate entry '5670' for key 'characters.PRIMARY' SQL(p): INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, skin, face, hairStyle, hairColor, facialStyle, bankSlots, restState, playerFlags, map, instance_id, instance_mode_mask, position_x, position_y, position_z, orientation, trans_x, trans_y, trans_z, trans_o, transguid, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, latency, talentGroupsCount, activeTalentGroup, exploredZones, equipmentCache, ammoId, knownTitles, actionBars, grantableLevels, innTriggerId, extraBonusTalentCount) VALUES (5671,1133,Gainko,4,11,1,1,0,0,2,16,11,7,4,0,2,0,1,0,0,10311.3,832.463,1326.41,5.69632,0,0,0,0,0,100663296 0 0 8 0 0 0 0 0 0 0 0 0 0 ,2,0,0,0,1698234784,0,0,0,4,0,0,0,0,,0,0,0,0,0,0,0,0,0,4294967295,0,64,110,0,0,100,0,0,0,0,1,0,0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,0 0 0 0 0 0 0 0 6123 0 0 0 6124 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3661 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,0,0 0 0 0 0 0 ,0,0,0, 0) [ERROR]: [1062] Duplicate entry '5671' for key 'characters.PRIMARY'
The databases that should be imported have been imported, the last version is no longer red error, I hope the big brother can be fixed.
I wonder if others are having the same problem as me?