Hi Lauren, did you have a look at the wiki page? https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
Le mer. 5 juil. 2023 à 20:50, Lauren Denny <lauren_de...@sil.org> a écrit : > > 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.dru...@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 <da...@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...@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.lid...@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_de...@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@lists.katipo.co.nz >> > > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > _______________________________________________ >> > > > >> > > > Koha mailing list http://koha-community.org >> > > > Koha@lists.katipo.co.nz >> > > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > > _______________________________________________ >> > > >> > > Koha mailing list http://koha-community.org >> > > Koha@lists.katipo.co.nz >> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > > >> > _______________________________________________ >> > >> > Koha mailing list http://koha-community.org >> > Koha@lists.katipo.co.nz >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
