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.
Hi Hanna, a fix for this will be in 22.11.01, see bug 32470. *** This bug has been marked as a duplicate of bug 32470 ***