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']"]
)