"[Msg] 1062 - Duplicate entry '2-0' for key 1"

[christiandb]

When I try to make a backup with Navicat of my database and I try to restore it, I get this error. Making a SQL-dump with SQLyog gives an error as well. Anyone knows how to fix this error?

Thanks in advance,

Chris

EDIT: a backup does work when I have a clean database but when Gesior's samples are added then it bugs out.

 

[christiandb]

bump

 

[Don Daniello]

I will suggest you creating samples like any other players, then delete old ones. New should be "full"

 

[christiandb]

I'll try it thanks!

 

[arctix]

It's old topic, but I've got the same problem. I made backup of database and when i try to import (in shell and phpmyadmin) it gives me "#1062 - Duplicate entry '2-0' for key 1" error. It's in this code:

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `redskull`, `redskulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`, `description`) VALUES
(1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, '', 0, '', ''),
(2, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32241, 7, '', 420, 1, 1241863810, 3591478360, 1, 0, 0, 0, '', 1241863813, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1236610027, 1, '', 1, '', ''),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32241, 7, '', 470, 1, 1242308185, 3591478360, 1, 0, 0, 0, '', 1242308188, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1236610027, 1, '', 1, '', ''),

Somewhere I've seen that the error is at the beginning. Second player is Rook Sample. When I delete it, then it shows Duplicate entry '3-0' and with next chars there is same problem. Can anyone help me ?

 

[arctix]

bump

 

[jaszewski]

I have similar problem.