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

Mon Apr 17 21:47:15 NZST 2023

Hello all, 

After the initial nudge by Mason and some digging online, I found an incomplete installation on the work server from way back when I was struggling harder than I do today :) I went ahead and completed the interrupted installation, this time choosing MARC21 as the flavor it would use, and managed to complete it. I again came across the default Apache page I had trouble getting past last time, but later found that you are supposed to clear your browser cache after restarting the Apache server. 

Last week and today I was able to catalog a few of my books in the MARC21 instance (yay!) though I will still need to spend some time to make sure I'm doing it correctly (especially the titles published locally which I can't find via Z39.50 - when I get to the Cataloging source 040 is there anything special I need to add there, or just my initials as I'm the one doing the cataloging?). There's many other things too (course reserves, acquisitions...) but this is a start. 

I'm guessing the 500 error in the UNIMARC instance was most likely caused by my messing with the Books, booklets, workbook framework. I've removed that instance completely but I'd still like to set up a UNIMARC library, so if anyone has experience with that I'd appreciate their advice, especially with the correct framework to use. Trying to catalogue anything using the BBW framework based on the default one was an exercise in futility since there were a lot of fields that didn't apply to my books, and my attempt to solve that problem obviously didn't work. 

Alternatively, if I must continue to use the MARC21 flavor, and since by default both the staff interface and OPAC show the DDC classification, is it possible to replace that with UDC? 

Best regards

Aida Đikić

-----Original Message-----
From: library at ssst.edu.ba <library at ssst.edu.ba> 
Sent: Wednesday, April 12, 2023 12:28 PM
To: Mason James <mtj at kohaaloha.com>; koha at lists.katipo.co.nz
Subject: Re: [Koha] Error 500 with dpkg returned an error code (1)

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