[Koha-bugs] [Bug 32399] New: Database update for bug 30483 is failing

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32399

            Bug ID: 32399
           Summary: Database update for bug 30483 is failing
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Installation and upgrade (web-based installer)
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com
        Depends on: 30483

We have had 2 reports recently of this database update failing:

22.06.00.041  [09:45:46]: Bug 30483 - Make issues.borrowernumber and
issues.itemnumber NOT NULLERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do
failed: Cannot change column 'borrowernumber': used in a foreign key constraint
'issues_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 739

And:

Upgrade to 22.05.06.001 [19:37:23]: Bug 30483 - Make issues.borrowernumber and
itemnumber NOT NULL
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column
'borrowernumber': used in a foreign key constraint 'issues_ibfk_1' at
/usr/share/koha/lib/C4/Installer.pm line 739 

Both refer to the same bug/SQL statements, but backported to different
versions.


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30483
[Bug 30483] Do not allow NULL in issues.borrowernumber and issues.itemnumber
-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.