From b6751749a68c3d7dfc31259ea4fe2e0b7a13df2a Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Thu, 22 Mar 2012 16:55:56 +0100 Subject: [PATCH] Bug 7310 follow-up : typo fix lt instead of < in DB version comparison --- 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 ec08012170..246ecf7ef3 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4968,7 +4968,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { } $DBversion = "3.07.00.032"; -if ( C4::Context->preference("Version") lt TransformToNum($DBversion) ) { +if ( C4::Context->preference("Version") < 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 $dbh->do("DELETE FROM virtualshelves WHERE owner IS NULL and category=1"); #delete private lists without owner (cascades to shelfcontents) -- 2.39.2