« 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 > > 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 [inlinecode]user_mail[/inlinecode]. The column has a size of 256 characters. With setting the charset to [inlinecode]utf8mb4[/inlinecode] 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 [inlinecode]utf8mb4[/inlinecode] back to [inlinecode]utf8[/inlinecode]. It seems, that we handled the order of changes in a wrong way. > > [b][edit][/b]You can find [link=https://mylittleforum.net/forum/index.php?id=12736]further information about the issue in this entry[/link].[b][/edit][/b] > > > 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 [inlinecode]mlf2_userdata.user_mail[/inlinecode] explicitely to [inlinecode]utf8[/inlinecode] and retry the upgrade. > > Tschö, Auge
E-mail notification on reply of this posting
OK - Submit
Preview