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) »
  • Wordpress 4.2.9 Upgrade to 4.4.4 failing
Pages: [1]

Author Topic: Wordpress 4.2.9 Upgrade to 4.4.4 failing  (Read 1046 times)

Interpolat

  • I post frequently
  • ***
  • Posts: 140
  • Karma: -1
    • Interpolat Solutions, LLC.
  • CiviCRM version: 4.4+
  • CMS version: Wordpress
  • MySQL version: 5.5+
  • PHP version: 5.4+
Wordpress 4.2.9 Upgrade to 4.4.4 failing
February 15, 2014, 10:14:21 pm
I have been trying to execute an upgrade, initially from 4.2.2 to 4.4.4.  Have managed to get Civi to 4.2.9, but cannot make the jump past 4.3.0.  Upgrade seems to simply hang at [Executed: Check/Add indexes for civicrm_entity_financial_trxn]

Looked in the error Logs and I am getting:

Code: [Select]
Feb 16 05:56:57  [info] $Fatal Error Details = Array
(
    [message] => Could not find valid value for qrid
    [code] =>
)


Feb 16 05:56:57  [info] $backTrace = #0 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(322): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Utils/Request.php(106): CRM_Core_Error::fatal("Could not find valid value for qrid")
#2 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/Runner.php(52): CRM_Utils_Request::retrieve("qrid", "String", Object(CRM_Queue_Page_Runner), TRUE)
#3 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(323): CRM_Queue_Page_Runner->run((Array:4), NULL)
#4 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#5 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#6 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm.php(466): CRM_Core_Invoke::invoke((Array:4))
#7 [internal function](): CiviCRM_For_WordPress->invoke("")
#8 /var/www/vhosts/thsc.org/securedev/wp-includes/plugin.php(429): call_user_func_array((Array:2), (Array:1))
#9 /var/www/vhosts/thsc.org/securedev/wp-admin/admin.php(217): do_action("toplevel_page_CiviCRM")
#10 {main}


Feb 16 06:01:56  [info] $backTrace = #0 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(770): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: can not create", -15, 16, (Array:2), "ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#4 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-15, 16, (Array:2), "ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#5 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -15, NULL, NULL, "ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...", "DB_Error", TRUE)
#6 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-15, NULL, NULL, NULL, "1005 ** Can't create table 'admin_scthsc_civicrm.#sql-3183_20038' (errno: 121)")
#7 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#9 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Utils/File.php(284): DB_common->query("ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#10 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php(160): CRM_Utils_File::sourceSQLFile("mysql://admin_scthsc_cv:Relevant2014!@localhost/admin_scthsc_civicrm?new_link...", "\n  \n  SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name =...", NULL, TRUE)
#11 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php(300): CRM_Upgrade_Form->source("\n  \n  SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name =...", TRUE)
#12 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php(324): CRM_Upgrade_Form->processLocales("/var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upg...", "4.3.alpha1")
#13 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FourThree.php(1247): CRM_Upgrade_Form->processSQL("4.3.alpha1")
#14 [internal function](): CRM_Upgrade_Incremental_php_FourThree::task_4_3_x_runSql(Object(CRM_Queue_TaskContext), "4.3.alpha1")
#15 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php(79): call_user_func_array((Array:2), (Array:2))
#16 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php(186): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#17 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php(44): CRM_Queue_Runner->runNext(TRUE)
#18 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php(80): {closure}()
#19 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php(47): CRM_Queue_ErrorPolicy->call(Object(Closure))
#20 [internal function](): CRM_Queue_Page_AJAX::runNext((Array:5))
#21 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(289): call_user_func((Array:2), (Array:5))
#22 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#23 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#24 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm.php(466): CRM_Core_Invoke::invoke((Array:5))
#25 [internal function](): CiviCRM_For_WordPress->invoke("")
#26 /var/www/vhosts/thsc.org/securedev/wp-includes/plugin.php(429): call_user_func_array((Array:2), (Array:1))
#27 /var/www/vhosts/thsc.org/securedev/wp-admin/admin.php(217): do_action("toplevel_page_CiviCRM")
#28 {main}


Feb 16 06:01:56  [info] $CRM_Queue_Page_AJAX_runNext_error = PEAR_Exception: "DB Error: can not create"
 * ERROR TYPE: DB_Error
 * ERROR CODE: -15
 * ERROR MESSAGE: DB Error: can not create
 * ERROR MODE: 16
 * ERROR USERINFO: ALTER TABLE `civicrm_entity_financial_account`
  ADD CONSTRAINT `FK_civicrm_entity_financial_account_financial_account_id` FOREIGN KEY (`financial_account_id`) REFERENCES `civicrm_financial_account` (`id`) [nativecode=1005 ** Can't create table 'admin_scthsc_civicrm.#sql-3183_20038' (errno: 121)]
 * ERROR DEBUGINFO: ALTER TABLE `civicrm_entity_financial_account`
  ADD CONSTRAINT `FK_civicrm_entity_financial_account_financial_account_id` FOREIGN KEY (`financial_account_id`) REFERENCES `civicrm_financial_account` (`id`) [nativecode=1005 ** Can't create table 'admin_scthsc_civicrm.#sql-3183_20038' (errno: 121)]
#0 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#2 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: can not create", -15, 16, (Array:2), "ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#3 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-15, 16, (Array:2), "ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#4 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -15, NULL, NULL, "ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...", "DB_Error", TRUE)
#5 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-15, NULL, NULL, NULL, "1005 ** Can't create table 'admin_scthsc_civicrm.#sql-3183_20038' (errno: 121)")
#6 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#7 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#8 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Utils/File.php(284): DB_common->query("ALTER TABLE `civicrm_entity_financial_account`\n  ADD CONSTRAINT `FK_civicrm_...")
#9 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php(160): CRM_Utils_File::sourceSQLFile("mysql://admin_scthsc_cv:Relevant2014!@localhost/admin_scthsc_civicrm?new_link...", "\n  \n  SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name =...", NULL, TRUE)
#10 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php(300): CRM_Upgrade_Form->source("\n  \n  SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name =...", TRUE)
#11 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php(324): CRM_Upgrade_Form->processLocales("/var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upg...", "4.3.alpha1")
#12 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FourThree.php(1247): CRM_Upgrade_Form->processSQL("4.3.alpha1")
#13 [internal function](): CRM_Upgrade_Incremental_php_FourThree::task_4_3_x_runSql(Object(CRM_Queue_TaskContext), "4.3.alpha1")
#14 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php(79): call_user_func_array((Array:2), (Array:2))
#15 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php(186): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#16 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php(44): CRM_Queue_Runner->runNext(TRUE)
#17 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php(80): {closure}()
#18 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php(47): CRM_Queue_ErrorPolicy->call(Object(Closure))
#19 [internal function](): CRM_Queue_Page_AJAX::runNext((Array:5))
#20 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(289): call_user_func((Array:2), (Array:5))
#21 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#22 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#23 /var/www/vhosts/thsc.org/securedev/wp-content/plugins/civicrm/civicrm.php(466): CRM_Core_Invoke::invoke((Array:5))
#24 [internal function](): CiviCRM_For_WordPress->invoke("")
#25 /var/www/vhosts/thsc.org/securedev/wp-includes/plugin.php(429): call_user_func_array((Array:2), (Array:1))
#26 /var/www/vhosts/thsc.org/securedev/wp-admin/admin.php(217): do_action("toplevel_page_CiviCRM")
#27 {main}

The upgrade is hanging at 4.3.alpha1.

Could use some pointers to get me past this point.

Thanks,
« Last Edit: February 15, 2014, 10:46:30 pm by jmdezigns »
Interpolat Solutions, LLC
Connecting the dots for you!
http://www.interpolat.com

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Re: Wordpress 4.2.9 Upgrade to 4.4.4 failing
March 06, 2014, 01:00:51 pm
@jmdezigns,

Did you ever succeed with your upgrade?

Shai
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

JohnFF

  • I post frequently
  • ***
  • Posts: 235
  • Karma: 6
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.28
  • MySQL version: 5.5.31-1
  • PHP version: 5.3.27
Re: Wordpress 4.2.9 Upgrade to 4.4.4 failing
March 26, 2014, 05:07:47 am
I've heard it said that you shouldn't do upgrades that skip major versions. So in this case you should have gone to 4.3.something, then 4.4.4.
If you like empowering charities in a free and open way, then you're going to love Civi.

Email Amender: https://civicrm.org/extensions/email-amender
UK Phone Validator: https://civicrm.org/extensions/uk-phone-number-validator
http://civifirst.com
https://twitter.com/civifirst
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Wordpress 4.2.9 Upgrade to 4.4.4 failing

This forum was archived on 2017-11-26.