CiviCRM Community Forums (archive)

Okay, I was trying to set up the member profile and sign-up parts to be applicable for our uses, but every time I try to delete one of the custom fields (I have been able to delete other things, like the "transgender" option as well as the "interview" activity type) I keep getting this error, which I will post below. Any help fixing this would be appreciated. Thanks!

Quote

Confirm Custom Field Delete

Sorry. A non-recoverable error has occurred.
DB Error: not found

Database Error Code: Can't DROP 'INDEX_marital_status_2'; check that column/key exists, 1091

Return to home page.

Quote

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

    [ code] => -4

((I put a space there so it would show up correctly))
    [message] => DB Error: not found
    [mode] => 16
    [debug_info] =>         ALTER TABLE civicrm_value_constituent_information_1 DROP COLUMN `marital_status_2`, DROP INDEX INDEX_marital_status_2 [nativecode=1091 ** Can't DROP 'INDEX_marital_status_2'; check that column/key exists]
    [type] => DB_Error
    [user_info] =>         ALTER TABLE civicrm_value_constituent_information_1 DROP COLUMN `marital_status_2`, DROP INDEX INDEX_marital_status_2 [nativecode=1091 ** Can't DROP 'INDEX_marital_status_2'; 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_constituent_information_1 DROP COLUMN `marital_status_2`, DROP INDEX INDEX_marital_status_2 [nativecode=1091 ** Can't DROP 'INDEX_marital_status_2'; check that column/key exists]"]
)