Key constraints are dumb, this needs to be looked into when new chars are created:
16:03:25 E DBCore : #1451: Cannot delete or update a parent row: a foreign key constraint fails (eq2emu.character_languages, CONSTRAINT character_languages_ibfk_1 FOREIGN KEY (char_id) REFERENCES characters (id) ON UPDATE CASCADE)
Query:
DELETE FROM characters WHERE id=1732 AND account_id=88
16:03:31 D World : Removing connection...
Key constraints are dumb, this needs to be looked into when new chars are created:
16:03:25 E DBCore : #1451: Cannot delete or update a parent row: a foreign key constraint fails (`eq2emu`.`character_languages`, CONSTRAINT `character_languages_ibfk_1` FOREIGN KEY (`char_id`) REFERENCES `characters` (`id`) ON UPDATE CASCADE)
Query:
DELETE FROM characters WHERE id=1732 AND account_id=88
16:03:31 D World : Removing connection...
16:11:56 E DBCore : #1451: Cannot delete or update a parent row: a foreign key constraint fails (eq2emu.character_languages, CONSTRAINT character_languages_ibfk_1 FOREIGN KEY (char_id) REFERENCES characters (id) ON UPDATE CASCADE)
Query:
DELETE FROM characters WHERE id=1734 AND account_id=88
delete too:
16:11:56 E DBCore : #1451: Cannot delete or update a parent row: a foreign key constraint fails (`eq2emu`.`character_languages`, CONSTRAINT `character_languages_ibfk_1` FOREIGN KEY (`char_id`) REFERENCES `characters` (`id`) ON UPDATE CASCADE)
Query:
DELETE FROM characters WHERE id=1734 AND account_id=88
Key constraints are dumb, this needs to be looked into when new chars are created:
16:03:25 E DBCore : #1451: Cannot delete or update a parent row: a foreign key constraint fails (
eq2emu
.character_languages
, CONSTRAINTcharacter_languages_ibfk_1
FOREIGN KEY (char_id
) REFERENCEScharacters
(id
) ON UPDATE CASCADE)Query: DELETE FROM characters WHERE id=1732 AND account_id=88 16:03:31 D World : Removing connection...
delete too:
16:11:56 E DBCore : #1451: Cannot delete or update a parent row: a foreign key constraint fails (
eq2emu
.character_languages
, CONSTRAINTcharacter_languages_ibfk_1
FOREIGN KEY (char_id
) REFERENCEScharacters
(id
) ON UPDATE CASCADE) Query: DELETE FROM characters WHERE id=1734 AND account_id=88ALTER TABLE
character_languages
This should be fixed upstream now.