http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #10 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- (In reply to comment #9)
(In reply to comment #8)
I disagree. Frédéric submitted a patch which fixes the constraint problem, but in the meantime, this is a good workaround for those libraries that have the problem. There is absolutely no reason why library patrons should have to deal with errors, ever.
Jared, it does not fix the constraint problem, it fixes the perl error. The proper way to fix the problem is to issue 3 SQL commands: 1- delete all wrong entries 2- switch to innodb 3- add the constraint
* DELETE FROM virtualshefcontent WHERE biblionumber NOT IN (SELECT biblio.biblionumber FROM biblio WHERE biblio.biblionumber=virtualshelfcontent.biblionumber) * ALTER TABLE virtualshelfcontent ENGINE=innodb * ALTER TABLE virtualshelfcontent ADD CONSTRAINT ...
Not this patch. Frédéric submitted a separate patch for updating the constraints. Bug 8915. However, that one requires a great deal of testing, I think. This patch will serve to keep patrons from being exposed to errors while we make sure there are no undesired side effects. -- You are receiving this mail because: You are watching all bug changes.