Avatar

Error while upgrading to version 20220529.1 (General)

by Auge ⌂, Thursday, June 30, 2022, 10:27 (658 days ago) @ ST68k

Hello

Thank you for the report.

Unfortunatelly the update does'nt work for me.
When i launch the update php script i have this error :

Database error in line 435: specified key was too long; max key length is 767 bytes

It seems that the email field is limited but it is the script that set it to utf8 format.

There was an issue with the data format of the column user_mail. The column has a size of 256 characters. With setting the charset to utf8mb4 for the database table the maximal length of indexes gets exceeded in older MySQL versions. We worked around this by setting the charset especially for this one column from utf8mb4 back to utf8. It seems, that we handled the order of changes in a wrong way.

[edit]You can find further information about the issue in this entry.[/edit]

Any idea to help me to solve this?

I'll take a look into it. If you are a brave one, you can backup your database tables, change the charset of the column mlf2_userdata.user_mail explicitely to utf8 and retry the upgrade.

Tschö, Auge

--
Trenne niemals Müll, denn er hat nur eine Silbe!


Complete thread:

 RSS Feed of thread