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@lists.katipo.co.nz> On Behalf Of koha-request@lists.katipo.co.nz Sent: Thursday, April 6, 2023 2:00 AM To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 210, Issue 5 Send Koha mailing list submissions to koha@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@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."