[Koha-bugs] [Bug 26365] Koha/Acquisition/Order.t is failing with MySQL 8
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Sep 8 15:34:31 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26365
Tomás Cohen Arazi <tomascohen at gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #109600|0 |1
is obsolete| |
--- Comment #4 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
Created attachment 109749
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109749&action=edit
Bug 26365: Remove comparison with 0000-00-00 for datecancellationprinted
Using MySQL 8:
t/db_dependent/Koha/Acquisition/Order.t .. 10/11 No method count found for
Koha::Acquisition::Orders DBIx::Class::Storage::DBI::_dbh_execute(): DBI
Exception: DBD::mysql::st execute failed: Incorrect DATE value: '0000-00-00'
[for Statement "SELECT COUNT( * ) FROM `aqorders` `me` WHERE ( ( (
`datecancellationprinted` IS NULL OR `datecancellationprinted` = ? ) AND
`ordernumber` IN ( ?, ?, ? ) ) )" with ParamValues: 0='0000-00-00', 1=23, 2=24,
3=25] at /kohadevbox/koha/Koha/Objects.pm line 597
We must remove the comparison with 0000-00-00
Highlighted by bug 23166.
I wanted to provide a DB rev but we (obviously) cannot:
MySQL [koha_kohadev]> UPDATE aqorders SET datecancellationprinted=NULL WHERE
datecancellationprinted="0000-00-00";
ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column
'datecancellationprinted' at row 1
Signed-off-by: Tomas Cohen Arazi <tomascohen at theke.io>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list