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
whelc...@pullman.com

_______________________________________________

Koha mailing listhttp://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to