]> 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)
committerKatrin Fischer <katrin.fischer@bsz-bw.de>
Thu, 20 Jun 2024 15:55:39 +0000 (17:55 +0200)
commit8d9be6f59b0af93e473b0da67a32e06ba0449851
tree625b999d7400494b49282ee4f89c388ab6e71646
parentaad430acc0cf0c0c74f16e5cb07db5c9723b790d
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>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
Koha/AdditionalContent.pm