https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38150
Katrin Fischer <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED --- Comment #1 from Katrin Fischer <[email protected]> --- Hi, this is due to an invalid date in your borrowers table (0000-00-00). Bug 31143 works on a script to identify and fix these errors. Meanwhile you can find the problematic ones with SQL: select date_renewed, dateofbirth, dateenrolled, dateexpiry, lastseen, updated_on, debarred from borrowers where date_renewed = '0000-00-00' or dateexpiry = '0000-00-00' or dateenrolled = '0000-00-00' or dateofbirth = '0000-00-00' or lastseen = '0000-00-00' or updated_on = '0000-00-00' or debarred = '0000-00-00'; You need to replace them with NULL. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
