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

[dgautheron]

Hi
Maybe because cardnumber is a varchar rather than a number?

Did you try :
update borrowers set dateexpiry = '2031-04-04' where cardnumber = '1';


> 
Le 2023-01-17 07:01, David Cook a écrit :
> 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
> 
> 
> 
> 
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/