[Koha-bugs] [Bug 34516] Upgrade database fails for 22.11.07.003, points to web installer

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

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

--- Comment #7 from estclair at ogb.state.al.us ---
It might indeed too late but here is the info you requested:
mysql  Ver 8.0.34-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))



biblioitems | CREATE TABLE `biblioitems` (
  `biblioitemnumber` int NOT NULL AUTO_INCREMENT,
  `biblionumber` int NOT NULL DEFAULT '0',
  `volume` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `number` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `itemtype` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
  `isbn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `issn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ean` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `publicationyear` mediumtext CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci,
  `publishercode` text COLLATE utf8mb4_unicode_ci COMMENT 'publisher (MARC21
260$b and 264$b)',
  `volumedate` date DEFAULT NULL,
  `volumedesc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `collectiontitle` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `collectionissn` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `collectionvolume` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `editionstatement` mediumtext CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci,
  `editionresponsibility` mediumtext CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
  `illus` text COLLATE utf8mb4_unicode_ci COMMENT 'illustrations (MARC21
300$b)',
  `pages` text COLLATE utf8mb4_unicode_ci COMMENT 'number of pages (MARC21
300$a)',
  `notes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `size` text COLLATE utf8mb4_unicode_ci COMMENT 'material size (MARC21
300$c)',
  `place` text COLLATE utf8mb4_unicode_ci COMMENT 'publication place (MARC21
260$a and 264$a)',
  `lccn` longtext COLLATE utf8mb4_unicode_ci COMMENT 'library of congress
control number (MARC21 010$a)',
  `url` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cn_source` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
  `cn_class` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
  `cn_item` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
  `cn_suffix` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
  `cn_sort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
  `agerestriction` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci DEFAULT NULL,
  `totalissues` int DEFAULT NULL,
  PRIMARY KEY (`biblioitemnumber`),
  KEY `bibinoidx` (`biblioitemnumber`),
  KEY `bibnoidx` (`biblionumber`),
  KEY `itemtype_idx` (`itemtype`),
  KEY `isbn` (`isbn`(255)),
  KEY `issn` (`issn`(255)),
  KEY `timestamp` (`timestamp`),
  KEY `ean` (`ean`(255)),
  CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES
`biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20499 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.