search

ZhengPeiRu21 / mod-playerbots

AzerothCore Playerbots Module
MIT License
193 stars 93 forks source link

sql error 1062 #166

Open Griptor opened 1 year ago

Griptor commented 1 year ago

The Azeroth core world server keeps spitting out this error:

SQL(p): INSERT INTO character_spell (guid, spell, specMask) VALUES (5156, 100, 255) [ERROR]: [1062] Duplicate entry '5156-100' for key 'character_spell.PRIMARY' Error logging in bot GUID Full: 0x0000000000001fcc Type: Player Low: 8140, please try to reset all random bots

every 5 - 45 seconds

The world server doesn't crash but I think it could cause difficulties in the future. I'm running sql v8.0.32

GesiIvy128 commented 9 months ago

I've encountered the same issue as well. Have you resolved it, bro?

GesiIvy128 commented 9 months ago

作者之前说这个问题已经解决了，但是亲测还是会出现

alexyang-sea commented 9 months ago

我也是启动时报很多这种错误，网上查了下说是主键重复，但是我不会怎么解决？而且还会出现一次启动不报错，但也没有加载机器人，下一次重新再启动有红字报错但能加载机器人，这样的启动规律循环

GesiIvy128 commented 9 months ago

我也是启动时报很多这种错误，网上查了下说是主键重复，但是我不会怎么解决？而且还会出现一次启动不报错，但也没有加载机器人，下一次重新再启动有红字报错但能加载机器人，这样的启动规律循环

等大佬修复吧 我先用的NPCBots

alexyang-sea commented 9 months ago

上一个版本确实没有这个错误了的，但是最新合并了的源码又有啦，liyunfan最新源码好像已经修复啦，但是我组了小号下的机器人，不知道为啥跟着我打了几个怪就不再攻击啦