circulation history data lost
Hi! I'm still very new in the koha universe... Recently we've found that when checking in a book, the data that should go from table issues to old_issues is missing. I can borrow an item to anyone, but when it's returned it disappears. We have already around 2 days of records lost, and im still unabled to find or even track a solution. Could someone help please?? Thanks!! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi, can you tell us which version of Koha you are using? Are there any warnings on the About page / System information tab? Are you able to access the logs on your server and could take a look at them to check for any errors when an item is returned? Katrin On 04.10.19 19:34, mauroluri wrote:
Hi! I'm still very new in the koha universe... Recently we've found that when checking in a book, the data that should go from table issues to old_issues is missing. I can borrow an item to anyone, but when it's returned it disappears. We have already around 2 days of records lost, and im still unabled to find or even track a solution. Could someone help please?? Thanks!!
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Katrin! I'm really sorry for not answering earlier, i was VERY bussy with this and other events we had here... At that time i managed to figure what happened and solve it because i didn't lost all that data, BUT now it's happening again... The thing it's with duplicates of issue_id in tables issues and old_issues... I cant figure since then why the id from issues makes a little rollback on it's value resulting in duplicates and (of course, when returning a borrow) data loss... Answering your questions: - koha version: 16.05.04.000 - there're no warnings there - intranet-error.log confirmed (after i found the logs) that were id duplicates I shall say that i can't update koha version now because the one that was before me made some changes for the people here and he didn't document anything... and as far as now I couldnt establish all of them in order for an update, so its out of cuestion to me right now :/ So my need now becomes how could i solve this duplicates for bad increment/rollback of the issues_id Again, thanks and sorry for the time!! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi Mauro
The thing it's with duplicates of issue_id in tables issues and old_issues... I cant figure since then why the id from issues makes a little rollback on it's value resulting in duplicates and (of course, when returning a borrow) data loss...
Answering your questions: - koha version: 16.05.04.000 - there're no warnings there - intranet-error.log confirmed (after i found the logs) that were id duplicates
I shall say that i can't update koha version now because the one that was before me made some changes for the people here and he didn't document anything... and as far as now I couldnt establish all of them in order for an update, so its out of cuestion to me right now :/
So my need now becomes how could i solve this duplicates for bad increment/rollback of the issues_id
Maybe the following information will help you: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Best wishes: micahel -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Thank you very much for this explanation (link) I hope it solves this, so i may try it now The good thing of this method is that i can manually update some ids to not lose those duplicated records :D (Already tested with at least 1) Thx Michael!! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
participants (3)
-
Katrin Fischer -
mauroluri -
Michael Kuhn