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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Bug 1963 depends on bug 8915, which changed state. Bug 8915 Summary: Referential integrity constraints and InnoDB vs MyISAM storage engine http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8915 What|Removed

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Owen Leonard changed: What|Removed |Added Status|Pushed to Master|RESOLVED Resolution|--

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Paul Poulain changed: What|Removed |Added Status|Passed QA |Pushed to Master Ve

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #12 from Kyle M Hall --- (In reply to comment #11) > I would favor pushing this patch, if we fix the constraint stuff on another > report (including some lines in updatedatabase to correct the historical > "ballast" from My

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 M. de Rooy changed: What|Removed |Added CC||m.de.r...@rijksmuseum.nl --- Com

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #10 from Jared Camins-Esakov --- (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 t

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #9 from Paul Poulain --- (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. T

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #8 from Jared Camins-Esakov --- (In reply to comment #7) > (In reply to comment #6) > > So, please, push this patch. The constraint issue is more general, and > > related to storage Engine used. InnoDB is now mandatory. Inn

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #7 from Paul Poulain --- (In reply to comment #6) > So, please, push this patch. The constraint issue is more general, and > related to storage Engine used. InnoDB is now mandatory. InnoDB is the > MySQL default storage eng

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Frédéric Demians changed: What|Removed |Added Depends on||8915 -- You are receiving

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #6 from Frédéric Demians --- Thanks a lot Paul for catching that! Yes, there should have a constraint on shelfcontents.biblionumber field. And there isn't one. For others who would like to test there table: SHOW CREATE

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #5 from Paul Poulain --- mmm... before pushing, I had a doubt and checked kohastructure. The constraint already exists. CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`)

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Paul Poulain changed: What|Removed |Added Status|Signed Off |Passed QA CC|

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Kyle M Hall changed: What|Removed |Added Status|Needs Signoff |Signed Off CC|

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Kyle M Hall changed: What|Removed |Added Attachment #12694|0 |1 is obsolete|

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Frédéric Demians changed: What|Removed |Added Assignee|gmcha...@gmail.com |frede...@tamil.fr -- You

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Frédéric Demians changed: What|Removed |Added Status|REOPENED|Needs Signoff -- You are

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 --- Comment #2 from Frédéric Demians --- Created attachment 12694 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12694&action=edit Bug 1963 Problem with deleted biblio in a virtual shelf This bug reappear in HEAD/3.8

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1963 Frédéric Demians changed: What|Removed |Added Status|RESOLVED|REOPENED C