#444 DB defect on languages with new char creation

Закрыто
1 год назад открыта image · комментариев: 3
image прокомментировал 1 год назад

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...
image прокомментировал 1 год назад
Соавтор

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

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
devn00b прокомментировал 1 год назад
Владелец

ALTER TABLE character_languages

DROP FOREIGN KEY `character_languages_ibfk_1`; Corrects the issue passing along to @neatz Assigned to him as well =)
ALTER TABLE `character_languages` DROP FOREIGN KEY `character_languages_ibfk_1`; Corrects the issue passing along to @neatz Assigned to him as well =)
devn00b прокомментировал 1 год назад
Владелец

This should be fixed upstream now.

This should be fixed upstream now.
Войдите, чтобы присоединиться к обсуждению.
Нет этапа
Нет ответственного
2 участников
Загрузка...
Отмена
Сохранить
Пока нет содержимого.