[Koha-bugs] [Bug 7272] Fix for Bug 6328 causes user accounts to be frozen

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Nov 30 14:26:12 CET 2011


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7272

--- Comment #6 from Paul Poulain <paul.poulain at 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.


More information about the Koha-bugs mailing list