Hello Mason, The result is:
+------------+ | value | +------------+ | 22.1103000 | +------------+ Best regards Aida Đikić -----Original Message----- From: Mason James <m...@kohaaloha.com> Sent: Wednesday, April 12, 2023 11:59 AM To: libr...@ssst.edu.ba; koha@lists.katipo.co.nz Subject: Re: [Koha] Error 500 with dpkg returned an error code (1) hi Aida, what does the following command say? $ sudo koha-mysql library -e ' select value from systempreferences where variable = "version" ' +------------+ | value | +------------+ | 21.1117000 | <<<<<<<<< +------------+ On 11/04/23 1:24 am, libr...@ssst.edu.ba wrote: > Hello all, > > I keep coming up against error 500 when trying to add a record (no matter > which framework I try to use or whether it's via a Z39.50 server or manual > entry) as well as when going to the About Koha page in the staff interface. > When I opened the terminal, there were 2 updates to be applied so I ran the > update but it does not work. Here is the entire output: > > 2 updates can be applied immediately. > To see these additional updates run: apt list --upgradable > > Enable ESM Apps to receive additional future security updates. > See https://ubuntu.com/esm or run: sudo pro status > > > Last login: Mon Apr 10 11:34:09 2023 from 10.1.3.133 root@koha:~# apt > list --upgradable Listing... Done distro-info-data/jammy-updates > 0.52ubuntu0.3 all [upgradable from: 0.52ubuntu0.2] > grub-efi-amd64-bin/jammy-updates 2.06-2ubuntu14.1 amd64 [upgradable > from: 2.06-2ubuntu10] grub-efi-amd64-signed/jammy-updates > 1.187.3~22.04.1+2.06-2ubuntu14.1 amd64 [upgradable from: > 1.182~22.04.1+2.06-2ubuntu10] grub-efi-amd64/jammy-updates > 2.06-2ubuntu14.1 amd64 [upgradable from: 2.06-2ubuntu10] > shim-signed/jammy-updates 1.51.3+15.7-0ubuntu1 amd64 [upgradable from: > 1.51+15.4-0ubuntu9] root@koha:~# apt-get update > Hit:1 http://ba.archive.ubuntu.com/ubuntu jammy InRelease > Hit:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates InRelease > Hit:3 http://ba.archive.ubuntu.com/ubuntu jammy-backports InRelease > Hit:4 http://ba.archive.ubuntu.com/ubuntu jammy-security InRelease > Hit:5 http://debian.koha-community.org/koha stable InRelease Reading > package lists... Done > W: http://debian.koha-community.org/koha/dists/stable/InRelease: Key is > stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the > DEPRECATION section in apt-key(8) for details. > root@koha:~# apt-get upgrade > Reading package lists... Done > Building dependency tree... Done > Reading state information... Done > Calculating upgrade... Done > The following packages will be upgraded: > distro-info-data grub-efi-amd64 grub-efi-amd64-bin grub-efi-amd64-signed > shim-signed > 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. > 1 not fully installed or removed. > Need to get 3,699 kB of archives. > After this operation, 5,861 kB of additional disk space will be used. > Do you want to continue? [Y/n] Y > Get:1 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 > distro-info-data all 0.52ubuntu0.3 [5,258 B] > Get:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 > grub-efi-amd64 amd64 2.06-2ubuntu14.1 [47.1 kB] > Get:3 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 > grub-efi-amd64-signed amd64 1.187.3~22.04.1+2.06-2ubuntu14.1 [1,388 > kB] > Get:4 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 > grub-efi-amd64-bin amd64 2.06-2ubuntu14.1 [1,591 kB] > Get:5 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 > shim-signed amd64 1.51.3+15.7-0ubuntu1 [667 kB] Fetched 3,699 kB in 0s > (13.8 MB/s) Preconfiguring packages ... > (Reading database ... 152607 files and directories currently > installed.) Preparing to unpack .../distro-info-data_0.52ubuntu0.3_all.deb ... > Unpacking distro-info-data (0.52ubuntu0.3) over (0.52ubuntu0.2) ... > Preparing to unpack .../grub-efi-amd64_2.06-2ubuntu14.1_amd64.deb ... > Unpacking grub-efi-amd64 (2.06-2ubuntu14.1) over (2.06-2ubuntu10) ... > Preparing to unpack > .../grub-efi-amd64-signed_1.187.3~22.04.1+2.06-2ubuntu14.1_amd64.deb ... > Unpacking grub-efi-amd64-signed (1.187.3~22.04.1+2.06-2ubuntu14.1) over > (1.182~22.04.1+2.06-2ubuntu10) ... > Preparing to unpack .../grub-efi-amd64-bin_2.06-2ubuntu14.1_amd64.deb ... > Unpacking grub-efi-amd64-bin (2.06-2ubuntu14.1) over (2.06-2ubuntu10) ... > Preparing to unpack .../shim-signed_1.51.3+15.7-0ubuntu1_amd64.deb ... > Unpacking shim-signed (1.51.3+15.7-0ubuntu1) over (1.51+15.4-0ubuntu9) ... > Setting up koha-common (22.11.03-1) ... > 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 distro-info-data (0.52ubuntu0.3) ... > Setting up grub-efi-amd64-bin (2.06-2ubuntu14.1) ... > Setting up grub-efi-amd64 (2.06-2ubuntu14.1) ... > Installing grub to /boot/efi. > Installing for x86_64-efi platform. > Installation finished. No error reported. > Sourcing file `/etc/default/grub' > Sourcing file `/etc/default/grub.d/init-select.cfg' > Generating grub configuration file ... > Found linux image: /boot/vmlinuz-5.15.0-69-generic Found initrd image: > /boot/initrd.img-5.15.0-69-generic > Found linux image: /boot/vmlinuz-5.15.0-60-generic Found initrd image: > /boot/initrd.img-5.15.0-60-generic > Warning: os-prober will not be executed to detect other bootable partitions. > Systems on them will not be added to the GRUB boot configuration. > Check GRUB_DISABLE_OS_PROBER documentation entry. > Adding boot menu entry for UEFI Firmware Settings ... > done > Setting up grub-efi-amd64-signed (1.187.3~22.04.1+2.06-2ubuntu14.1) ... > Installing grub to /boot/efi. > Installing for x86_64-efi platform. > Installation finished. No error reported. > Setting up shim-signed (1.51.3+15.7-0ubuntu1) ... > update-alternatives: using /usr/lib/shim/shimx64.efi.signed.latest to > provide /usr/lib/shim/shimx64.efi.signed (shimx64.efi.signed) in auto mode > Installing grub to /boot/efi. > Installing for x86_64-efi platform. > Installation finished. No error reported. > 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) > > Can anybody advise me on what I should do? > > Best regards > > Aida Đikić > Librarian > > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
