https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32470 Bug ID: 32470 Summary: (Bug 14783 follow-up) Fix mysql error in db_rev for 22.06.000.064 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests Assignee: koha-bugs@lists.koha-community.org Reporter: michael.hafen@washk12.org QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Created attachment 144592 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=144592&action=edit Proposed fix The db_rev for 22.06.000.064 throws an error in MySQL: ERROR 1093 (HY000): You can't specify target table 'systempreferences' for update in FROM clause Test plan: install Koha 22.06.0 with db_rev 064 with MySQL database run koha-upgrade-schema and note MySQL error while processing db_rev 064 apply patch run koha-upgrade-schema again and note there is no MySQL error for db_rev 064 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.