CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade from 4.4.14 to 4.5.8 fails - ALTER TABLE civicrm_contribution DROP FK...
Pages: [1]

Author Topic: Upgrade from 4.4.14 to 4.5.8 fails - ALTER TABLE civicrm_contribution DROP FK...  (Read 678 times)

dkguru

  • I’m new here
  • *
  • Posts: 3
  • Karma: 1
    • Living Islands Non-Profit
  • CiviCRM version: 4.4.14
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Upgrade from 4.4.14 to 4.5.8 fails - ALTER TABLE civicrm_contribution DROP FK...
April 02, 2015, 12:24:54 am
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}

dkguru

  • I’m new here
  • *
  • Posts: 3
  • Karma: 1
    • Living Islands Non-Profit
  • CiviCRM version: 4.4.14
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Re: Upgrade from 4.4.14 to 4.5.8 fails - ALTER TABLE civicrm_contribution DROP FK...
April 02, 2015, 12:59:58 am
Found it. Uncomment these two lines...

{* ALTER TABLE civicrm_contribution DROP FOREIGN KEY `FK_civicrm_contribution_honor_contact_id`; *}
{* ALTER TABLE civicrm_pledge DROP FOREIGN KEY `FK_civicrm_pledge_honor_contact_id`; *}

The fields will be removed *correctly* by a later script :-)

dkguru

  • I’m new here
  • *
  • Posts: 3
  • Karma: 1
    • Living Islands Non-Profit
  • CiviCRM version: 4.4.14
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Re: Upgrade from 4.4.14 to 4.5.8 fails - ALTER TABLE civicrm_contribution DROP FK...
April 02, 2015, 01:00:49 am
Big thanks to http://forum.civicrm.org/index.php/topic,35804.0.html for information.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade from 4.4.14 to 4.5.8 fails - ALTER TABLE civicrm_contribution DROP FK...

This forum was archived on 2017-11-26.