Hi, the DELETE command will fix the data, but not prevent the issue from happening again. As this is not a problem with Koha, but with MySQL/MariaDB, updating to a newer Koha version won't fix the issue.
See the wiki for more information and a possible fix to prevent the problem from reappearing when your database server is restarted: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Hope this helps, Katrin On 30.06.19 05:27, Shivendra wrote:
Hi Friends, recently I set up koha 18.05 versions on Ubuntu 18.04 and migrated data from local software after doing necessary marc editing. Everything worked well, however while checking for missing barcodes, I came across a good number of duplicate barcode, which I later deleted using batch item deletion module. In between I also edited lots of data having both minor and major corrections. Simultaneously I created patrons and checked for book check-in and check-outs and to my surprise, I was able to check-out books, but was not able to check-in. while looking for the reasons, the problem emerged of auto- increment with an exact error “The following ids exist in both tables issues and old_issues:”. While looking for solution, I came across “DELETE FROM old_issues WHERE issue_id IN (1, 2);” command and applied it after making necessary changes in numbers as per system information. This solution worked and I was once again able to check-in and check-out. But, the moment I restarted machine, the problem reoccurred and am still wondering for solution. Of late, I upgraded my machine to koha 19.05, but the problem still persists. I shall feel grateful, should you help me to fix this auto increment problem and do share the reasons, as what actuated this problem . Thanking you. Shivendra Singh Assistant Librarian BFUHS, Faridkot, Punjab 151203 India _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
