[Koha] Another DBI Exception for foreign key constraint in upgrade to Koha - mysql vs. mariadb

[Harald Schaefer]

Hi,

on my system using mysql I had the same error.

Comment 34 for Bug 31086 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31086#c34 helps.

It seems that KOHA with mariadb is better tested than KOHA with mysql.

Is there a way to exchange the underlying database mysql by mariadb?

Greetings Harald

Am 10.10.22 um 23:00 schrieb Katrin Fischer:
> Hi David,
>
> please have a look at this bug and the comments there:
>
> *Bug 31673*
> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31673> - DB
> update of bug 31086
> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31086> fails:
> Cannot change column 'branchcode': used in a foreign key constraint
>
> Hope this helps,
>
> Katrin
>
> On 10.10.22 22:40, David L. Whelchel wrote:
>> Hi,
>>
>> The following message was sent and held by the moderator as being too 
>> long ten days ago. I have been unable to update to the current 
>> version because of this issue. I have removed the detail about the 
>> environment and installation that I included and that are usually 
>> asked for in a bug report. I will send the details if they are wanted
>>
>>
>> Hi All,
>>
>> It seems like that for every other update I experience a DBI 
>> Exception in the update process. In the latest upgrade of 22.05.04-1 
>> to 22.05.05-1 I have received the message:
>>
>>       Upgrade to 22.05.04.002  [14:33:32]: Bug 31086 - Do not allow 
>> null values in branchcodes for reserves
>>       ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: 
>> Cannot change column 'branchcode':
>>       used in a foreign key constraint 'reserves_ibfk_4' at 
>> /usr/share/koha/lib/C4/Installer.pm line 739
>>
>> Indeed, there are null values for branchcodes in the reserves table 
>> as I do not have any courses or reserves in my system. Is there a fix 
>> for this error? I have included the console log below:
>>
>>
>> Thanks
>>
>> --Dave
>> ------------------------------------------------------------------------------- 
>>
>> David L. Whelchel
>> 725 SE Derby Street
>> Pullman, WA 99163
>> whelchel at pullman.com
>>
>> _______________________________________________
>>
>> Koha mailing listhttp://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha