[SOLVED] Upgrade to CB Activity 3.0.0 RC4

MAYASIMA
OFFLINE
Posts: 183
Thanks: 22
Karma: 5

9 years 3 months ago - 9 years 3 months ago #267264 by MAYASIMA

[SOLVED] Upgrade to CB Activity 3.0.0 RC4 was created by MAYASIMA

When I upgrade to the latest CB Activity I get the following error:

Code:

Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE `inlta_comprofiler_plugin_activity_locations` ( `id` int(11) unsigned NOT NULL auto_increment, `value` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT 0, `ordering` int(11) NOT NULL DEFAULT 99999, `params` text, PRIMARY KEY (`id`), UNIQUE KEY `value` (`value`) )AUTO_INCREMENT=500, ENGINE=InnoDB

Additionally the profile page for logged in users now shows a blank page with no error message.

I just upgraded to CB 2.0.10.

Help Please.

Last edit: 9 years 3 months ago by krileon.

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

MAYASIMA
OFFLINE
Posts: 183
Thanks: 22
Karma: 5

9 years 3 months ago #267288 by MAYASIMA

Replied by MAYASIMA on topic Upgrade to CB Activity 3.0.0 RC4

For now, I downgraded to CB Activity 3.0.0 RC3 and my site is working again.

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

davidmarshall15
OFFLINE
Posts: 68
Thanks: 6
Karma: 0

9 years 3 months ago - 9 years 3 months ago #267302 by davidmarshall15

Replied by davidmarshall15 on topic Upgrade to CB Activity 3.0.0 RC4

I had this problem and it was due to the database character set being utf8mb4_* (4 bytes per char)

The index UNIQUE KEY `value` is on a 255 char column, so 255x4 is greater than the max 767 bytes allowed by mysql.

To fix it, I changed the default character set to utf8_general_ci
I did this using pypMyAdmin and navigating to the database>operations tab.

Last edit: 9 years 3 months ago by davidmarshall15.

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

MAYASIMA
OFFLINE
Posts: 183
Thanks: 22
Karma: 5

9 years 3 months ago #267309 by MAYASIMA

Replied by MAYASIMA on topic Upgrade to CB Activity 3.0.0 RC4

That is not an option for me. I need full Unicode support and utf8_general_ci will create data loss and security issues.

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

krileon
ONLINE
Posts: 48477
Thanks: 8281
Karma: 1443

9 years 3 months ago #267333 by krileon

Replied by krileon on topic Upgrade to CB Activity 3.0.0 RC4

I've added a length limit to its index for stable release. You can manually fix by adding a unique index with a length of 30 to the value column of _comprofiler_plugin_activity_actions, _comprofiler_plugin_activity_locations, and _comprofiler_plugin_activity_emotes tables or wait for stable.

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.

MAYASIMA
OFFLINE
Posts: 183
Thanks: 22
Karma: 5

9 years 3 months ago #267386 by MAYASIMA

Replied by MAYASIMA on topic Upgrade to CB Activity 3.0.0 RC4

Sounds good, Thanks!

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

Moderators: beat, nant, krileon