
Next day, next bug with 20220508.1 and 20220509.1 (General)
Hello
I was informed in a new Github issue (#601) about a bug in the collection of database queries for the installation. This is especially annoying because I tested the fresh installation with both versions 20220508.1 and 20220509.1 and my installation attempts was successful.
I found the cause and prbt2016, who opened the issue, stated, that the fix solved the bug. But, it revealed another bug, that only occures with MySQL-versions up to 5.6.x. I myself run my installations with MySQL 5.7 and could not imagine to run into such a problem.
When we introduced the support of utf8mb4
we ourself came across the problem, that a column, defined as varchar(255)
that was indexed, exceeded the maximal possible size of an index. Because of that we resized the user name of a registered user from 255 Bytes to 128 Bytes. One of the later changes was to change the definition of most of the database tables to use the charset utf8mb4
, what makes all text columns using utf8mb4, if not defined otherwise. We also added an index for the column user_email
that has a size of 255 Bytes. You see, where this will end?
Well, IMHO we can not half size of the column for the e-mail-addresses to 128 Bytes. E-mail-addresses can be longer than that. Because of that I decided to test another solution, that defines the column user_email
as charset utf8
without mb4
and because of that with no chance to exceed the maximal index size. I was only able to thest this scenario with a MySQL-server of version 5.7 in a 5.5-compatibility mode. I was able to install the forum with the new definition. On the other hand I can not say anything about the result of a installation attempt on a real MySQL-5.5-server.
I added a PR (#602) with my changes contemporary and would be thankful if someone is able to test the fresh installation of MLF in version 20220509.1 on a server, that is connected to an instance of MySQL 5.5.x (x >= 3) or MySQL 5.6.x.
Thank you, tschö, Auge
--
Trenne niemals Müll, denn er hat nur eine Silbe!
Complete thread:
- Release thread for version branch 2.5 -
Auge,
2019-06-01, 21:10
- Release of version 2.4.99.1, testing release -
Auge,
2019-06-01, 21:57
- Version 2.4.99.1, updatable but not installable - Auge, 2019-06-04, 11:15
- Release of version 2.4.99.3, testing release, with EDIT -
Auge,
2019-09-24, 20:29
- Release of version 2.4.99.3, testing release -
Micha,
2019-09-25, 08:50
- Release notes for 2.4.99.2 amended - Auge, 2019-09-25, 10:46
- Release of version 2.4.99.3, testing release -
Micha,
2019-09-25, 08:50
- First release in the version branch 2.5, 20220508.1 🚀 -
Auge,
2022-05-08, 20:16
- A few hints about the upgrade of this forum to 20220508.1 - Auge, 2022-05-09, 10:01
- There is a little but breaking bug in version 20220508.1 😒 - Auge, 2022-05-09, 13:00
- Release of version 20220509.1 - Auge, 2022-05-09, 19:37
- Next day, next bug with 20220508.1 and 20220509.1 - Auge, 2022-05-10, 17:04
- Short insight into the spam filtering with the new B8-filter -
Auge,
2022-05-13, 11:42
- Short insight into the spam filtering with the new B8-filter -
Micha,
2022-05-13, 11:47
- Short insight into the spam filtering with the new B8-filter -
Auge,
2022-05-13, 13:42
- Short insight into the spam filtering with the new B8-filter -
Micha,
2022-05-14, 07:40
- Short insight into the spam filtering with the new B8-filter - Auge, 2022-05-15, 11:15
- Short insight into the spam filtering with the new B8-filter -
Micha,
2022-05-14, 07:40
- Short insight into the spam filtering with the new B8-filter -
Auge,
2022-05-13, 13:42
- Short insight into the spam filtering with the new B8-filter -
Micha,
2022-05-13, 11:47
- Release of version 20220517.1 - Auge, 2022-05-17, 20:22
- Release of version 2.4.99.1, testing release -
Auge,
2019-06-01, 21:57