[Koha] Error in Koha 22.05?

[Evan Stewart]

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 at 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 at 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 at lists.katipo.co.nz
> > >> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> > > _______________________________________________
> > >
> > > Koha mailing list http://koha-community.org
> > > Koha at lists.katipo.co.nz
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>