CiviCRM Community Forums (archive)

Upgraded today to beta5 from CiviCRM 2.0.6 and drupal 5. Am on Drupal 6.4 with everything working, civi is the last thing.

Followed upgrade instructions and then went to sites/all/modules/civicrm/install/upgrade.php

and I get this error:

backTrace

/var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/var/www/html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/var/www/html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/var/www/html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/html/sites/all/modules/civicrm/CRM/Utils/File.php, query, 225
/var/www/html/sites/all/modules/civicrm/CRM/Upgrade/Form.php, sourceSQLFile, 75
/var/www/html/sites/all/modules/civicrm/CRM/Upgrade/TwoOne/Form/Step1.php, source, 261
/var/www/html/sites/all/modules/civicrm/CRM/Upgrade/TwoOne/Page/Upgrade.php, upgrade, 65
/var/www/html/sites/all/modules/civicrm/CRM/Upgrade/TwoOne/Page/Upgrade.php, runForm, 41
/var/www/html/sites/all/modules/civicrm/install/upgrade.php, run, 48
/var/www/html/sites/all/modules/civicrm/install/upgrade.php, run, 51

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: unknown error

    Database Error Code: Error on rename of './cctvcivicrm_v2/civicrm_acl' to './cctvcivicrm_v2/#sql2-6cb-c44b' (errno: 152), 1025

    Return to home page.

Error Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_acl` DROP FOREIGN KEY `FK_civicrm_acl_domain_id` [nativecode=1025 ** Error on rename of './cctvcivicrm_v2/civicrm_acl' to './cctvcivicrm_v2/#sql2-6cb-c44b' (errno: 152)]
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_acl` DROP FOREIGN KEY `FK_civicrm_acl_domain_id` [nativecode=1025 ** Error on rename of './cctvcivicrm_v2/civicrm_acl' to './cctvcivicrm_v2/#sql2-6cb-c44b' (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_acl` DROP FOREIGN KEY `FK_civicrm_acl_domain_id` [nativecode=1025 ** Error on rename of './cctvcivicrm_v2/civicrm_acl' to './cctvcivicrm_v2/#sql2-6cb-c44b' (errno: 152)]"]
)

Ideas?[/code]

hmmm. I did not yet try this procedure: http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

That procedure is to be used when upgrading from 1.8/1.9.

You problem looks same as this one - http://forum.civicrm.org/index.php/topic,4259.0.html. So might first wanna try some of the checks/solutions suggested there.