Unable to update to JEvents 3.6.76: «Index column size too large»
By crimle on Saturday, 09 December 2023
Posted in JEvents (Free Access)
Replies 4
Likes 0
Views 449
Votes 0
I am unable to update JEvents 3.6.75 to JEvents 3.6.76. The error message is
«Index column size too large. The maximum column size is 767 bytes»
This seems to be related to the database, I guess. But I have no idea how to resolve.
Thank you and kind regards
Chris
This should have been resolved in JEvents 3.6.76 - can you enable Joomla debug mode to see if you can get more information about where this issue arises?
geraint
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
I set «Error reporting» to «Maximum» and «Debug System» to «Yes». This is the result:
Jevents-Update.png


The debug console is larger than the screenshot is displaying. I do not know, which information you are looking for.

Thank you and kind regards
Chris
crimle
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
I see the problem your server is configured with a maximum index size of 767 bytes

This is highly restricted for a multi-byte database storage - where each character is represeted by 4 bytes

Can you try this build?
geraint
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi

Great this works :-)

Thank you very much and kind regards
Chris
crimle
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post