[Koha] record won't delete

[Katrin Fischer]

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