[Koha] Upgrade errors

[Tim Young]

Well, it appears that the issue is with this file:

  /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/local_cover_images.pl

When I manually try to run the sql "create table", I am getting:

ERROR 1826 (HY000): Duplicate foreign key constraint name 
'bibliocoverimage_fk1'

The create table causing this is:

  CREATE TABLE `biblioimages` (
     ->       `imagenumber` int(11) NOT NULL AUTO_INCREMENT,
     ->       `biblionumber` int(11) NOT NULL,
     ->       `mimetype` varchar(15) NOT NULL,
     ->       `imagefile` mediumblob NOT NULL,
     ->       `thumbnail` mediumblob NOT NULL,
     ->       PRIMARY KEY (`imagenumber`),
     ->       CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY 
(`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE 
ON UPDATE CASCADE
     ->       ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If I look for a pre-existing constraint:

select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE 
= 'FOREIGN KEY' and CONSTRAINT_NAME = 'bibliocoverimage_fk1';

I do see one there for my database.

Any thoughts on how I should proceed?

     - Tim


On 1/7/2025 3:07 PM, Tim Young wrote:
> I was helping some people do-release-upgrade from Ubuntu 18.04, to 
> 22.04 and their koha was updated as well.
>
> I believe the previous version was 21.05.05-3.
>
> We upgraded the OS on the machine to 20.04, then to 22.04, and then 
> upgraded Koha to 24.11.00-1.  During the package configuration 
> (repeatable by doing: dpkg --configure koha-common) we get the 
> following response and error:
>
> root at elearning:/var/log# dpkg --configure koha-common
> Setting up koha-common (24.11.00-1) ...
> Upgrading database schema for opac
> Can't use string ("0E0") as a HASH ref while "strict refs" in use at 
> /usr/share/koha/lib/C4/Installer.pm line 757.
> dpkg: error processing package koha-common (--configure):
>  installed koha-common package post-installation script subprocess 
> returned error exit status 255
> Errors were encountered while processing:
>  koha-common
>
>
> I tried looking through the log files to see if there was an "install 
> log," but I did not see one.  The code looks like it is applying 
> individual updates schema, and one of them is failing.  I am not sure 
> how to figure out which one is failing, to then figure out why.
>