Answers.Body: <p>I'm not sure if the issue is what Demerit is suggesting (join limits), or one of database length limits.  Your <a href="https://civicrm.stackexchange.com/q/15931/12">CiviCRM log</a> should give a more detailed error.  If you find the error, you can edit your question to include it for better help.</p>
  <p>I suspect you're hitting a database length limit.  The solution depends on your version of MySQL/MariaDB, but I'm guessing that <a href="https://stackoverflow.com/questions/51250156/how-to-apply-row-format-dynamic-to-an-existing-table">changing your database row format to DYNAMIC</a> may help.</p>
  <p>If you don't have the ability to change this (e.g. you're on a crappy shared host) then consider creating fields with a lower maximum length if you need to fit more - or breaking the custom fields up amongst two groups.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-03T20:31:42.640Z
Answers.Text: for non-technical, "breaking the custom fields up amongst two groups" is probably the 'least effort' option.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-03T16:21:15.177Z
Answers.LastActivityDate: 2021-08-03T16:21:15.177Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>See <a href="https://lab.civicrm.org/dev/core/-/issues/1191" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/-/issues/1191</a> and you can also try <a href="https://github.com/civicrm/civicrm-core/pull/18968" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/18968</a> to see if it solves it for you.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-03T13:09:47.427Z
Answers.LastActivityDate: 2021-08-03T13:09:47.427Z
Answers.UserDisplayName: Demerit
Body: <p>I am using Civi 5.38 on a WordPress site. There have been multiple custom data sets created and used for Activities which have all worked fine apart from the most recent set which needs 70+ fields adding to it. Once we get to adding 65 in the fields it seems to cause a database fault as the screen freezes when trying to add it. If I refresh the page the field then shows in the list but then none of the activities load on the homepage or show in the contact records.
  Is this a known limitation of custom fields on a set? When checking other forum posts there seems to be people creating upto 90 in a set so not sure what is causing this to fall over if that's the case.</p>
  <p>Thanks!</p>
  
Tags: <custom-fields><activities>
Title: Custom Data Set - Field Limit
ThreadText: # Custom Data Set - Field Limit
  
  (Asked by: username_0 on 2021-08-03)
  
  I am using Civi 5.38 on a WordPress site. There have been multiple custom data sets created and used for Activities which have all worked fine apart from the most recent set which needs 70+ fields adding to it. Once we get to adding 65 in the fields it seems to cause a database fault as the screen freezes when trying to add it. If I refresh the page the field then shows in the list but then none of the activities load on the homepage or show in the contact records.
  Is this a known limitation of custom fields on a set? When checking other forum posts there seems to be people creating upto 90 in a set so not sure what is causing this to fall over if that's the case.
  
  Thanks!
  
  **Tags:** custom-fields, activities
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-08-03. Score: 2
  
  I'm not sure if the issue is what username_3 is suggesting (join limits), or one of database length limits. Your [CiviCRM log](https://civicrm.stackexchange.com/q/15931/12) should give a more detailed error. If you find the error, you can edit your question to include it for better help.
  
  I suspect you're hitting a database length limit. The solution depends on your version of MySQL/MariaDB, but I'm guessing that [changing your database row format to DYNAMIC](https://stackoverflow.com/questions/51250156/how-to-apply-row-format-dynamic-to-an-existing-table) may help.
  
  If you don't have the ability to change this (e.g. you're on a crappy shared host) then consider creating fields with a lower maximum length if you need to fit more - or breaking the custom fields up amongst two groups.
  
  > **Comments:**
  > **username_2**: for non-technical, "breaking the custom fields up amongst two groups" is probably the 'least effort' option.  
  
  ---
  
  ### Answer by username_3 on 2021-08-03. Score: 2
  
  See <https://lab.civicrm.org/dev/core/-/issues/1191> and you can also try <https://github.com/civicrm/civicrm-core/pull/18968> to see if it solves it for you.
  
  
  ---
  
  