CiviCRM Community Forums (archive)

I'm upgrading a Civicrm 1.8 install under drupal 5. After successfully upgrading the database from MyISAM to InnoDB and applying the 1.9 upgrade SQL successfully, I get the following error in step 5 when running the 2.0 upgrade. I suspect there is a data problem in the database, but not sure where to look to fix. Can someone provide some expert guidance please?

Thanks for the assist. This is my holiday weekend project.

Randy

-------------------------------------------------------------------------------------

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>
INSERT INTO civicrm_value_1_alumni_information (domain_id,entity_id,maiden_name)
SELECT 1, cv.entity_id, cv.char_data FROM civicrm_custom_value cv
WHERE cv.custom_field_id=5
ON DUPLICATE KEY UPDATE maiden_name=cv.char_data [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm20/civicrm_value_1_alumni_information`, CONSTRAINT `FK_civicrm_value_1_alumni_information_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] =>
INSERT INTO civicrm_value_1_alumni_information (domain_id,entity_id,maiden_name)
SELECT 1, cv.entity_id, cv.char_data FROM civicrm_custom_value cv
WHERE cv.custom_field_id=5
ON DUPLICATE KEY UPDATE maiden_name=cv.char_data [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm20/civicrm_value_1_alumni_information`, CONSTRAINT `FK_civicrm_value_1_alumni_information_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
INSERT INTO civicrm_value_1_alumni_information (domain_id,entity_id,maiden_name)
SELECT 1, cv.entity_id, cv.char_data FROM civicrm_custom_value cv
WHERE cv.custom_field_id=5
ON DUPLICATE KEY UPDATE maiden_name=cv.char_data [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm20/civicrm_value_1_alumni_information`, CONSTRAINT `FK_civicrm_value_1_alumni_information_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

I discovered that I had a lot of records in the civicrm_custom_value table with a value for entity_table that was non-existent. I deleted those records and the database upgrade completed successfully.


Randy