[Koha-bugs] [Bug 21674] Data integrity not enforced for library groups

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21674

Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |additional_work_needed

--- Comment #19 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
I'm getting a wierd DB error on this one: 

DBD::mysql::db do failed: Table 'library_groups' is specified twice, both as a
target for 'DELETE' and as a separate source for data [for Statement "
            DELETE FROM library_groups
            WHERE id NOT IN (
                SELECT MIN(id)
                FROM library_groups
                WHERE parent_id IS NOT NULL
                GROUP BY parent_id, branchcode
            )
            AND parent_id IS NOT NULL;
        "] at ./installer/data/mysql/updatedatabase.pl line 20666.

-- 
You are receiving this mail because:
You are watching all bug changes.