Windows Sample Character Problem

[Ceejzor]

I've tried to import sample character's but it's not working can someone help me?

 

[Ceejzor]

I've already tried Vocation Sample but I get this error.

Error

SQL query:

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 (

NULL ,  "Sorcerer Sample", 0, 1, 1, 1, 1, 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, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0,  "", 0,  ""
);

MySQL said: 

#1452 - Cannot add or update a child row: a foreign key constraint fails (`new2`.`players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE)

 

[Indenpedens]

lol samples adding automatic to database

 

[Ceejzor]

No they didn't with Modern AAC, do you know any solution to this? and why won't they add with me inputting that sql query

 

[arturhaddad]

In your query you didn't put this line, right?

SQL query:

And also, user Frankit0 had the exactly same error as you when trying to execute this very same query:

http://otland.net/f16/vocation-samples-71803/#post738488

In last case you can create it manually... It will be tuff, but it's a solution

 

[Chris]

Does an account with ID 1 exist?

 

[Ceejzor]

Nope and there is no account's nor players in database I had it working before I just forgot what I did =/

 

[Chris]

That is why it is not working. It is trying to add these samples to an account with ID of 1. Go ahead and create an account, add change its id to 1 if it isn't by default.

 

[Ceejzor]

Thank You big time Chris <3

 

[arturhaddad]

So simple yet so complicate :]

 

[Chris]

You're most welcome.