[Koha-devel] Error for "self_checkout" when trying to update borrower via "koha-mysql"

[David Cook]

Hi all,

 

Has anyone else seen the following error when trying to update via
"koha-mysql" in koha-testing-docker?

 

I can update borrowers via the Web UI but not via koha-mysql. I have no idea
where this "self_checkout" value is coming from as well.

 

--

koha-mysql kohadev

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

 

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 54

Server version: 10.5.17-MariaDB-1:10.5.17+maria~ubu2004 mariadb.org binary
distribution

 

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

 

MariaDB [koha_kohadev]> update borrowers set dateexpiry = '2031-04-04' where
cardnumber = 1;

ERROR 1292 (22007): Truncated incorrect DECIMAL value: 'self_checkout'


 

David Cook

Senior Software Engineer

Prosentient Systems

Suite 7.03

6a Glen St

Milsons Point NSW 2061

Australia

 

Office: 02 9212 0899

Online: 02 8005 0595

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230117/23fa6317/attachment.htm>