From 1bfff06e9dfd9215f30ed0aea46f58643f2b4e9e Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 31 Jan 2020 11:37:55 +0000 Subject: [PATCH] Bug 21674: (RM follow-up) Fix updatedatabase error --- 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.20.1