View | Details | Raw Unified | Return to bug 24741
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-3 / +1 lines)
Lines 20668-20677 if( CheckVersion( $DBversion ) ) { Link Here
20668
            WHERE id NOT IN (
20668
            WHERE id NOT IN (
20669
                SELECT MIN(id)
20669
                SELECT MIN(id)
20670
                FROM ( SELECT * FROM library_groups ) AS lg
20670
                FROM ( SELECT * FROM library_groups ) AS lg
20671
                WHERE parent_id IS NOT NULL
20672
                GROUP BY parent_id, branchcode
20671
                GROUP BY parent_id, branchcode
20673
            )
20672
            )
20674
            AND parent_id IS NOT NULL;
20673
            AND NOT(parent_id IS NULL OR branchcode IS NULL);
20675
        |);
20674
        |);
20676
        $dbh->do(q|
20675
        $dbh->do(q|
20677
            ALTER TABLE library_groups
20676
            ALTER TABLE library_groups
20678
- 

Return to bug 24741