https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34684 --- Comment #1 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Created attachment 155056 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=155056&action=edit Bug 34684: Prevent 220600007.pl to fail if run twice The error is ERROR 1292 (22007): Truncated incorrect DECIMAL value: 'no' Happens on MariaDB 10.5.22, not MySQL 8 Test plan: update systempreferences set value="0" where variable="DisplayClearScreenButton"; play installer/data/mysql/db_revs/220600007.pl select value from systempreferences where variable="DisplayClearScreenButton"; => "no" update systempreferences set value="1" where variable="DisplayClearScreenButton"; play installer/data/mysql/db_revs/220600007.pl select value from systempreferences where variable="DisplayClearScreenButton"; => "issueslip" -- You are receiving this mail because: You are watching all bug changes.