https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14783
--- Comment #56 from Katrin Fischer <[email protected]> --- (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. _______________________________________________ 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/
