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@lists.koha-community.org Reporter: hannah.co@northwestu.edu QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@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.