From 2369b7d5f95d6549af4dc0ae05df750814d3b148 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 Signed-off-by: Jared Camins-Esakov --- installer/data/mysql/updatedatabase.pl | 7 +++++++ kohaversion.pl | 2 +- 2 files changed, 8 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index e705bb366e..bc3afeaaa3 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4660,6 +4660,13 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.06.04.005"; +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 e633ca868d..3caa211d99 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.04.004'; + our $VERSION = '3.06.04.005'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5