[Koha] Error 500 with dpkg returned an error code (1)

Wed Apr 12 21:59:06 NZST 2023

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 at 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 at 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 at 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 at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha