Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-7293

After deletetion of contact custom field, cannot save a contact

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.3.1
    • Fix Version/s: 3.3.2
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      There is a set of custom fields called "Health Related" that can be used for any individual.

      This originally had 2 custom fields: "Allergies" and "Learning issues", both of type "Note" This situation worked as expected.

      However, after deleting the custom field "Learning Issues" , any attempt to save of any individual contact failed with an SQL error. If I recreated the custom field, then the error disappeared.

      The error details:

      Database Error Code: Unknown column 'learning_issues_105' in 'NEW', 1054
      Additional Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => UPDATE civicrm_value_health_related_22 SET allergies_95 = '' WHERE id = 8 [nativecode=1054 ** Unknown column 'learning_issues_105' in 'NEW']
      [type] => DB_Error
      [user_info] => UPDATE civicrm_value_health_related_22 SET allergies_95 = '' WHERE id = 8 [nativecode=1054 ** Unknown column 'learning_issues_105' in 'NEW']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_value_health_related_22 SET allergies_95 = '' WHERE id = 8 [nativecode=1054 ** Unknown column 'learning_issues_105' in 'NEW']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              shot Piotr Szotkowski
              Reporter:
              sgladstone Sarah Gladstone
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: