DBMS_auto_increment : cannot check-in items checked out before a certain upgrade
Hi, I am running Koha 17.05.05.000 on Ubuntu 14.04.1 with mysql Ver 14.14 Distrib 5.5.58. I regularly upgrade Koha via apt-get, and I've suddenly realized I cannot check-in items which had been checked-out (presumably before a certain upgrade). I can check-in items which have been checked-out with the presently installed release of Koha. Following the error message, I came across the wiki page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix I followed the instructions given there, and added the additional init file as described there. No error reported by /var/log/mysql/error.log upon restarting or running the mysql service. However, I cannot yet check-in back items which were checked-out in the past. (I can still do that with new check-outs.) Since it seems that the problem is solved with new check-outs, would you recommend that I manually remove old check-outs from the database, and issue them again (with a new date - doesn't matter, as long as it works)? Many thanks and best regards, Giuseppe.
Hello Giuseppe, Yes. I recently came across this and you can check my post here: http://koha.1045719.n5.nabble.com/Salvaging-data-before-using-DBMS-auto-incr... Have a good one, Pedro Amorim On 29 October 2017 at 03:37, Giuseppe Angilella < Giuseppe.Angilella@ct.infn.it> wrote:
Hi,
I am running Koha 17.05.05.000 on Ubuntu 14.04.1 with mysql Ver 14.14 Distrib 5.5.58.
I regularly upgrade Koha via apt-get, and I've suddenly realized I cannot check-in items which had been checked-out (presumably before a certain upgrade).
I can check-in items which have been checked-out with the presently installed release of Koha.
Following the error message, I came across the wiki page:
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
I followed the instructions given there, and added the additional init file as described there. No error reported by /var/log/mysql/error.log upon restarting or running the mysql service.
However, I cannot yet check-in back items which were checked-out in the past. (I can still do that with new check-outs.)
Since it seems that the problem is solved with new check-outs, would you recommend that I manually remove old check-outs from the database, and issue them again (with a new date - doesn't matter, as long as it works)?
Many thanks and best regards,
Giuseppe. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
You see the "About Koha>system information" page and remove all duplicate key/record from oldissues table etc. if it displayed you some error With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi* On Sun, Oct 29, 2017 at 10:07 AM, Giuseppe Angilella < Giuseppe.Angilella@ct.infn.it> wrote:
Hi,
I am running Koha 17.05.05.000 on Ubuntu 14.04.1 with mysql Ver 14.14 Distrib 5.5.58.
I regularly upgrade Koha via apt-get, and I've suddenly realized I cannot check-in items which had been checked-out (presumably before a certain upgrade).
I can check-in items which have been checked-out with the presently installed release of Koha.
Following the error message, I came across the wiki page:
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
I followed the instructions given there, and added the additional init file as described there. No error reported by /var/log/mysql/error.log upon restarting or running the mysql service.
However, I cannot yet check-in back items which were checked-out in the past. (I can still do that with new check-outs.)
Since it seems that the problem is solved with new check-outs, would you recommend that I manually remove old check-outs from the database, and issue them again (with a new date - doesn't matter, as long as it works)?
Many thanks and best regards,
Giuseppe. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Giuseppe Angilella -
Pedro Amorim -
vinod mishra