From a301e74dd60e7ed51ac9bdec36e5e676aaafdfee Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Wed, 30 Nov 2011 14:53:48 +0100 Subject: [PATCH] Bug 7272 setting NULL to debarred field, to avoid having 0000-00-00 0000-00-00 can come only from a problem in the 3.06.00.001 update --- installer/data/mysql/updatedatabase.pl | 7 +++++++ kohaversion.pl | 2 +- 2 files changed, 8 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index efa9898..9ae0060 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4564,6 +4564,13 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.06.00.002"; +if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { + $dbh->do("UPDATE borrowers SET debarred=NULL WHERE debarred='0000-00-00';"); + print "Setting NULL to debarred where 0000-00-00 is stored (bug 7272)"; + SetVersion($DBversion); +} + =head1 FUNCTIONS diff --git a/kohaversion.pl b/kohaversion.pl index 61ff87f..7f2be15 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -16,7 +16,7 @@ the kohaversion is divided in 4 parts : use strict; sub kohaversion { - our $VERSION = '3.06.00.001'; + our $VERSION = '3.06.00.002'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 1.7.5.4