« Project home page
my little forum
Log in
Register
Search:
Back to the entry by Auge
Post reply
Reply to the message by
Auge
Name:
E-mail:
(optional, won't be displayed directly)
Leave this field empty:
Homepage:
(optional)
Leave this field empty:
Location:
(optional)
Remember me (cookie)
Category:
General
Project organisation
Technics
Design/Themes
Features
Development
Todo
Bugs
German / Deutsch
Spanish / Español
French / Français
Accessibility/UX
Subject:
Formatting help
skip to input
format text bold
[b]bold text[/b]
format text italic
[i]italic text[/i]
insert hyperlink
[link=http://example.com/]link text[/link] / [link]http://example.com/[/link]
set text color
[color=#rgb]colored text[/color]
font size
[size=small]small text[/size]
[size=large]large text[/size]
insert list
[list][*]list item[/list]
insert image
[img]http://example.com/image.jpg[/img]
left: [img=left]http://example.com/image.jpg[/img]
right: [img=right]http://example.com/image.jpg[/img]
thumbnail: [img=thumbnail]http://example.com/image.jpg[/img]
thumbnail left: [img=thumbnail-left]http://example.com/image.jpg[/img]
thumbnail right: [img=thumbnail-right]http://example.com/image.jpg[/img]
upload image
upload image ...
insert TeX code
[tex]TeX code[/tex]
insert code
[inlinecode]code[/inlinecode]
[code]code[/code]
[code=css]code[/code]
[code=html]code[/code]
[code=javascript]code[/code]
[code=perl]code[/code]
[code=php]code[/code]
[code=sql]code[/code]
[code=xml]code[/code]
:-)
;-)
:-P
:-D
:-|
:-(
:yes:
:no:
:ok:
:lol:
:lol2:
:lol3:
:cool:
:surprised:
:angry:
:crying:
:waving:
:confused:
:lookaround:
:clap:
:love:
:tick:
Message:
> Hello > > I was informed in [link=https://github.com/ilosuna/mylittleforum/issues/601]a new Github issue (#601)[/link] 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 [inlinecode]utf8mb4[/inlinecode] we ourself came across the problem, that a column, defined as [inlinecode]varchar(255)[/inlinecode] 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 [inlinecode]utf8mb4[/inlinecode], what makes all text columns using utf8mb4, if not defined otherwise. We also added an index for the column [inlinecode]user_email[/inlinecode] 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 [inlinecode]user_email[/inlinecode] as charset [inlinecode]utf8[/inlinecode] without [inlinecode]mb4[/inlinecode] 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 [i]real[/i] MySQL-5.5-server. > > [link=https://github.com/ilosuna/mylittleforum/pull/602]I added a PR (#602)[/link] 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
E-mail notification on reply of this posting
OK - Submit
Preview