[Koha] Error in Koha 22.05?

[Katrin Fischer]

Hi Eberhard,

I am not sure if the problem would be visible in the data.

Maybe some ideas what to try instead:

* Can you reset the password of your user? This would require the
password recovery feature to be enabled.

* Can you log in with a new superlibrarian account created from command
line?
(http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.html)

* What is the message shown when you try to log in? Is there anything
visible in the logs when the login fails?

Hope this helps,

Katrin

On 05.07.22 14:19, Dr. Eberhard Pietzsch 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