[Koha-bugs] [Bug 30899] Upgrade sometimes fails at "Upgrade to 21.11.05.004"
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jun 3 11:27:01 CEST 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30899
--- Comment #2 from Magnus Enger <magnus at libriotech.no> ---
This is from a database where the update succeeded:
MariaDB [koha_ok]> show create table borrower_attribute_types\G
*************************** 1. row ***************************
Table: borrower_attribute_types
Create Table: CREATE TABLE `borrower_attribute_types` (
`code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`repeatable` tinyint(1) NOT NULL DEFAULT '0',
`unique_id` tinyint(1) NOT NULL DEFAULT '0',
`opac_display` tinyint(1) NOT NULL DEFAULT '0',
`opac_editable` tinyint(1) NOT NULL DEFAULT '0',
`staff_searchable` tinyint(1) NOT NULL DEFAULT '0',
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT
NULL,
`display_checkout` tinyint(1) NOT NULL DEFAULT '0',
`category_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT '0',
`mandatory` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`code`),
KEY `auth_val_cat_idx` (`authorised_value_category`),
KEY `category_code` (`category_code`),
CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`category_code`)
REFERENCES `categories` (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
1 row in set (0.00 sec)
And this is from a database where it failed:
MariaDB [koha_fail]> show create table borrower_attribute_types\G
*************************** 1. row ***************************
Table: borrower_attribute_types
Create Table: CREATE TABLE `borrower_attribute_types` (
`code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`repeatable` tinyint(1) NOT NULL DEFAULT '0',
`unique_id` tinyint(1) NOT NULL DEFAULT '0',
`opac_display` tinyint(1) NOT NULL DEFAULT '0',
`opac_editable` tinyint(1) NOT NULL DEFAULT '0',
`staff_searchable` tinyint(1) NOT NULL DEFAULT '0',
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT
NULL,
`display_checkout` tinyint(1) NOT NULL DEFAULT '0',
`category_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT '0',
`mandatory` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`code`),
KEY `auth_val_cat_idx` (`authorised_value_category`),
KEY `category_code_fk` (`category_code`),
CONSTRAINT `category_code_fk` FOREIGN KEY (`category_code`) REFERENCES
`categories` (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
1 row in set (0.00 sec)
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list