From b86b5a29799493014d475e181802861738df7ec4 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Thu, 22 Mar 2012 05:00:11 +0100 Subject: [PATCH] bug 7310 follow-up DBVersion was wrong Thanks Ian for pointing that the DBVersion defined for 7310 was wrong : I missed it had a 99 that should have been a 00 --- installer/data/mysql/updatedatabase.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 1c8be0ffb2..32099d8ba8 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4967,7 +4967,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } -$DBversion = "3.07.99.032"; +$DBversion = "3.07.00.032"; if ( C4::Context->preference("Version") lt TransformToNum($DBversion) ) { $dbh->do("ALTER TABLE virtualshelves MODIFY COLUMN owner int"); #should have been int already (fk to borrowers) $dbh->do("UPDATE virtualshelves vi LEFT JOIN borrowers bo ON bo.borrowernumber=vi.owner SET vi.owner=NULL where bo.borrowernumber IS NULL"); #before adding the constraint on borrowernumber, we need to get rid of deleted owners -- 2.39.5