https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14783 --- Comment #56 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Michael Hafen from comment #54)

Created attachment 143025 [details] [review] Bug 14783: (follow-up) MySQL doesn't like selecting from a table it is updating

I have a problem with the db_rev. MySQL doesn't allow selecting from a table you are updating (which has tripped me up before too). MySQL error message:

ERROR 1093 (HY000): You can't specify target table 'systempreferences' for update in FROM clause

The value needs to be selected separately.

It looks like the follow-up might not completely fix the issue. Maybe the tables need to be named differently? s1 and s2? See report on the mailing list: https://lists.katipo.co.nz/pipermail/koha/2022-December/058794.html -- You are receiving this mail because: You are watching all bug changes.