[Koha-bugs] [Bug 32497] New: Updating Database Structure fails with table "specified twice"

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

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

            Bug ID: 32497
           Summary: Updating Database Structure fails with table
                    "specified twice"
 Change sponsored?: ---
           Product: Koha
           Version: 22.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Installation and upgrade (web-based installer)
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: hannah.co at northwestu.edu
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com

Upgrading from 22.05 to 22.11, the web installer is failing at "Updating
database structure" with the following error:

Upgrade to 22.06.00.064 [11:24:08]: Bug 14783 - Allow patrons to change pickup
location for non-waiting holds
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table
'systempreferences' is specified twice, both as a target for 'UPDATE' and as a
separate source for data at /usr/share/koha/lib/C4/Installer.pm line 739
Added new system preference 'OPACAllowUserToChangeBranch'
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table
'systempreferences' is specified twice, both as a target for 'UPDATE' and as a
separate source for data at /usr/share/koha/lib/C4/Installer.pm line 739

I am looking for a solution to this one, and not finding much that's helpful.
Does installer.pm need modification, or does the database need some changes.
Prior to the error I followed steps to resolve errors related to bug 32399,
with errors on the issues table and a couple foreign keys. I don't see how the
systempreferences table is related, though.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.