Hello Mason, The result is: +------------+ | value | +------------+ | 22.1103000 | +------------+ Best regards Aida Đikić -----Original Message----- From: Mason James <mtj@kohaaloha.com> Sent: Wednesday, April 12, 2023 11:59 AM To: library@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, library@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