[Koha-bugs] [Bug 24130] New: Update 18.12.00.024 can fail due to bad date data
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Nov 27 16:33:26 CET 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24130
Bug ID: 24130
Summary: Update 18.12.00.024 can fail due to bad date data
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: blocker
Priority: P5 - low
Component: Database
Assignee: koha-bugs at lists.koha-community.org
Reporter: martin.renvoize at ptfs-europe.com
QA Contact: testopia at bugs.koha-community.org
DBD::mysql::db do failed: Incorrect date value: '0000-00-00' for column
'suggesteddate' at row 1 [for Statement "ALTER TABLE suggestions ADD
CONSTRAINTsuggestions_ibfk_suggestedbyFOREIGN KEY (suggestedby)
REFERENCESborrowers(borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE"] at
/installer/data/mysql/updatedatabase.pl line 17646.
DBD::mysql::db do failed: Incorrect date value: '0000-00-00' for column
'suggesteddate' at row 1 [for Statement "ALTER TABLE suggestions ADD
CONSTRAINTsuggestions_ibfk_managedbyFOREIGN KEY (managedby)
REFERENCESborrowers(borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE"] at
/installer/data/mysql/updatedatabase.pl line 17657.
DBD::mysql::db do failed: Incorrect date value: '0000-00-00' for column
'suggesteddate' at row 1 [for Statement "ALTER TABLE suggestions ADD
CONSTRAINTsuggestions_ibfk_acceptedbyFOREIGN KEY (acceptedby)
REFERENCESborrowers(borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE"] at
/installer/data/mysql/updatedatabase.pl line 17669.
DBD::mysql::db do failed: Incorrect date value: '0000-00-00' for column
'suggesteddate' at row 1 [for Statement "ALTER TABLE suggestions ADD
CONSTRAINTsuggestions_ibfk_rejectedbyFOREIGN KEY (rejectedby)
REFERENCESborrowers(borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE"] at
/installer/data/mysql/updatedatabase.pl line 17681.
DBD::mysql::db do failed: Incorrect date value: '0000-00-00' for column
'suggesteddate' at row 1 [for Statement "ALTER TABLE suggestions ADD
CONSTRAINTsuggestions_ibfk_biblionumberFOREIGN KEY (biblionumber)
REFERENCESbiblio(biblionumber) ON DELETE SET NULL ON UPDATE CASCADE"] at
/installer/data/mysql/updatedatabase.pl line 17693.
DBD::mysql::db do failed: Incorrect date value: '0000-00-00' for column
'suggesteddate' at row 1 [for Statement "ALTER TABLE suggestions ADD
CONSTRAINTsuggestions_ibfk_branchcodeFOREIGN KEY (branchcode)
REFERENCESbranches(branchcode) ON DELETE SET NULL ON UPDATE CASCADE"] at
/installer/data/mysql/updatedatabase.pl line 17705.
This is undoubtedly due to bad data having been left behind after bug 12627.
I think the most pragmatic approach is to just update any such values with a
default date far in the past.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list