DBMS_auto_increment : cannot check-in items checked out before a certain upgrade

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

DBMS_auto_increment : cannot check-in items checked out before a certain upgrade

Giuseppe Angilella
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
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: DBMS_auto_increment : cannot check-in items checked out before a certain upgrade

Pedro Amorim
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-increment-fix-td5951803.html

Have a good one,

Pedro Amorim

On 29 October 2017 at 03:37, Giuseppe Angilella <
[hidden email]> 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
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: DBMS_auto_increment : cannot check-in items checked out before a certain upgrade

vinod mishra
In reply to this post by Giuseppe Angilella
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 <
[hidden email]> 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
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha