https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671
--- Comment #17 from Pablo AB <[email protected]> --- I'm upgrading on a Debian 11 from Koha 22.05.12-1 to 22.11, and it is in this upgrade/transition where I came across this issue. I can't reach 22.11 due to this. SELECT version()\G version(): 10.1.41-MariaDB-0+deb9u1 SELECT * FROM borrower_relationships; Empty set (0.000 sec) SHOW CREATE TABLE borrower_relationships\G *************************** 1. row *************************** Table: borrower_relationships Create Table: CREATE TABLE `borrower_relationships` ( `id` int(11) NOT NULL AUTO_INCREMENT, `guarantor_id` int(11) DEFAULT NULL, `guarantee_id` int(11) NOT NULL, `relationship` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `guarantor_guarantee_idx` (`guarantor_id`,`guarantee_id`), KEY `r_guarantee` (`guarantee_id`), CONSTRAINT `r_guarantee` FOREIGN KEY (`guarantee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `r_guarantor` FOREIGN KEY (`guarantor_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci The DELETE I mention is only based on comment 1 of this issue. I originally wrote bug 33118, marked as duplicate of this one. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
