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

Wed Apr 12 22:28:25 NZST 2023

Hello Mason, 

The result is: 

+------------+
| value      |
+------------+
| 22.1103000 |
+------------+

Best regards

Aida Đikić

-----Original Message-----
From: Mason James <mtj at kohaaloha.com> 
Sent: Wednesday, April 12, 2023 11:59 AM
To: library at ssst.edu.ba; koha at 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 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