Answers.Body: <p>duh! I just had to Disable the custom field.  Works fine now.   </p>
  
  <p>value_dlse_claim_details_4.unpaid_wages_162</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-05T18:21:41.117Z
Answers.LastActivityDate: 2016-02-05T18:21:41.117Z
Answers.UserDisplayName: Leslie Dugger
Body: <p>I am getting an error when I click <em>manage case</em>. Looks like it has something to do with custom fields for a custom field type (DLSE Claim). </p>
  
  <p>Wordpress 4.4.2
  CiviCRM 4.6.11</p>
  
  <p>This happened after upgrading to 4.7.. after rolling back, it worked for a while, then started acting funky again.  </p>
  
  <p>Below is the debug.  Thanks!</p>
  
  <p>backTrace</p>
  
  <pre><code>#0 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
  #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  #2 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
  #3 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB.php(976): PEAR_Error-&gt;PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #4 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error-&gt;DB_Error(-19, 16, (Array:2), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #5 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR-&gt;raiseError(NULL, -19, NULL, NULL, "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", "DB_Error", TRUE)
  #6 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common-&gt;raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_value_dlse_claim_details_4.unpaid_wages_162' ...")
  #7 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql-&gt;mysqlRaiseError()
  #8 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql-&gt;simpleQuery("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #9 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common-&gt;query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #10 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject-&gt;_query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #11 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject-&gt;query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #12 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1192): CRM_Core_DAO-&gt;query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", TRUE)
  #13 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(735): CRM_Core_DAO::executeQuery("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #14 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(692): CRM_Core_BAO_CustomGroup::buildTreeEntityDataFromQuery((Array:4), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", (Array:3))
  #15 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(626): CRM_Core_BAO_CustomGroup::buildEntityTreeSingleFields((Array:4), 60, (Array:52), (Array:3))
  #16 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Form/CaseView.php(190): CRM_Core_BAO_CustomGroup::getTree("Case", Object(CRM_Case_Form_CaseView), "60", NULL, "3")
  #17 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(455): CRM_Case_Form_CaseView-&gt;preProcess()
  #18 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form-&gt;buildForm()
  #19 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display-&gt;perform(Object(CRM_Case_Form_CaseView), "display")
  #20 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Case_Form_CaseView), "display")
  #21 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page-&gt;handle("display")
  #22 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Page/Tab.php(115): CRM_Core_Controller-&gt;run()
  #23 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Page/Tab.php(204): CRM_Case_Page_Tab-&gt;view()
  #24 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Case_Page_Tab-&gt;run((Array:4), NULL)
  #25 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
  #26 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
  #27 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm.php(1189): CRM_Core_Invoke::invoke((Array:4))
  #28 [internal function](): CiviCRM_For_WordPress-&gt;invoke("")
  #29 /home/laaneorg/public_html/portwp/wp-includes/plugin.php(525): call_user_func_array((Array:2), (Array:1))
  #30 /home/laaneorg/public_html/portwp/wp-admin/admin.php(236): do_action("toplevel_page_CiviCRM")
  #31 {main}
  </code></pre>
  
Tags: <custom-fields><civicase><error><php>
Title: CiviCase Error.. Help!
ThreadText: # CiviCase Error.. Help!
  
  (Asked by: username_0 on 2016-02-05)
  
  I am getting an error when I click *manage case*. Looks like it has something to do with custom fields for a custom field type (DLSE Claim).
  
  Wordpress 4.4.2
  CiviCRM 4.6.11
  
  This happened after upgrading to 4.7.. after rolling back, it worked for a while, then started acting funky again.
  
  Below is the debug. Thanks!
  
  backTrace
  
  ```
  #0 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
  #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  #2 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
  #3 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #4 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #5 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", "DB_Error", TRUE)
  #6 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_value_dlse_claim_details_4.unpaid_wages_162' ...")
  #7 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
  #8 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #9 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #10 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #11 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #12 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1192): CRM_Core_DAO->query("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", TRUE)
  #13 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(735): CRM_Core_DAO::executeQuery("\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...")
  #14 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(692): CRM_Core_BAO_CustomGroup::buildTreeEntityDataFromQuery((Array:4), "\n      SELECT civicrm_value_dlse_claim_1.id as civicrm_value_dlse_claim_1_id...", (Array:3))
  #15 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(626): CRM_Core_BAO_CustomGroup::buildEntityTreeSingleFields((Array:4), 60, (Array:52), (Array:3))
  #16 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Form/CaseView.php(190): CRM_Core_BAO_CustomGroup::getTree("Case", Object(CRM_Case_Form_CaseView), "60", NULL, "3")
  #17 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(455): CRM_Case_Form_CaseView->preProcess()
  #18 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form->buildForm()
  #19 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Case_Form_CaseView), "display")
  #20 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Case_Form_CaseView), "display")
  #21 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("display")
  #22 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Page/Tab.php(115): CRM_Core_Controller->run()
  #23 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Case/Page/Tab.php(204): CRM_Case_Page_Tab->view()
  #24 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Case_Page_Tab->run((Array:4), NULL)
  #25 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
  #26 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
  #27 /home/laaneorg/public_html/portwp/wp-content/plugins/civicrm/civicrm.php(1189): CRM_Core_Invoke::invoke((Array:4))
  #28 [internal function](): CiviCRM_For_WordPress->invoke("")
  #29 /home/laaneorg/public_html/portwp/wp-includes/plugin.php(525): call_user_func_array((Array:2), (Array:1))
  #30 /home/laaneorg/public_html/portwp/wp-admin/admin.php(236): do_action("toplevel_page_CiviCRM")
  #31 {main}
  
  ```
  
  **Tags:** custom-fields, civicase, error, php
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2016-02-05. Score: 1
  
  duh! I just had to Disable the custom field. Works fine now.
  
  value\_dlse\_claim\_details\_4.unpaid\_wages\_162
  
  
  ---
  
  