DB error - Duplicate entry '4700' for key 'PRIMARY'

[frotek 0]

[SQL]: DB error - Duplicate entry '4700' for key 'PRIMARY' [Debug]: at c:\users\frt54ree4\desktop\ro\hercules\src\map\log.c:396 - INSERT DELAYED INTO `chatlog` (`time`, `type`, `type_id`, `src_charid`, `src_accountid`, `src_map`, `src_map_x`, `src_map_y`, `dst_charname`, `message`) VALUES (NOW(), 'O', '0', '150011', '2000003', 'invek', '151', '158', ?, ?)  

[SQL]: DB error - Duplicate entry '4700' for key 'PRIMARY'
[Debug]: at c:\users\frt54ree4\desktop\ro\hercules\src\map\log.c:396 - INSERT DELAYED INTO `chatlog` (`time`, `type`, `type_id`, `src_charid`, `src_accountid`, `src_map`, `src_map_x`, `src_map_y`, `dst_charname`, `message`) VALUES (NOW(), 'O', '0', '150011', '2000003', 'invek', '151', '158', ?, ?)

 

i recently update my folder then suddenly i got errors like this, does anyone encountered this type of problems too? It shows up every time i kill monsters.

 

 

Edited January 2, 2017 by frotek

[Dastgir 1246]

It shouldn't really happen unless your SQL Server/Database got messed up.

since PRIMARY KEY is `id` and it's set to AUTO_INCREMENT, it should not generate duplicate value.

 

Anything that happened to your MySQL Server? Any Crashes or anything else?

[frotek 0]

i fixed it by overwriting it with the default sql, main.sql

 

thanks