@@ -, +, @@ 8 If you use ktd, you can try: DB_IMAGE=mysql:8.0 ktd up --- .../data/mysql/atomicupdate/fix_tmp_holdsqueue.pl | 14 ++++++++++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 15 insertions(+), 1 deletion(-) create mode 100755 installer/data/mysql/atomicupdate/fix_tmp_holdsqueue.pl --- a/installer/data/mysql/atomicupdate/fix_tmp_holdsqueue.pl +++ a/installer/data/mysql/atomicupdate/fix_tmp_holdsqueue.pl @@ -0,0 +1,14 @@ +use Modern::Perl; + +return { + bug_number => "34494", + description => "Fix tmp_holdsqueue for MySQL compatiability", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + $dbh->do(q{ + ALTER TABLE tmp_holdsqueue CHANGE COLUMN itemnumber `itemnumber` int(11) NOT NULL + }); + }, +}; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -5870,7 +5870,7 @@ DROP TABLE IF EXISTS `tmp_holdsqueue`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp_holdsqueue` ( `biblionumber` int(11) DEFAULT NULL, - `itemnumber` int(11) DEFAULT NULL, + `itemnumber` int(11) NOT NULL, `barcode` varchar(20) DEFAULT NULL, `surname` longtext NOT NULL, `firstname` mediumtext DEFAULT NULL, --