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/