[Koha-devel] Error for "self_checkout" when trying to update borrower via "koha-mysql"
Katrin Fischer
katrin.fischer.83 at web.de
Tue Jan 17 22:58:04 CET 2023
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 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230117/69e7a983/attachment.htm>
More information about the Koha-devel
mailing list