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.3.5 to 4.3.7 fails plus patch throws up error
Pages: [1]

Author Topic: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error  (Read 1271 times)

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 10, 2013, 07:46:01 am
Hi, I have recently tried to upgrade from 4.3.5 to 4.3.7. Each time I do so the upgrade halts and fails to complete. When I return to the CiviCRM home page I then get the message 'Database check failed – the database looks to have been partially upgraded'. I have tried upgrading to 4.3.6 and to 4.4 Beta 4 but have exactly the same result. I have never had problems with upgrades until this point in time so I am wondering what has changed since 4.3.6.

I have now reverted to using the patch. However this throws up an error saying that it can't find 'CiviTest/CiviUnitTestCase.php'. Could you tell me where this file should be located? It looks as though it may be missing.
« Last Edit: October 10, 2013, 02:33:33 pm by JohnM »

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 12, 2013, 11:02:47 am
A week on and I am still having problems with this upgrade. I have disabled all Drupal extensions and for good measure the extensions I am using within CiviCRM. Also downloaded the latest copies of the upgrade files. I just tried to rerun the upgrade again from 4.3.5 to 4.3.7 and yet again it has stalled without completing the upgrade. The upgrade page is not giving much away apart from the details below. Can anyone give me some advice on what's going wrong? As mentioned before, I have never had a problem applying upgrades until now.

home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
20   call_user_func(Array, Array)   /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:258
21   CRM_Core_Invoke::runItem(Array)   /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:70
22   CRM_Core_Invoke::_invoke(Array)   /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /home/admin/public_html/sites/all/modules/civicrm/drupal/civicrm.module:436
24   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
25   call_user_func_array('civicrm_invoke', Array)   /home/admin/public_html/includes/menu.inc:517
26   menu_execute_active_handler()   /home/admin/public_html/index.php:21

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 12, 2013, 11:38:21 am

1. might want to switch to a default drupal theme and test

2. if you have firebug installed, wondering if that will give you better error messages

3. Does the log in files/civicrm/ConfigAndLog give u any clues?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 12, 2013, 01:54:49 pm
Could be related to http://forum.civicrm.org/index.php/topic,30112.0.html
Try asking your question on the new CiviCRM help site.

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 13, 2013, 02:10:51 am
Thanks for the quick response. I have just tried updating again using a default Drupal theme. Can now see much more information. It is a 'DB Error: constraint violation' problem.

Message displayed below...any suggestions on how to resolve this? John

[Error: Add mising contraints]

Error Field

Error Value

Type DB_Error
Code -3
Message DB Error: constraint violation
Mode 16
UserInfo ALTER TABLE civicrm_contribution_recur ADD CONSTRAINT `FK_civicrm_contribution_recur_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE , ADD CONSTRAINT `FK_civicrm_contribution_recur_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE SET NULL , ADD CONSTRAINT `FK_civicrm_contribution_recur_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xxxxxxcivicrm`., CONSTRAINT `FK_civicrm_contribution_recur_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_pa)]
DebugInfo ALTER TABLE civicrm_contribution_recur ADD CONSTRAINT `FK_civicrm_contribution_recur_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE , ADD CONSTRAINT `FK_civicrm_contribution_recur_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE SET NULL , ADD CONSTRAINT `FK_civicrm_contribution_recur_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xxxxxxxxcivicrm`., CONSTRAINT `FK_civicrm_contribution_recur_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_pa)]

PEAR_Exception: DB Error: constraint violation in unknown on line unknown
- DB_Error: DB Error: constraint violation 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)) /home/admin/public_html/sites/all/modules/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: constr…', -3, 16, Array, 'ALTER TABLE civi…') /home/admin/public_html/sites/all/modules/civicrm/packages/DB.php:969
3 DB_Error->DB_Error(-3, 16, Array, 'ALTER TABLE civi…') /home/admin/public_html/sites/all/modules/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -3, null, null, 'ALTER TABLE civi…', 'DB_Error', true) /home/admin/public_html/sites/all/modules/civicrm/packages/DB/common.php:1905
5 DB_common->raiseError(-3, null, null, null, '1452 ** Cannot a…') /home/admin/public_html/sites/all/modules/civicrm/packages/DB/mysql.php:898
6 DB_mysql->mysqlRaiseError() /home/admin/public_html/sites/all/modules/civicrm/packages/DB/mysql.php:327
7 DB_mysql->simpleQuery('ALTER TABLE civi…') /home/admin/public_html/sites/all/modules/civicrm/packages/DB/common.php:1216
8 DB_common->query('ALTER TABLE civi…') /home/admin/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9 DB_DataObject->_query('ALTER TABLE civi…') /home/admin/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10 DB_DataObject->query('ALTER TABLE civi…') /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:155
11 CRM_Core_DAO->query('ALTER TABLE civi…', true) /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:917
12 CRM_Core_DAO::executeQuery('ALTER TABLE civi…') /home/admin/public_html/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:889
13 CRM_Upgrade_Incremental_php_FourThree::addMissingConstraints(Object(CRM_Queue_TaskContext), '4.3.6') unknown:unknown
14 call_user_func_array(Array, Array) /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16 CRM_Queue_Runner->runNext(true) /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17 {closure}() /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18 CRM_Queue_ErrorPolicy->call(Object(Closure)) /home/admin/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
19 CRM_Queue_Page_AJAX::runNext(Array) unknown:unknown
20 call_user_func(Array, Array) /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:258
21 CRM_Core_Invoke::runItem(Array) /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:70
22 CRM_Core_Invoke::_invoke(Array) /home/admin/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23 CRM_Core_Invoke::invoke(Array) /home/admin/public_html/sites/all/modules/civicrm/drupal/civicrm.module:436
24 civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext') unknown:unknown
25 call_user_func_array('civicrm_invoke', Array) /home/admin/public_html/includes/menu.inc:517
26 menu_execute_active_handler() /home/admin/public_html/index.php:21
27 {main}
« Last Edit: October 13, 2013, 02:29:17 am by JohnM »

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 13, 2013, 02:39:31 am
Just had another look at http://wiki.civicrm.org/confluence/display/CRMDOC/Fixing+Orphaned+Contribution+Recur+Records

We do have one recurring contribution record in our database (not active). This was a test and is still showing on the user's record card. May be this is the issue?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 13, 2013, 10:26:21 am

might want to delete that recurring record if it was just a test. might help u make progress

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

MattT

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: WordPress
  • MySQL version: 5.5.30-cll
  • PHP version: 5.3.23
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 13, 2013, 11:01:30 am
I received the exact same error when attempting an upgrade from 4.3.5 to 4.3.7 on WordPress. I'd greatly appreciate any suggestions for fixing the error—or ways to work around it to upgrade to a functional system.

Thanks,
Matt

---


[Error: Add mising contraints]
Error Field   Error Value
Type   DB_Error
Code   -3
Message   DB Error: constraint violation
Mode   16
UserInfo   ALTER TABLE civicrm_contribution_recur ADD CONSTRAINT `FK_civicrm_contribution_recur_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE , ADD CONSTRAINT `FK_civicrm_contribution_recur_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE SET NULL , ADD CONSTRAINT `FK_civicrm_contribution_recur_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`oclba0_civicrm`.`#sql-2812_130dc74`, CONSTRAINT `FK_civicrm_contribution_recur_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
DebugInfo   ALTER TABLE civicrm_contribution_recur ADD CONSTRAINT `FK_civicrm_contribution_recur_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE , ADD CONSTRAINT `FK_civicrm_contribution_recur_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE SET NULL , ADD CONSTRAINT `FK_civicrm_contribution_recur_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`oclba0_civicrm`.`#sql-2812_130dc74`, CONSTRAINT `FK_civicrm_contribution_recur_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
PEAR_Exception: DB Error: constraint violation in unknown on line unknown
- DB_Error: DB Error: constraint violation 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))   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: constr…', -3, 16, Array, 'ALTER TABLE civi…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-3, 16, Array, 'ALTER TABLE civi…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -3, null, null, 'ALTER TABLE civi…', 'DB_Error', true)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-3, null, null, null, '1452 ** Cannot a…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('ALTER TABLE civi…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php:1216
8   DB_common->query('ALTER TABLE civi…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query('ALTER TABLE civi…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query('ALTER TABLE civi…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:155
11   CRM_Core_DAO->query('ALTER TABLE civi…', true)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:917
12   CRM_Core_DAO::executeQuery('ALTER TABLE civi…')   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:889
13   CRM_Upgrade_Incremental_php_FourThree::addMissingConstraints(Object(CRM_Queue_TaskContext), '4.3.6')   unknown:unknown
14   call_user_func_array(Array, Array)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
20   call_user_func(Array, Array)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:258
21   CRM_Core_Invoke::runItem(Array)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:70
22   CRM_Core_Invoke::_invoke(Array)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /home/oclba0/public_html/wp-content/plugins/civicrm/civicrm.php:344
24   civicrm_wp_invoke('')   unknown:unknown
25   call_user_func_array('civicrm_wp_invok…', Array)   /home/oclba0/public_html/wp-includes/plugin.php:406
26   do_action('toplevel_page_Ci…')   /home/oclba0/public_html/wp-admin/admin.php:149
27   {main}   

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error
October 13, 2013, 02:53:54 pm
Success! The upgrade worked. This is what I did...

1. Using phpMyAdmin I viewed the civicrm_contribution_recur table.
2. Found a single recurring contribution record in it (This was a test record).
3. Deleted the record so the table was empty
4. Then ran the upgrade again.

This time it worked first time. 

Thank you everyone for your help.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade from 4.3.5 to 4.3.7 fails plus patch throws up error

This forum was archived on 2017-11-26.