Solved Cannot add or update a child row: a foreign key constraint fails

[Tyson12302]

When i import this query i get this error ( Cannot add or update a child row: a foreign key constraint fails)
Here is what i import

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`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES
(3, 'Sorcerer Sample', 0, 1, 1, 13, 1, 210, 210, 23200, 87, 114, 0, 114, 130, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337481, 16777343, 1, 0, 0, 0, '', 1250337505, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, ''),
(4, 'Druid Sample', 0, 1, 1, 13, 2, 210, 210, 23200, 116, 114, 82, 44, 128, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337423, 16777343, 1, 0, 0, 0, '', 1250337425, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, ''),
(5, 'Paladin Sample', 0, 1, 1, 13, 3, 235, 235, 23200, 0, 116, 116, 76, 129, 0, 0, 110, 110, 0, 100, 1, 95, 117, 7, '', 660, 1, 1250337299, 16777343, 1, 0, 0, 0, '', 1250337301, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, ''),
(6, 'Knight Sample', 0, 1, 1, 13, 4, 260, 260, 23200, 119, 78, 39, 116, 131, 0, 0, 60, 60, 0, 100, 1, 95, 117, 7, '', 720, 1, 1250337301, 16777343, 1, 0, 0, 0, '', 1250337304, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '');

 

[Chris]

Do you have an account with ID of 1? If you have a groups table, do you have a group with ID of 1? If not for either of these, that's probably your issue.

 

[Tyson12302]

No the ID is 14. How can use the query now?

 

[Chris]

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`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES
(3, 'Sorcerer Sample', 0, 1, 14, 13, 1, 210, 210, 23200, 87, 114, 0, 114, 130, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337481, 16777343, 1, 0, 0, 0, '', 1250337505, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, ''),
(4, 'Druid Sample', 0, 1, 14, 13, 2, 210, 210, 23200, 116, 114, 82, 44, 128, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337423, 16777343, 1, 0, 0, 0, '', 1250337425, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, ''),
(5, 'Paladin Sample', 0, 1, 14, 13, 3, 235, 235, 23200, 0, 116, 116, 76, 129, 0, 0, 110, 110, 0, 100, 1, 95, 117, 7, '', 660, 1, 1250337299, 16777343, 1, 0, 0, 0, '', 1250337301, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, ''),
(6, 'Knight Sample', 0, 1, 14, 13, 4, 260, 260, 23200, 119, 78, 39, 116, 131, 0, 0, 60, 60, 0, 100, 1, 95, 117, 7, '', 720, 1, 1250337301, 16777343, 1, 0, 0, 0, '', 1250337304, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '');

 

[Tyson12302]

Thanks that worked!