Categories
Categories:   All Categories
Suggested keywords
x
New
 Technical

Unable to update to JEvents 3.6.76: «Index column size too large»

JEvents (Free Access)
  JEvents (Free Access)
crimle
  crimle
  Saturday, 09 December 2023
  4 Replies
  874 Visits
0
Votes
Undo
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
Oldest First  
crimle set the post as Normal priority — 2 years ago
crimle set the type of the post as  Technical — 2 years ago
geraint
geraint
Monday, 11 December 2023 15:52
·
#233363
0
Votes
Undo
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?
crimle
crimle
Monday, 11 December 2023 16:36
·
#233371
0
Votes
Undo
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
geraint
geraint
Tuesday, 12 December 2023 12:41
·
#233397
0
Votes
Undo
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?
crimle
crimle
Tuesday, 12 December 2023 15:31
·
#233409
0
Votes
Undo
Hi

Great this works :-)

Thank you very much and kind regards
Chris
  • Page :
  • 1
There are no replies made for this post yet.