[Koha-bugs] [Bug 7493] Deleting a record with comments breaks "Recent Comments"

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7493

Julian Maurice <julian.maurice at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |julian.maurice at biblibre.com

--- Comment #4 from Julian Maurice <julian.maurice at biblibre.com> 2012-02-23 10:26:37 UTC ---
I don't know when or how it happened but I had in database 1 line in biblio and
1 line in deletedbiblio with the same biblionumber, which cause comments on
this biblio to be deleted.
I'm sure this is not a common case, and it should not happen, but I would
prefer that deletions are done with an SQL query like this

DELETE FROM reviews WHERE biblionumber **NOT** IN (SELECT biblionumber from
**biblio**);
(same for patrons)

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.