[Koha-bugs] [Bug 30916] Staged import fails if a title is longer than 128 characters
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Jun 7 10:57:10 CEST 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30916
Katrin Fischer <katrin.fischer at bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
Version|20.11 |unspecified
--- Comment #2 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
This is an "old version" problem. In master, this table is 'prettier':
DROP TABLE IF EXISTS `import_biblios`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `import_biblios` (
`import_record_id` int(11) NOT NULL,
`matched_biblionumber` int(11) DEFAULT NULL,
`control_number` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`original_source` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`isbn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`issn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`has_items` tinyint(1) NOT NULL DEFAULT 0,
KEY `import_biblios_ibfk_1` (`import_record_id`),
KEY `matched_biblionumber` (`matched_biblionumber`),
KEY `title` (`title`(191)),
KEY `isbn` (`isbn`(191)),
CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE
CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list