Context : Wordpress 4.9.8–fr_FR, PHP version 7.0.22, libmysql - mysqlnd 5.0
Hello When trying to run the upgrade script from 5.0.1 to 5.4.1, I got this issue :
Aug 31 13:51:25 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] =>
UPDATE civicrm_msg_template SET msg_text = '{assign var=\"greeting\" value=\"{contact.email_greeting}\"}{if $greeting}{$greeting},{/if}\n{if $receipt_text}\n{$receipt_text}\n{/if}\n{if $is_pay_later}\n\n===========================================================\n{$pay_later_receipt}\n===========================================================\n{else}\n\n{ts}Please print this receipt for your records.{/ts}\n{/if}\n\n{if $membership_assign && !$useForMember}\n===========================================================\n{ts}Membership Information{/ts}\n\n===========================================================\n{ts}Membership Type{/ts}: {$membership_name}\n{if $mem_start_date}{ts}Membership Start Date{/ts}: {$mem_start_date|crmDate}\n{/if}\n{if $mem_end_date}{ts}Membership End Date{/ts}: {$mem_end_date|crmDate}\n{/if}\n\n{/if}\n{if $amount}\n===========================================================\n{ts}Membership Fee{/ts}\n\n===========================================================\n{if !$useForMember && $membership_amount && $is_quick_config}\n{ts 1=$membership_name}%1 Membership{/ts}: {$membership_amount|crmMoney}\n{if $amount && !$is_separate_payment }\n{ts}Contribution Amount{/ts}: {$amount|crmMoney}\n-------------------------------------------\n{ts}Total{/ts}: {$amount+$membership_amount|crmMoney}\n{/if}\n{elseif !$useForMember && $lineItem and $priceSetID & !$is_quick_config}\n{foreach from=$lineItem item=value key=priceset}\n---------------------------------------------------------\n{capture assign=ts_item}{ts}Item{/ts}{/capture}\n{capture assign=ts_qty}{ts}Qty{/ts}{/capture}\n{capture assign=ts_each}{ts}Each{/ts}{/capture}\n{capture assign=ts_total}{ts}Total{/ts}{/capture}\n{$ts_item|string_format:\"%-30s\"} {$ts_qty|string_format:\"%5s\"} {$ts_each|string_format:\"%10s\"} {$ts_total|string_format:\"%10s\"}\n----------------------------------------------------------\n{foreach from=$value item=line}\n{$line.description|truncate:30:\"...\"|string_format:\"%-30s\"} {$line.qty|string_format:\"%5s\"} ... \n{/foreach}\n{/if}\n' WHERE id IN () [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1]"]
)
Aug 31 13:51:25 [info] $backTrace = #0 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(232): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: syntax error", -2, 16, (Array:2), "\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...")
#3 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(575): DB_Error->__construct(-2, 16, (Array:2), "\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...")
#4 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -2, 16, (Array:2), "\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...", "DB_Error", TRUE)
#5 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-2, NULL, NULL, "\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...", "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...")
#9 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common->query("\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...")
#10 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...")
#11 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query("\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...")
#12 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1394): CRM_Core_DAO->query("\n UPDATE civicrm_msg_template SET msg_text = '{assign var=\\"greeting...", TRUE)
#13 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/MessageTemplates.php(149): CRM_Core_DAO::executeQuery("\n UPDATE civicrm_msg_template SET msg_text = %1 WHERE id IN ()", (Array:1))
#14 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/General.php(143): CRM_Upgrade_Incremental_MessageTemplates->updateTemplates()
#15 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php(772): CRM_Upgrade_Incremental_General::updateMessageTemplate("<br />Les exemplaires par défaut des modèles de message répertoriés ci-dessou...", "5.4.alpha1")
#16 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(111): CRM_Upgrade_Form->setPreUpgradeMessage("<br />Les exemplaires par défaut des modèles de message répertoriés ci-dessou...", "5.0.1", "5.4.1")
#17 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(73): CRM_Upgrade_Page_Upgrade->runIntro()
#18 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(309): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#19 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#20 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#21 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm.php(1246): CRM_Core_Invoke::invoke((Array:2))
#22 /var/www/html/civicrm/wp-includes/class-wp-hook.php(286): CiviCRM_For_WordPress->invoke("")
#23 /var/www/html/civicrm/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
#24 /var/www/html/civicrm/wp-includes/plugin.php(453): WP_Hook->do_action((Array:1))
#25 /var/www/html/civicrm/wp-admin/admin.php(224): do_action("toplevel_page_CiviCRM")
#26 {main}
I really don't know how to move forward and run the upgrade script. Any help will be kindly accepted Thanks