CiviCRM Community Forums (archive)

I am upgrading a 1.9 Drupal Database to version 2.0 and get the following error at the time I run step 6 - Miscellaneous Data

    Sorry. A non-recoverable error has occurred.
    DB Error: unknown error
    Database Error Code: Error on rename of './civicrm/civicrm_entity_tag' to './civicrm/#sql2-54ce-2165339' (errno: 152), 1025
    Return to home page.

Error Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )
    (code) => -1
   

[message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_entity_tag`
    ADD `contact_id` int(10) unsigned NULL DEFAULT NULL AFTER id,
    DROP FOREIGN KEY `FK_civicrm_entity_tag_tag_id` [nativecode=1025 ** Error on rename of './civicrm/civicrm_entity_tag' to './civicrm/#sql2-54ce-2165339' (errno: 152)]
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_entity_tag`
    ADD `contact_id` int(10) unsigned NULL DEFAULT NULL AFTER id,
    DROP FOREIGN KEY `FK_civicrm_entity_tag_tag_id` [nativecode=1025 ** Error on rename of './civicrm/civicrm_entity_tag' to './civicrm/#sql2-54ce-2165339' (errno: 152)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_entity_tag`
    ADD `contact_id` int(10) unsigned NULL DEFAULT NULL AFTER id,
    DROP FOREIGN KEY `FK_civicrm_entity_tag_tag_id` [nativecode=1025 ** Error on rename of './civicrm/civicrm_entity_tag' to './civicrm/#sql2-54ce-2165339' (errno: 152)]"]
)

My .._entity_tag table only references contact_ID's that actually exist - have checked this (and no org id's)
I have dropped the table and manually recreated it without the offending FK before step 6 in order to ensure the data and table structure are good - no change.


Please help!

Ok - I dropped the entire table and then recreated without the constraint.
Then I added the constraint using your script
Then The upgrade completed without problem!! (yay)

weird one - something was bizarre with the original constraint, because it wouldn't let me just drop it either. Go figure.