CiviCRM Community Forums (archive)

Hello Civifans,

I just tried an upgrade from 4.3.5 to 4.4.4 and got the following error message. I understand the issue, just not sure what might be causing it and how I can stop it from occurring next time I try upgrading!

thanks,

welly


[Error: Migrate custom word-replacements]
CiviCRM_API3_Exception: "Value for find_word is 289 characters - This field has a maxlength of 255 characters."

#0 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourFour.php(545): civicrm_api3("word_replacement", "replace", (Array:2))
#1 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourFour.php(420): CRM_Upgrade_Incremental_php_FourFour::rebuildWordReplacementTable()
#2 [internal function](): CRM_Upgrade_Incremental_php_FourFour::wordReplacements(Object(CRM_Queue_TaskContext))
#3 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Queue/Task.php(79): call_user_func_array((Array:2), (Array:1))
#4 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Queue/Runner.php(186): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#5 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(44): CRM_Queue_Runner->runNext(TRUE)
#6 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(80): {closure}()
#7 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(47): CRM_Queue_ErrorPolicy->call(Object(Closure))
#8 [internal function](): CRM_Queue_Page_AJAX::runNext((Array:5))
#9 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(289): call_user_func((Array:2), (Array:5))
#10 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#11 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#12 /var/www/vhosts/endometriosis-uk.org/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:5))
#13 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#14 /var/www/vhosts/endometriosis-uk.org/httpdocs/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:4))
#15 /var/www/vhosts/endometriosis-uk.org/httpdocs/index.php(21): menu_execute_active_handler()
#16 {main}

I ran into this exact error.  Asumming that my word replacements were too long I reduced the number of characters to well below 255 and tried the upgrade again.  It still failed.

I filed this issue: http://issues.civicrm.org/jira/browse/CRM-14224

My workaround (which I will try next week) is to REMOVE all word replacements prior to upgrade and then copy and paste them back in once it's done.  Hope this works.