From 65024825c5b1effbbc780a47b8e96f90c8d04250 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Fri, 31 Jan 2020 11:37:55 +0000
Subject: [PATCH] Bug 21674: (RM follow-up) Fix updatedatabase error

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 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 0468db0f71..65c9b18f6c 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -20667,7 +20667,7 @@ if( CheckVersion( $DBversion ) ) {
             DELETE FROM library_groups
             WHERE id NOT IN (
                 SELECT MIN(id)
-                FROM library_groups
+                FROM ( SELECT * FROM library_groups ) AS lg
                 WHERE parent_id IS NOT NULL
                 GROUP BY parent_id, branchcode
             )
-- 
2.39.5