[Koha-bugs] [Bug 33671] Database update 22.06.00.048 breaks update process

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671

--- Comment #17 from Pablo AB <pablo.bianchi at gmail.com> ---
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.