http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7272 --- Comment #6 from Paul Poulain <paul.poulain@biblibre.com> 2011-11-30 13:26:12 UTC --- OK, I think I've found the problem: switching back to tinyint(1) as it was previously, then forcing debarred=0 for patron, then ALTER TABLE borrowers MODIFY debarred DATE DEFAULT NULL => bingo = the debarred now contains 0000-00-00 ! why was debarred containing 0, I don't know for sure, but I feel the problem comes from here. Larry, could you run UPDATE borrowers SET debarred=NULL WHERE debarred="0000-00-00"; and see if that fixes the problem ? If yes, i'll provide a fix to run this query automatically when upgrading. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.