[Koha] record won't delete

[Jonathan Druart]

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