jakksen
New Member
- Joined
- Jan 23, 2012
- Messages
- 3
- Reaction score
- 0
Hello, i changed AAC from geisor to Znote, so all works fine, i can create accounts but not characters.
All old accounts can still create characters fine, but new accounts cant create character, i got this error..
string(755) "INSERT INTO `players`(`name`, `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`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`) VALUES ('Arrafat', '1', '199', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '3232235777', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)
Cannot add or update a child row: a foreign key constraint fails (`global`.`players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE)
All old accounts can still create characters fine, but new accounts cant create character, i got this error..
string(755) "INSERT INTO `players`(`name`, `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`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`) VALUES ('Arrafat', '1', '199', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '3232235777', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)
Cannot add or update a child row: a foreign key constraint fails (`global`.`players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE)