Created attachment 144592 [details] [review] 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
I changed the status, as I think it is more than an enhancement. I will have a go at testing...
Also (for reference) is a report of this error on the mailing list: https://lists.katipo.co.nz/pipermail/koha/2022-December/058794.html
Created attachment 144669 [details] [review] Bug 32470: (Bug 14783 follow-up) Fix mysql error in db_rev for 22.06.000.064 Fix MySQL error: ERROR 1093 (HY000): You can't specify target table 'systempreferences' for update in FROM clause introduced by db_rev 064 for bug 14783. Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Pushed to master for 23.05. Nice work everyone, thanks!
Nice work everyone! Pushed to 22.11.x for the next release
*** Bug 32497 has been marked as a duplicate of this bug. ***