Hi Eberhard, I'm interested to see your borrowers table, too. Can you try to resend the dump file (or copy and paste a few rows into the message thread)? The attachment didn't come through. -Evan Stewart On Tue, Jul 5, 2022 at 6:20 AM Dr. Eberhard Pietzsch <eberhard@pietzsch.org> wrote:
Attached you see an dump of the borrowers table. You can see at the insert statement that the contents are shifted by a few bytes. Some attributes are new compared with earliver versions of Koha.
(I have edited the encrypted password)
Eberhard
Katrin Fischer <katrin.fischer.83@web.de> hat am 05.07.2022 12:33 CEST geschrieben:
Hi,
could you please post more information about the issue? What error message are you seeing? Can you access the tables with SQL?
Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row size too large.
Then have a look at: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1
Hope this helps,
Katrin
On 05.07.22 12:21, Fernando A. Martinez wrote:
Hi,
I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29
Regards
Fernando A. Martinez
On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://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