1

I have avoided upgrading for quite a while, but went ahead finally. Here is the error received below, and am completely unsure where to go to edit the field length. Or is the solution to rollback and re-install my backup and resolve it from there.

[Error: Expand internal civicrm group title field to be 255 in length]

Error Field Error Value

Type DB_Error

Code -1

Message DB Error: unknown error

Mode 16

UserInfo ALTER TABLE civicrm_group CHANGE title title varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]

DebugInfo ALTER TABLE civicrm_group CHANGE title title varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]

Here is the screenshot:

enter image description here

Improve this question
1
  • I'm thinking that this error relates to this server still running MySQL version 5.6. It did come up as a warning during the upgrade, but not indicated as critical to go ahead. I'll see about upgrading to MySQL version 5.7 next and then try again.
    – Anton
    May 10, 2021 at 9:44

1 Answer 1

Reset to default
1

Run below command before running the upgrade

ALTER TABLE civicrm_group ROW_FORMAT=DYNAMIC;

Include the below config in mysql config file

innodb_large_prefix=true 
innodb_file_format=barracuda 
innodb_file_per_table=true
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.