CiviCRM Community Forums (archive)

Hi, don't know if there's a bug or I'm doing something wrong. Working on a site for kids school. Created custom data group with two fields of "Contact Reference" type. Dropdown works fine but doesn't recognize selection. Because of this, I tried to delete the fields and received error msg. I'm not experienced enough to understand how to debug. Did I configure something incorrectly in db? Error msg as follows:
   
Sorry. A non-recoverable error has occurred.

    DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

    Database Error Code: Error on rename of './burleyptamanager/civicrm_value_student_information_1' to './burleyptamanager/#sql2-1921-fd13f4' (errno: 152), 1025

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] =>         ALTER TABLE civicrm_value_student_information_1 DROP COLUMN `parent_guardian_1_1`, DROP FOREIGN KEY FK_civicrm_value_student_information_1_parent_guardian_1_1 [nativecode=1025 ** Error on rename of './burleyptamanager/civicrm_value_student_information_1' to './burleyptamanager/#sql2-1921-fd13f4' (errno: 152)]
    [type] => DB_Error
    [user_info] =>         ALTER TABLE civicrm_value_student_information_1 DROP COLUMN `parent_guardian_1_1`, DROP FOREIGN KEY FK_civicrm_value_student_information_1_parent_guardian_1_1 [nativecode=1025 ** Error on rename of './burleyptamanager/civicrm_value_student_information_1' to './burleyptamanager/#sql2-1921-fd13f4' (errno: 152)]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="        ALTER TABLE civicrm_value_student_information_1 DROP COLUMN `parent_guardian_1_1`, DROP FOREIGN KEY FK_civicrm_value_student_information_1_parent_guardian_1_1 [nativecode=1025 ** Error on rename of './burleyptamanager/civicrm_value_student_information_1' to './burleyptamanager/#sql2-1921-fd13f4' (errno: 152)]"]
)


Thanks for the quick response/links!!