Answers.Body: <p>CiviCRM has an undocumented limit on the number of custom fields inside a custom group, which might be 65 fields, or it might depend on the type of fields (text vs numeric).</p>
  <p>Looking at your database, 71 custom fields had been created, but only the first 65 had actually been created in the underlying storage, which is what was causing the error.</p>
  <p>To mitigate the issue, I disable those fields that do not really exist, and I recommend that you delete them completely.</p>
  <p>You can then create a separate custom group for more fields. Ideally, you can try to group them logically somehow (by thematic?) so that it looks more intuitive. The end result will be exactly the same as if they were in a single group, but visually there will be some separator between the two groups.</p>
  <p>(I'm a CiviCRM Spark admin, so I could view the detailed error log and examine the underlying database. You can also email us at spark-at-civicrm.org)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-14T19:48:03.497Z
Answers.LastActivityDate: 2022-02-14T19:48:03.497Z
Answers.UserDisplayName: bgm
Body: <p>When I attempt to open a contact in CiviCRM Spark, I get the error message below, any ideas?  See also screenshot.</p>
  <p><a href="https://i.sstatic.net/PAUG3.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/PAUG3.png" alt="enter image description here" /></a>Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: no such field
  Return to home page.</p>
  
Tags: <contacts><civicrm-spark>
Title: "No such field" when attempting to open a contact in CiviCRM Spark
ThreadText: # "No such field" when attempting to open a contact in CiviCRM Spark
  
  (Asked by: username_0 on 2022-02-14)
  
  When I attempt to open a contact in CiviCRM Spark, I get the error message below, any ideas? See also screenshot.
  
  [![enter image description here](https://i.sstatic.net/PAUG3.png)](https://i.sstatic.net/PAUG3.png)Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: no such field
  Return to home page.
  
  **Tags:** contacts, civicrm-spark
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-02-14. Score: 3
  
  CiviCRM has an undocumented limit on the number of custom fields inside a custom group, which might be 65 fields, or it might depend on the type of fields (text vs numeric).
  
  Looking at your database, 71 custom fields had been created, but only the first 65 had actually been created in the underlying storage, which is what was causing the error.
  
  To mitigate the issue, I disable those fields that do not really exist, and I recommend that you delete them completely.
  
  You can then create a separate custom group for more fields. Ideally, you can try to group them logically somehow (by thematic?) so that it looks more intuitive. The end result will be exactly the same as if they were in a single group, but visually there will be some separator between the two groups.
  
  (I'm a CiviCRM Spark admin, so I could view the detailed error log and examine the underlying database. You can also email us at spark-at-civicrm.org)
  
  
  ---
  
  