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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
