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

[David Cook]

Thanks, Didier. Your suggestion did the trick for sure.

That error message is odd but oh well!

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

-----Original Message-----
From: dgautheron <didier.gautheron at biblibre.com> 
Sent: Tuesday, 17 January 2023 6:04 PM
To: David Cook <dcook at prosentient.com.au>
Cc: 'Koha-devel' <koha-devel at lists.koha-community.org>
Subject: Re: [Koha-devel] Error for "self_checkout" when trying to update borrower via "koha-mysql"

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/