CiviCRM Community Forums (archive)

I believe that this problem started when I accidentally clicked twice when deleting a custom data field.  The second click probably interrupted the first, so it did not complete the delete action.  Now the fields still show up, but there are errors when I try to run the delete again.

DB Error: not found
Error Details
Additional Details:

Code: [Select]

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

    [code] => -4
    [message] => DB Error: not found
    [mode] => 16
    [debug_info] =>         ALTER TABLE civicrm_value_1_Forge_Ahead_Information DROP COLUMN `Mentor_` [nativecode=1091 ** Can't DROP 'Mentor_'; check that column/key exists]
    [type] => DB_Error
    [user_info] =>         ALTER TABLE civicrm_value_1_Forge_Ahead_Information DROP COLUMN `Mentor_` [nativecode=1091 ** Can't DROP 'Mentor_'; check that column/key exists]
    [to_string] => [db_error: message="DB Error: not found" code=-4 mode=callback callback=CRM_Core_Error::handle prefix="" info="        ALTER TABLE civicrm_value_1_Forge_Ahead_Information DROP COLUMN `Mentor_` [nativecode=1091 ** Can't DROP 'Mentor_'; check that column/key exists]"]
)


Or this:

DB Error: constraint violation
Error Details
Additional Details:

Code: [Select]

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

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_custom_field  WHERE (  civicrm_custom_field.id = 55 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`yfc_website`.`civicrm_custom_value`, CONSTRAINT `FK_civicrm_custom_value_custom_field_id` FOREIGN KEY (`custom_field_id`) REFERENCES `civicrm_custom_field` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_custom_field  WHERE (  civicrm_custom_field.id = 55 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`yfc_website`.`civicrm_custom_value`, CONSTRAINT `FK_civicrm_custom_value_custom_field_id` FOREIGN KEY (`custom_field_id`) REFERENCES `civicrm_custom_field` (`id`))]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_custom_field  WHERE (  civicrm_custom_field.id = 55 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`yfc_website`.`civicrm_custom_value`, CONSTRAINT `FK_civicrm_custom_value_custom_field_id` FOREIGN KEY (`custom_field_id`) REFERENCES `civicrm_custom_field` (`id`))]"]
)


Suggestions?