[Koha] record won't delete

[Lauren Denny]

Hi Jonathan,

Thanks for the SQL.  We ran the report and got 6 biblionumbers including
the one we tried to delete.  I'm not sure what is wrong or how to fix
these.  Could you elaborate on what needs to be corrected.

Thanks,
Lauren

On Tue, Jul 4, 2023 at 5:37 AM Jonathan Druart <
jonathan.druart at bugs.koha-community.org> wrote:

> Apparently the about page is not displaying the warning if the problem
> is on the [deleted]biblioitems table.
> You can catch the incorrect entries with the following SQL query:
>   select b.biblionumber from biblioitems b join deletedbiblioitems db
> on b.biblionumber=db.biblionumber;
>
> Le sam. 1 juil. 2023 à 10:49, David Liddle <david at liddles.net> a écrit :
> >
> > Hi Katrin, and thank you for the input and suggestion. Our system shows
> no
> > warnings, however. Not being on the cataloging side of things, I can’t
> > provide much more detail about the context of the items to be deleted.
> >
> > Regards from the Siegerland,
> >
> > David
> >
> >
> > On Fri, Jun 30, 2023 at 8:13 PM Katrin Fischer <katrin.fischer.83 at web.de
> >
> > wrote:
> >
> > > Hi David,
> > >
> > > please check the About Koha > System information tab for any errors.
> > >
> > > I suspect you might see a warning about duplicated IDs. If that is the
> > > case, you can find some more information in the wiki:
> > >
> > > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
> > >
> > > Hope this helps,
> > >
> > > Katrin
> > >
> > >
> > > On 28.06.23 15:39, David Liddle wrote:
> > > > Greetings all! To add a little more detail to this issue, I'll
> include
> > > > that the server logs contain several instances of the following
> error:
> > > >
> > > >
> > >
> /var/log/koha/library/worker-output.log.1:C4::Biblio::_koha_delete_biblioitems():
> > > > DBI Exception: DBD::mysql::st execute failed: Duplicate entry '11857'
> > > > for key 'PRIMARY' at /usr/share/koha/lib/C4/Biblio.pm line 535
> > > >
> > > > Surely that biblio entry is the blocking element, but we're uncertain
> > > > about how it should be handled so that the deletion proceeds
> > > > smoothly—and without harming related entries. Thank you for giving it
> > > > your attention!
> > > >
> > > > David Liddle
> > > > System Administrator
> > > > david.liddle at wycliff.de (just not for this list)
> > > >
> > > > Wycliff e.V., https://wycliff.de
> > > > Seminar für Sprache und Kultur, https://spracheundkultur.org
> > > > Internationales Tagungszentrum Karimu, https://karimu.de
> > > >
> > > >
> > > >
> > > > On Fri, Jun 23, 2023 at 11:26 PM Lauren Denny <lauren_denny at sil.org>
> > > wrote:
> > > >> Hi everyone,
> > > >>
> > > >> I have a record that will not delete. When I try to delete the
> record or
> > > >> merge it with another record I get this message:
> > > >> An error has occurred!*Error 500*This message may have been caused
> by
> > > any
> > > >> of the following reasons:
> > > >>
> > > >>     - You made use of an external link to an item that is no longer
> > > available
> > > >>     - You followed an outdated link e.g. from a search engine or a
> > > bookmark
> > > >>     - You tried to access a page that needs authentication
> > > >>     - An internal link in the client is broken and the page does not
> > > exist
> > > >>
> > > >> What's next?
> > > >>
> > > >>     - Use top menu bar to navigate to another part of Koha.
> > > >>     - To report a broken link or any other issue, please contact the
> > > Koha
> > > >>     administrator. Send email <library%40teamwork-global.net>
> > > >>
> > > >> Does anyone have an idea of what is happening?
> > > >>
> > > >> Lauren
> > > >> _______________________________________________
> > > >>
> > > >> Koha mailing list  http://koha-community.org
> > > >> Koha at lists.katipo.co.nz
> > > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > > > _______________________________________________
> > > >
> > > > Koha mailing list  http://koha-community.org
> > > > Koha at lists.katipo.co.nz
> > > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > > _______________________________________________
> > >
> > > Koha mailing list  http://koha-community.org
> > > Koha at lists.katipo.co.nz
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > >
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>