[Koha-bugs] [Bug 29138] LoadSearchHistoryToTheFirstLoggedUser should save 0 instead of "no"

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

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

--- Comment #11 from Andrew Fuerste-Henry <andrew at bywatersolutions.com> ---
Huh, I didn't get that error:
MariaDB [koha_kohadev]> select value from systempreferences where
variable="LoadSearchHistoryToTheFirstLoggedUser";
+-------+
| value |
+-------+
| no    |
+-------+
1 row in set (0.000 sec)

MariaDB [koha_kohadev]> UPDATE systempreferences SET value= IF(value in
(0,'no'),0,1) WHERE variable = 'LoadSearchHistoryToTheFirstLoggedUser';
Query OK, 1 row affected, 1 warning (0.003 sec)
Rows matched: 1  Changed: 1  Warnings: 1

MariaDB [koha_kohadev]> select value from systempreferences where
variable="LoadSearchHistoryToTheFirstLoggedUser";
+-------+
| value |
+-------+
| 0     |
+-------+
1 row in set (0.001 sec)

-- 
You are receiving this mail because:
You are watching all bug changes.