http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963
--- Comment #10 from Jared Camins-Esakov <jcam...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/