Error for "self_checkout" when trying to update borrower via "koha-mysql"
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
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/
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/
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/
participants (3)
-
David Cook -
dgautheron -
Katrin Fischer