[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