[Koha-bugs] [Bug 14783] Allow patrons to change pickup location for non-waiting holds

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14783

--- Comment #56 from Katrin Fischer <katrin.fischer at 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.