http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1546 Summary: REPLACE statements Product: Koha Version: HEAD Platform: PC OS/Version: All Status: NEW Severity: blocker Priority: P1 Component: Database AssignedTo: chris.cormack@liblime.com ReportedBy: paul.poulain@free.fr QAContact: koha-bugs@nongnu.org There are REPLACE statements that MUST be removed, for 2 reasons (the 2nd one being a BLOcking, undoubtfully) - it's not SQL92 - it act as a delete/insert. thus, if you have foreign keys, it delete all the children !!! IPT just tried to modify authority description, and ... the authority framework is gone ! that's just because of the REPLACE. I've already fixed authority & catalogue framework definition, that have the problem, patch on the way. There are some other places using REPLACE, we must at least check that FK are not concerned by them ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.