[Koha-bugs] [Bug 1963] Problem with deleted biblio in a virtual shelf

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Oct 16 18:29:16 CEST 2012


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

--- Comment #10 from Jared Camins-Esakov <jcamins at 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.


More information about the Koha-bugs mailing list