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@biblibre.com> Sent: Tuesday, 17 January 2023 6:04 PM To: David Cook <dcook@prosentient.com.au> Cc: 'Koha-devel' <koha-devel@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@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/