[SOLVED] Install Error - Specified Key was too long

1 year 8 months ago - 1 year 8 months ago #330418 by mredmond13
I am running a Joomla 4 (latest update was today), with PhP 8.1 and MySQL 5.6.
I use GoDaddy to host my site.
I have tried installing the CB package from a downloaded package  and via the web.
In both instances I get the following error:
 

In January 2022, a similar post indicated that this could a problems with InnoDB, but I have no idea how to check this.
Any help on getting this installed? Thanks in advance.
Attachments:

Please Log in to join the conversation.

1 year 8 months ago #330422 by krileon
Replied by krileon on topic Install Error - Specified Key was too long
Contact your host. Their default InnoDB settings are incorrect. Typically only way they can fix that is moving you to a newer server with database properly configured already unless they allow individual database configuration, which I doubt.

I also do not recommend using GoDaddy for hosting. There are significiantly higher quality hosts available like SiteGround, DigitalOcean, our own hosting , and even Joomla offers hosting via ScalaHosting.

Will also review adding more length limits to database indexes which might also fix this for you even for incorrectly configured databases.


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.
The following user(s) said Thank You: mredmond13

Please Log in to join the conversation.

1 year 8 months ago #330423 by krileon
Replied by krileon on topic Install Error - Specified Key was too long
A new release is now available that you can try. It might still not fix your issue as the 767 byte limit is very limiting and it won't guarantee you won't have issues in the future.


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 to join the conversation.

1 year 8 months ago #330454 by mredmond13
Replied by mredmond13 on topic Install Error - Specified Key was too long
You were correct. I moved the site to another host and CB loaded without any issues.
Thanks for your help.
The following user(s) said Thank You: krileon

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.252 seconds

Facebook Twitter LinkedIn