https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29138
--- Comment #10 from Jonathan Druart <[email protected]> --- (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. _______________________________________________ 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/
