Hi David, I can update all borrowers in ktd:
MariaDB [koha_kohadev]> update borrowers set dateexpiry = "2023-01-01" -> ; Query OK, 53 rows affected (0.004 sec) But: MariaDB [koha_kohadev]> update borrowers set dateexpiry = '2031-04-04' where cardnumber = 1; ERROR 1292 (22007): Truncated incorrect DECIMAL value: 'self_checkout' Maybe this helps: self_checkout is the cardnumber of a patron added with misc4dev: $dbh->do(q|INSERT INTO borrowers ( cardnumber, userid, password, surname, categorycode, branchcode, dateexpiry, flags ) VALUES ( 'self_checkout', 'self_checkout', ?, 'Self-checkout patron', ?, ?, '2099-12-31', 0 )|, undef, $password, $categorycode, $branchcode); Katrin On 17.01.23 07:01, David Cook wrote:
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/
_______________________________________________ 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/