http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963
--- Comment #9 from Paul Poulain <[email protected]> --- (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 ... -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
