@@ -, +, @@ 19.12.00.017 commit 715da06db557edc4b1baa51cc278fdac362c01c4 Bug 22868: DBRev 19.12.00.016 --- installer/data/mysql/updatedatabase.pl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -20668,10 +20668,9 @@ if( CheckVersion( $DBversion ) ) { WHERE id NOT IN ( SELECT MIN(id) FROM ( SELECT * FROM library_groups ) AS lg - WHERE parent_id IS NOT NULL GROUP BY parent_id, branchcode ) - AND parent_id IS NOT NULL; + AND NOT(parent_id IS NULL OR branchcode IS NULL); |); $dbh->do(q| ALTER TABLE library_groups --