Answers.Body: <p>Run below command before running the upgrade</p>
  <pre><code>ALTER TABLE civicrm_group ROW_FORMAT=DYNAMIC;
  </code></pre>
  <p>Include the below config in mysql config file</p>
  <pre><code>innodb_large_prefix=true 
  innodb_file_format=barracuda 
  innodb_file_per_table=true
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-05-10T09:49:30.353Z
Answers.LastActivityDate: 2021-05-10T09:49:30.353Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>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.</p>
  <p>[Error: Expand internal civicrm group title field to be 255 in length]</p>
  <p>Error Field Error Value</p>
  <p>Type    DB_Error</p>
  <p>Code    -1</p>
  <p>Message DB Error: unknown error</p>
  <p>Mode    16</p>
  <p>UserInfo    ALTER TABLE civicrm_group CHANGE <code>title</code> <code>title</code> varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]</p>
  <p>DebugInfo   ALTER TABLE civicrm_group CHANGE <code>title</code> <code>title</code> varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]</p>
  <p>Here is the screenshot:</p>
  <p><a href="https://i.sstatic.net/xMjEp.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/xMjEp.png" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-10T09:44:28.520Z
Comments.Text: 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.
Comments.UserDisplayName: Anton
Tags: <database>
Title: Upgrade to version 5.37 - Database error
ThreadText: # Upgrade to version 5.37 - Database error
  
  (Asked by: username_0 on 2021-05-10)
  
  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](https://i.sstatic.net/xMjEp.png)](https://i.sstatic.net/xMjEp.png)
  
  **Tags:** database
  
  > **Comments:**
  > **username_0**: 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.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-05-10. Score: 0
  
  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
  
  
  ---
  
  