Answers.Body: <p>If you look at the &quot;Trac&quot; custom field group in the UI does it still have the &quot;Enrolled in a job&quot; field? If so try deleting it again.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-03-26T04:29:53.593Z
Answers.Text: Error seem to go away for awhile. But note to others, it does prevent a civicrm upgrade which may or may not be related: "row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535."
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-03-05T18:30:47.393Z
Answers.LastActivityDate: 2023-03-05T18:30:47.393Z
Answers.UserDisplayName: Demerit
Body: <p>I'm on Drupal 7, CiviCRM 5.57.2. Lately, I've been cleaning up a lot of custom fields in by deleting and adding new ones. I have one case activity type with 112 fields across three custom field sets (this is a workaround for +100 fields).</p>
  <p>Anyway, when this case activity is being submitted, the logo hangs for a long time. I see that the Drupal logging indicates a DB error for no such field found. I cleaned up the cache and update the paths but the issue persist. Has the DB not fully deleted the fields?</p>
  <pre><code>$Fatal Error Details = Array ( [callback] =&gt; Array ( [0] =&gt; CRM_Core_Error [1] =&gt; exceptionHandler ) [code] =&gt; -19 [message] =&gt; DB Error: no such field [mode] =&gt; 16 [debug_info] =&gt; UPDATE civicrm_value_trac_72 SET `leave_1089` = 0,`what_is_the__1046` = '4',`what_is_the_youth_s_home_g_1047` = '7',`educational_status_1051` = '6',`if_yes_to_histor_1066` = '012',`does_the_youth_have_any_of_the_f_1067` = '01234' WHERE id = 1168 [nativecode=1054 ** Unknown column 'enrolled_in_a_job_r_1423' in 'field list'] [type] =&gt; DB_Error [user_info] =&gt; UPDATE civicrm_value_trac_72 SET `leave_1089` = 0,`what_is_the__1046` = '4',``what_is_the_youth_s_home_g_1047` = '7',`educational_status_1051` = '6',`if_yes_to_histor_1066` = '012',`does_the_youth_have_any_of_the_f_1067` = '01234' WHERE id = 1168 [nativecode=1054 ** Unknown column 'enrolled_in_a_job_r_1423' in 'field list'] [to_string] =&gt; [db_error: message=&quot;DB Error: no such field&quot; code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix=&quot;&quot; info=&quot;UPDATE civicrm_value_trac_72 SET `leave_1089` = 0,`what_is_the__1046` = '4',`what_is_the_youth_s_home_g_1047` = '7',`educational_status_1051` = '6',`if_yes_to_histor_1066` = '012',`does_the_youth_have_any_of_the_f_1067` = '01234' WHERE id = 1168 [nativecode=1054 ** Unknown column 'enrolled_in_a_job_r_1423' in 'field list']&quot;] )
  </code></pre>
  
Tags: <custom-fields><civicase><activity>
Title: Case Activities Hanging No Such FIeld
ThreadText: # Case Activities Hanging No Such FIeld
  
  (Asked by: username_0 on 2023-03-05)
  
  I'm on Drupal 7, CiviCRM 5.57.2. Lately, I've been cleaning up a lot of custom fields in by deleting and adding new ones. I have one case activity type with 112 fields across three custom field sets (this is a workaround for +100 fields).
  
  Anyway, when this case activity is being submitted, the logo hangs for a long time. I see that the Drupal logging indicates a DB error for no such field found. I cleaned up the cache and update the paths but the issue persist. Has the DB not fully deleted the fields?
  
  ```
  $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -19 [message] => DB Error: no such field [mode] => 16 [debug_info] => UPDATE civicrm_value_trac_72 SET `leave_1089` = 0,`what_is_the__1046` = '4',`what_is_the_youth_s_home_g_1047` = '7',`educational_status_1051` = '6',`if_yes_to_histor_1066` = '012',`does_the_youth_have_any_of_the_f_1067` = '01234' WHERE id = 1168 [nativecode=1054 ** Unknown column 'enrolled_in_a_job_r_1423' in 'field list'] [type] => DB_Error [user_info] => UPDATE civicrm_value_trac_72 SET `leave_1089` = 0,`what_is_the__1046` = '4',``what_is_the_youth_s_home_g_1047` = '7',`educational_status_1051` = '6',`if_yes_to_histor_1066` = '012',`does_the_youth_have_any_of_the_f_1067` = '01234' WHERE id = 1168 [nativecode=1054 ** Unknown column 'enrolled_in_a_job_r_1423' in 'field list'] [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="UPDATE civicrm_value_trac_72 SET `leave_1089` = 0,`what_is_the__1046` = '4',`what_is_the_youth_s_home_g_1047` = '7',`educational_status_1051` = '6',`if_yes_to_histor_1066` = '012',`does_the_youth_have_any_of_the_f_1067` = '01234' WHERE id = 1168 [nativecode=1054 ** Unknown column 'enrolled_in_a_job_r_1423' in 'field list']"] )
  
  ```
  
  **Tags:** custom-fields, civicase, activity
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-03-05. Score: 0 | Accepted answer
  
  If you look at the "Trac" custom field group in the UI does it still have the "Enrolled in a job" field? If so try deleting it again.
  
  > **Comments:**
  > **username_0**: Error seem to go away for awhile. But note to others, it does prevent a civicrm upgrade which may or may not be related: "row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535."  
  
  ---
  
  