<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi David,</p>
<p>I can update all borrowers in ktd:<br>
</p>
<p>MariaDB [koha_kohadev]> update borrowers set dateexpiry =
"2023-01-01"<br>
-> ;<br>
Query OK, 53 rows affected (0.004 sec)</p>
<p>But:</p>
<p>MariaDB [koha_kohadev]> update borrowers set dateexpiry =
'2031-04-04' where cardnumber = 1;<br>
ERROR 1292 (22007): Truncated incorrect DECIMAL value:
'self_checkout'<br>
</p>
<p>Maybe this helps: self_checkout is the cardnumber of a patron
added with misc4dev:</p>
<p>$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);</p>
<p>Katrin</p>
<p></p>
<div class="moz-cite-prefix">On 17.01.23 07:01, David Cook wrote:<br>
</div>
<blockquote type="cite"
cite="mid:020601d92a39$23566fb0$6a034f10$@prosentient.com.au">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:DengXian;
panose-1:2 1 6 0 3 1 1 1 1 1;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:"\@DengXian";
panose-1:2 1 6 0 3 1 1 1 1 1;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Has anyone else seen the following error
when trying to update via “koha-mysql” in koha-testing-docker?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">--<o:p></o:p></p>
<p class="MsoNormal">koha-mysql kohadev<o:p></o:p></p>
<p class="MsoNormal">Reading table information for completion of
table and column names<o:p></o:p></p>
<p class="MsoNormal">You can turn off this feature to get a
quicker startup with -A<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Welcome to the MariaDB monitor. Commands
end with ; or \g.<o:p></o:p></p>
<p class="MsoNormal">Your MariaDB connection id is 54<o:p></o:p></p>
<p class="MsoNormal">Server version:
10.5.17-MariaDB-1:10.5.17+maria~ubu2004 mariadb.org binary
distribution<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Type 'help;' or '\h' for help. Type '\c' to
clear the current input statement.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">MariaDB [koha_kohadev]> update borrowers
set dateexpiry = '2031-04-04' where cardnumber = 1;<o:p></o:p></p>
<p class="MsoNormal">ERROR 1292 (22007): Truncated incorrect
DECIMAL value: 'self_checkout' <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">David Cook<o:p></o:p></p>
<p class="MsoNormal">Senior Software Engineer<o:p></o:p></p>
<p class="MsoNormal">Prosentient Systems<o:p></o:p></p>
<p class="MsoNormal">Suite 7.03<o:p></o:p></p>
<p class="MsoNormal">6a Glen St<o:p></o:p></p>
<p class="MsoNormal">Milsons Point NSW 2061<o:p></o:p></p>
<p class="MsoNormal">Australia<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Office: 02 9212 0899<o:p></o:p></p>
<p class="MsoNormal">Online: 02 8005 0595<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Koha-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a>
<a class="moz-txt-link-freetext" href="https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a class="moz-txt-link-freetext" href="https://www.koha-community.org/">https://www.koha-community.org/</a>
git : <a class="moz-txt-link-freetext" href="https://git.koha-community.org/">https://git.koha-community.org/</a>
bugs : <a class="moz-txt-link-freetext" href="https://bugs.koha-community.org/">https://bugs.koha-community.org/</a>
</pre>
</blockquote>
</body>
</html>