Author Topic: Error when upgrading to Civi 2.0 (Read 868 times)

denverdataman · April 26, 2010, 12:17:26 pm

I am getting the following error when I try and upgrade. I have done all the schema imports and checking my data.

Error Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => 
INSERT INTO custom_value_1_Volounteer_Tracking (domain_id,entity_id,_at_Activity_Planning)
SELECT 1, cv.entity_id, cv.int_data FROM civicrm_custom_value cv 
WHERE cv.custom_field_id=8
ON DUPLICATE KEY UPDATE _at_Activity_Planning=cv.int_data [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rainbow_civicrm_fix`.`custom_value_1_Volounteer_Tracking`, CONSTRAINT `FK_custom_value_1_Volounteer_Tracking_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_activity` (`id`) ON DELET)]
    [type] => DB_Error
    [user_info] => 
INSERT INTO custom_value_1_Volounteer_Tracking (domain_id,entity_id,_at_Activity_Planning)
SELECT 1, cv.entity_id, cv.int_data FROM civicrm_custom_value cv 
WHERE cv.custom_field_id=8
ON DUPLICATE KEY UPDATE _at_Activity_Planning=cv.int_data [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rainbow_civicrm_fix`.`custom_value_1_Volounteer_Tracking`, CONSTRAINT `FK_custom_value_1_Volounteer_Tracking_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_activity` (`id`) ON DELET)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
INSERT INTO custom_value_1_Volounteer_Tracking (domain_id,entity_id,_at_Activity_Planning)
SELECT 1, cv.entity_id, cv.int_data FROM civicrm_custom_value cv 
WHERE cv.custom_field_id=8
ON DUPLICATE KEY UPDATE _at_Activity_Planning=cv.int_data [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rainbow_civicrm_fix`.`custom_value_1_Volounteer_Tracking`, CONSTRAINT `FK_custom_value_1_Volounteer_Tracking_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_activity` (`id`) ON DELET)]"]
)

I was running into an error with null values in civicrm_custom_field (http://forum.civicrm.org/index.php?action=profile;u=2048;sa=showPosts) and I gave these 'name' fields names per the instructions.

Any help is greatly appreciated.

Thanks,
Steve [/code]

Deepak Srivastava · April 29, 2010, 09:43:52 am

Seems like you have orphan records in your civicrm_custom_value table (pointing to non existing entity_id). You will have to manually remove/clean them before starting with upgrade.

Tools here could help point out all inconsistencies in your database - http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools.

Note 2.0 is a fairly old version and is no longer actively supported. If you still stuck your best bet might be to hire someone from http://civicrm.org/professional/.

CiviCRM Community Forums (archive)

News:

Author Topic: Error when upgrading to Civi 2.0 (Read 868 times)

denverdataman

Error when upgrading to Civi 2.0

Deepak Srivastava

Re: Error when upgrading to Civi 2.0