I have installed Ubuntu 20. I can't get the upgrade to Ubuntu 20.11.05. When I execute command update and upograde it says Koha common is latest. Any solutions.
On Wed, Apr 28, 2021 at 10:34 PM <[email protected]> wrote: > This is what we are using: > > > > Server version: 10.3.27-MariaDB-0+deb10u1 Debian 10 > > > > Scott > > > > From: Tomas Cohen Arazi <[email protected]> > Sent: Wednesday, April 28, 2021 11:50 AM > To: [email protected] > Cc: koha <[email protected]> > Subject: Re: [Koha] Continued koha-common Upgrade Challenges > > > > Can you specify what DB engine are you using? > > Packages vs. Docker wouldn't change things here, as it would be the same > script > > > > El mié., 28 abr. 2021 12:55, <[email protected] <mailto: > [email protected]> > escribió: > > Our koha installation is on Debian 10. I have previously engaged the list > for upgrade challenges specifically related to the outcome of the Debian > package koha-common upgrade scripts. We are stuck at koha-common version > 20.05.xx at this point. My latest attempt to upgrade to 20.11.04-1 > resulted in the following three error messages. Is there any way to > manually alter the correct table(s) to fix the database issues? I'm not > sure what the "Failed to enable unit" message means. > > ---------------------------- > Setting up koha-common (20.11.04-1) ... > Installing new version of config file /etc/cron.daily/koha-common ... > Installing new version of config file /etc/init.d/koha-common ... > Installing new version of config file /etc/koha/SIPconfig.xml ... > Installing new version of config file > /etc/koha/apache-shared-intranet-plack.conf ... > Installing new version of config file > /etc/koha/apache-shared-intranet.conf ... > Installing new version of config file /etc/koha/apache-shared-opac.conf ... > Installing new version of config file /etc/koha/koha-conf-site.xml.in < > http://koha-conf-site.xml.in> ... > Installing new version of config file /etc/koha/log4perl-site.conf.in < > http://log4perl-site.conf.in> ... > Installing new version of config file /etc/koha/plack.psgi ... > Installing new version of config file > /etc/koha/zebradb/etc/phrases-icu.xml ... > Installing new version of config file > /etc/koha/zebradb/etc/word-phrase-utf.chr ... > Upgrading database schema for [database] > ....... > Upgrade to 20.06.00.031 done [10:19:38]: Bug 22789 - Add non_priority > column on reserves and old_reserves tables > DBD::mysql::db do failed: Row size too large. The maximum row size for the > used table type, not counting BLOBs, is 8126. This includes storage > overhead, check the manual. You have to change some columns to TEXT or > BLOBs [for Statement "ALTER TABLE `items` ADD COLUMN > `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER > `new_status`"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ > updatedatabase.pl <http://updatedatabase.pl> line 22709. > > DBD::mysql::db do failed: Row size too large. The maximum row size for the > used table type, not counting BLOBs, is 8126. This includes storage > overhead, check the manual. You have to change some columns to TEXT or > BLOBs [for Statement "ALTER TABLE `deleteditems` ADD COLUMN > `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER > new_status`"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ > updatedatabase.pl <http://updatedatabase.pl> line 22715. > ...... > Failed to enable unit: Unit > /run/systemd/generator.late/koha-common.service is transient or generated. > > ---------------------------- > > NOTE: When I then run "/usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl <http://rebuild_zebra.pl> -b -a -z" in this > post-upgrade state I get the following error for each biblio record: > > > DBD::mysql::st execute failed: Unknown column > 'me.exclude_from_local_holds_priority' in 'field list' [for Statement > "SELECT `me`.`itemnumber`, `me`.`biblionumber`, `me`.`biblioitemnumber`, > `me`.`barcode`, `me`.`dateaccessioned`, `me`.`booksellerid`, > `me`.`homebranch`, `me`.`price`, `me`.`replacementprice`, > `me`.`replacementpricedate`, `me`.`datelastborrowed`, `me`.`datelastseen`, > `me`.`stack`, `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`, > `me`.`itemlost`, `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`, > `me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`, > `me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`, > `me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`timestamp`, > `me`.`location`, `me`.`permanent_location`, `me`.`onloan`, > `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`, `me`.`materials`, > `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`, `me`.`enumchron`, > `me`.`copynumber`, `me`.`stocknumber`, `me`.`new_status`, > `me`.`exclude_from_local_holds_priority` FROM `items` `me` WHERE ( > `me`.`itemnumber` = ? )" with ParamValues: 0=1] at > /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. > error retrieving biblio 1 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl <http://rebuild_zebra.pl> line 686. > > Any help would be greatly appreciated. I fear we are getting farther and > farther behind on koha-common versions since we cannot seem to get past the > database schema upgrade errors. > > Scott Leafe > Scriptel Ministries > Houston, Texas > > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] <mailto:[email protected]> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.) _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
