[Koha] Koha Digest, Vol 210, Issue 5

library at ssst.edu.ba library at ssst.edu.ba
Thu Apr 6 20:04:59 NZST 2023 

Hello all, 

I need some help with the update to this version! I ran the update and got the following error: 

Get:1 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 update-notifier-common all 3.192.54.6 [185 kB]
Get:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libapparmor1 amd64 3.0.4-2ubuntu2.2 [39.2 kB]
Get:3 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 netplan.io amd64 0.105-0ubuntu2~22.04.3 [92.9 kB]
Get:4 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libnetplan0 amd64 0.105-0ubuntu2~22.04.3 [103 kB]
Get:5 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 apparmor amd64 3.0.4-2ubuntu2.2 [595 kB]
Get:6 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 bind9-host amd64 1:9.18.12-0ubuntu0.22.04.1 [52.4 kB]
Get:7 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 bind9-dnsutils amd64 1:9.18.12-0ubuntu0.22.04.1 [157 kB]
Get:8 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 bind9-libs amd64 1:9.18.12-0ubuntu0.22.04.1 [1,240 kB]
Get:9 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 rabbitmq-server all 3.9.13-1ubuntu0.22.04.1 [15.2 MB]
Get:10 http://debian.koha-community.org/koha stable/main amd64 koha-common all 22.11.03-1 [48.4 MB]
Get:11 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libldap-2.5-0 amd64 2.5.14+dfsg-0ubuntu0.22.04.1 [183 kB]
Get:12 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libldap-common all 2.5.14+dfsg-0ubuntu0.22.04.1 [15.9 kB]
Get:13 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 linux-firmware all 20220329.git681281e4-0ubuntu3.12 [249 MB]
Get:14 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 thermald amd64 2.4.9-1ubuntu0.2 [212 kB]
Get:15 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 cloud-init all 23.1.1-0ubuntu0~22.04.1 [530 kB]
Fetched 316 MB in 44s (7,151 kB/s)
Preconfiguring packages ...
(Reading database ... 150255 files and directories currently installed.)
Preparing to unpack .../00-update-notifier-common_3.192.54.6_all.deb ...
Unpacking update-notifier-common (3.192.54.6) over (3.192.54.5) ...
Preparing to unpack .../01-libapparmor1_3.0.4-2ubuntu2.2_amd64.deb ...
Unpacking libapparmor1:amd64 (3.0.4-2ubuntu2.2) over (3.0.4-2ubuntu2.1) ...
Preparing to unpack .../02-netplan.io_0.105-0ubuntu2~22.04.3_amd64.deb ...
Unpacking netplan.io (0.105-0ubuntu2~22.04.3) over (0.105-0ubuntu2~22.04.1) ...
Preparing to unpack .../03-libnetplan0_0.105-0ubuntu2~22.04.3_amd64.deb ...
Unpacking libnetplan0:amd64 (0.105-0ubuntu2~22.04.3) over (0.105-0ubuntu2~22.04.1) ...
Preparing to unpack .../04-apparmor_3.0.4-2ubuntu2.2_amd64.deb ...
Unpacking apparmor (3.0.4-2ubuntu2.2) over (3.0.4-2ubuntu2.1) ...
Preparing to unpack .../05-bind9-host_1%3a9.18.12-0ubuntu0.22.04.1_amd64.deb ...
Unpacking bind9-host (1:9.18.12-0ubuntu0.22.04.1) over (1:9.18.1-1ubuntu1.3) ...
Preparing to unpack .../06-bind9-dnsutils_1%3a9.18.12-0ubuntu0.22.04.1_amd64.deb ...
Unpacking bind9-dnsutils (1:9.18.12-0ubuntu0.22.04.1) over (1:9.18.1-1ubuntu1.3) ...
Preparing to unpack .../07-bind9-libs_1%3a9.18.12-0ubuntu0.22.04.1_amd64.deb ...
Unpacking bind9-libs:amd64 (1:9.18.12-0ubuntu0.22.04.1) over (1:9.18.1-1ubuntu1.3) ...
Preparing to unpack .../08-rabbitmq-server_3.9.13-1ubuntu0.22.04.1_all.deb ...
Unpacking rabbitmq-server (3.9.13-1ubuntu0.22.04.1) over (3.9.13-1) ...
Preparing to unpack .../09-koha-common_22.11.03-1_all.deb ...
Unpacking koha-common (22.11.03-1) over (22.11.01-1) ...
Preparing to unpack .../10-libldap-2.5-0_2.5.14+dfsg-0ubuntu0.22.04.1_amd64.deb ...
Unpacking libldap-2.5-0:amd64 (2.5.14+dfsg-0ubuntu0.22.04.1) over (2.5.13+dfsg-0ubuntu0.22.04.1) ...
Preparing to unpack .../11-libldap-common_2.5.14+dfsg-0ubuntu0.22.04.1_all.deb ...
Unpacking libldap-common (2.5.14+dfsg-0ubuntu0.22.04.1) over (2.5.13+dfsg-0ubuntu0.22.04.1) ...
Preparing to unpack .../12-linux-firmware_20220329.git681281e4-0ubuntu3.12_all.deb ...
Unpacking linux-firmware (20220329.git681281e4-0ubuntu3.12) over (20220329.git681281e4-0ubuntu3.10) ...
Preparing to unpack .../13-thermald_2.4.9-1ubuntu0.2_amd64.deb ...
Unpacking thermald (2.4.9-1ubuntu0.2) over (2.4.9-1ubuntu0.1) ...
Preparing to unpack .../14-cloud-init_23.1.1-0ubuntu0~22.04.1_all.deb ...
Unpacking cloud-init (23.1.1-0ubuntu0~22.04.1) over (22.4.2-0ubuntu0~22.04.1) ...
Setting up rabbitmq-server (3.9.13-1ubuntu0.22.04.1) ...
Setting up libapparmor1:amd64 (3.0.4-2ubuntu2.2) ...
Setting up bind9-libs:amd64 (1:9.18.12-0ubuntu0.22.04.1) ...
Setting up linux-firmware (20220329.git681281e4-0ubuntu3.12) ...
update-initramfs: Generating /boot/initrd.img-5.15.0-69-generic
update-initramfs: Generating /boot/initrd.img-5.15.0-60-generic
Setting up update-notifier-common (3.192.54.6) ...
update-notifier-download.service is a disabled or a static unit not running, not starting it.
update-notifier-motd.service is a disabled or a static unit not running, not starting it.
Setting up libnetplan0:amd64 (0.105-0ubuntu2~22.04.3) ...
Setting up libldap-common (2.5.14+dfsg-0ubuntu0.22.04.1) ...
Setting up libldap-2.5-0:amd64 (2.5.14+dfsg-0ubuntu0.22.04.1) ...
Setting up netplan.io (0.105-0ubuntu2~22.04.3) ...
Setting up apparmor (3.0.4-2ubuntu2.2) ...
Reloading AppArmor profiles
Skipping profile in /etc/apparmor.d/disable: usr.sbin.rsyslogd
Setting up bind9-host (1:9.18.12-0ubuntu0.22.04.1) ...
Setting up thermald (2.4.9-1ubuntu0.2) ...
Setting up koha-common (22.11.03-1) ...
Installing new version of config file /etc/koha/log4perl-site.conf.in ...
Installing new version of config file /etc/koha/zebradb/authorities/etc/bib1.att ...
Installing new version of config file /etc/koha/zebradb/biblios/etc/bib1.att ...
Installing new version of config file /etc/koha/zebradb/ccl.properties ...
Upgrading database schema for library
	DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
	DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
	Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 78.
	DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
	DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
	DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
	DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
	Undefined subroutine &main::DropAllForeignKeys called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 86.
	dpkg: error processing package koha-common (--configure):
 installed koha-common package post-installation script subprocess returned error exit status 255
Setting up cloud-init (23.1.1-0ubuntu0~22.04.1) ...
Installing new version of config file /etc/cloud/cloud.cfg ...
Setting up bind9-dnsutils (1:9.18.12-0ubuntu0.22.04.1) ...
Processing triggers for rsyslog (8.2112.0-2ubuntu2.2) ...
Processing triggers for man-db (2.10.2-1) ...
Processing triggers for dbus (1.12.20-2ubuntu4.1) ...
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
Errors were encountered while processing:
 koha-common
needrestart is being skipped since dpkg has failed
E: Sub-process /usr/bin/dpkg returned an error code (1)


I see in the error message that some tables don't exist (indented to be easier to see). I assume this is the cause of the problem. How do I fix this? Thank you in advance!

Best regards

Aida Đikić


-----Original Message-----
From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of koha-request at lists.katipo.co.nz
Sent: Thursday, April 6, 2023 2:00 AM
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 210, Issue 5

Send Koha mailing list submissions to
	koha at lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
	koha-request at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at lists.katipo.co.nz

When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."

More information about the Koha mailing list