CiviCRM Community Forums (archive)

Upgrade from 4.4.14 to 4.5.8 fails... big time :-)

We are hosted by Bluehost and I don't currently have a dev/sandbox running to test on, so I was hoping someone could help me identify the root of this problem?

When we run the upgrade script we get:

[Error: Upgrade DB to 4.5.alpha1: SQL]
Error Field   Error Value


Type   DB_Error
Code   -1
Message   DB Error: unknown error
Mode   16
UserInfo   ALTER TABLE civicrm_contribution DROP FOREIGN KEY `FK_civicrm_contribution_honor_contact_id` [nativecode=1025 ** Error on rename of './ivingisl_civicrm/civicrm_contribution' to './ivingisl_civicrm/#sql2-1277-560ebf' (errno: 152)]
DebugInfo   ALTER TABLE civicrm_contribution DROP FOREIGN KEY `FK_civicrm_contribution_honor_contact_id` [nativecode=1025 ** Error on rename of './ivingisl_civicrm/civicrm_contribution' to './ivingisl_civicrm/#sql2-1277-560ebf' (errno: 152)]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
#   Function   Location
0   CRM_Core_Error::exceptionHandler(Object(DB_Error))   unknown:unknown
1   call_user_func(Array, Object(DB_Error))   /home1/ivingisl/public_html/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'ALTER TABLE civi…')   /home1/ivingisl/public_html/sites/all/modules/civicrm/packages/DB.php:975
3   DB_Error->DB_Error(-1, 16, Array, 'ALTER TABLE civi…')   /home1/ivingisl/public_html/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -1, null, null, 'ALTER TABLE civi…', 'DB_Error', true)   /home1/ivingisl/public_html/sites/all/modules/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-1, null, null, null, '1025 ** Error on…')   /home1/ivingisl/public_html/sites/all/modules/civicrm/packages/DB/mysql.php:899
6   DB_mysql->mysqlRaiseError()   /home1/ivingisl/public_html/sites/all/modules/civicrm/packages/DB/mysql.php:328
7   DB_mysql->simpleQuery('ALTER TABLE civi…')   /home1/ivingisl/public_html/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('ALTER TABLE civi…')   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Utils/File.php:305
9   CRM_Utils_File::sourceSQLFile('mysql://ivingisl…', ' SELECT @wo…', null, true)   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php:205
10   CRM_Upgrade_Form->source(' SELECT @wo…', true)   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php:405
11   CRM_Upgrade_Form->processLocales('/home1/ivingisl/…', '4.5.alpha1')   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php:437
12   CRM_Upgrade_Form->processSQL('4.5.alpha1')   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourFive.php:310
13   CRM_Upgrade_Incremental_php_FourFive::task_4_5_x_runSql(Object(CRM_Queue_TaskContext), '4.5.alpha1')   unknown:unknown
14   call_user_func_array(Array, Array)   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Queue/Task.php:82
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Queue/Runner.php:189
16   CRM_Queue_Runner->runNext(true)   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:48
17   CRM_Queue_Page_AJAX::{closure}()   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:89
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:51
19   CRM_Queue_Page_AJAX::runNext()   unknown:unknown
20   call_user_func(Array)   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:300
21   CRM_Core_Invoke::runItem(Array)   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:79
22   CRM_Core_Invoke::_invoke(Array)   /home1/ivingisl/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /home1/ivingisl/public_html/sites/all/modules/civicrm/drupal/civicrm.module:457
24   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
25   call_user_func_array('civicrm_invoke', Array)   /home1/ivingisl/public_html/includes/menu.inc:519
26   menu_execute_active_handler()   /home1/ivingisl/public_html/index.php:21
27   {main}

Big thanks to http://forum.civicrm.org/index.php/topic,35804.0.html for information.