Bug 24130 - Update 18.12.00.024 can fail due to bad date data
Summary: Update 18.12.00.024 can fail due to bad date data
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low blocker (vote)
Assignee: Martin Renvoize
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-27 15:33 UTC by Martin Renvoize
Modified: 2021-06-14 21:29 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
19.11.00


Attachments
Bug 24130: (RM follow-up) Fix old invalid data (1.30 KB, patch)
2019-11-27 15:55 UTC, Martin Renvoize
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Renvoize 2019-11-27 15:33:26 UTC
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.
Comment 1 Martin Renvoize 2019-11-27 15:55:10 UTC
Created attachment 95850 [details] [review]
Bug 24130: (RM follow-up) Fix old invalid data

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>