Skip to Content Skip to Menu

[SOLVED] Specified key was too long

  • ASconbs
  • ASconbs
  • OFFLINE
  • Posts: 9
  • Thanks: 4
  • Karma: 0
3 years 6 days ago - 3 years 5 days ago #327736 by ASconbs
[SOLVED] Specified key was too long was created by ASconbs
I have downloaded the pkg_communitybuilder_2.6.4 build.2021.12.15.15.17.31.154cf3865.zip and tried to install.

Unfortunately I got this error:42000, 1071, Specified key was too long; max key length is 767 bytes

I run Joomla Joomla 4.0.5php 8.0.4Mysql 5.6.47-logI was advised to try to change the sql collation to utf8mb4_general_ci

I tried this, but this just caused "Specified key was too long" error in the mysql, but now for the Akeeba installation. I tried to ignore that error and save the utf8mb4_general_ci config, but still couldn't install the CB pkg file.

What to do ?

BR
Anton
Last edit: 3 years 5 days ago by krileon. Reason: Added [SOLVED] tag to subject

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48671
  • Thanks: 8312
  • Karma: 1446
3 years 6 days ago #327742 by krileon
Replied by krileon on topic Specified key was too long
That's typically due to Innodb not being configured correctly. The default max key length should be 3072 not 767. Suggest contacting your host and ensuring they've setup Innodb correctly.

Is there any further information with there? Like what key it's trying to create? If not enable debug mode and maximum error reporting in Joomla global configuration then retry and see if provides the full query that's failing in the error.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • ASconbs
  • ASconbs
  • OFFLINE
  • Posts: 9
  • Thanks: 4
  • Karma: 0
3 years 5 days ago #327764 by ASconbs
Replied by ASconbs on topic Specified key was too long
Hi again
I asked them about the max key length. They then adviced me to choose a new database at their hosting.
Now I have moved my webpage to the new database, and I was then able to perform the installation of the ComunityBullder pkg.
This issue is now solved for me.
Thank you.
BR
AScon
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum