[Koha-bugs] [Bug 29138] LoadSearchHistoryToTheFirstLoggedUser should save 0 instead of "no"
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Oct 7 16:24:51 CEST 2021
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29138
--- Comment #10 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
(In reply to Andrew Fuerste-Henry from comment #9)
> Updated to:
> UPDATE systempreferences SET value= IF(value in (0,'no'),0,1) WHERE variable
> = 'LoadSearchHistoryToTheFirstLoggedUser';
Does it work?
MariaDB [koha_kohadev]> select value from systempreferences where
variable="LoadSearchHistoryToTheFirstLoggedUser";
+-------+
| value |
+-------+
| no |
+-------+
1 row in set (0.001 sec)
MariaDB [koha_kohadev]> UPDATE systempreferences SET value=IF(value in
(0,'no'),0,1) WHERE variable = 'LoadSearchHistoryToTheFirstLoggedUser';
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'no'
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list