]> git.koha-community.org Git - koha.git/commit
Bug 36875: (follow-up) Modify query in translated_content
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Thu, 16 May 2024 09:25:34 +0000 (09:25 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 6 Jun 2024 08:59:48 +0000 (10:59 +0200)
commitb21106bffbde618066be016807176f02567040e4
tree820dd1016cb1463db27a52bed268e70368b9339c
parent8979cb759245a1b5282d80f60c290554d75e12f7
Bug 36875: (follow-up) Modify query in translated_content

This removes the MySQLism for FIELD(..).
In this case we just want to get the non-default records in
the front. So we can just test lang=default. And prevent inserting
$lang in the expression. And so prevent execution in ORDER BY.
No longer needing the ->quote call too.

Test plan:
Run Koha/AdditionalContents.t again.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit c16f5c61849460489992977812f020ec7fa5c9f3)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Koha/AdditionalContent.pm