Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 3.1
-
Fix Version/s: 3.1
-
Component/s: Core CiviCRM
-
Labels:None
Description
I created a Joomla! install file and tried to install. Got the fatal error below. Subsequently I dropped the civicrm_ tables and loaded civicrm.mysql and civicrm_data.mysql manually (via phpMyAdmin) - and the schema and data loaded properly. Evidently error is in our sql parser (per lobo).
--------------------------------
Cannot execute INSERT INTO civicrm_msg_template (msg_title, msg_subject, msg_text, msg_html, workflow_id, is_default, is_reserved) VALUES ('Cases - Send Copy of an Activity', '{$activitySubject} ', '===========================================================
{ts}Activity Summary{/ts} - {$activityTypeName} =========================================================== {if $isCaseActivity} {ts}Your Case Role(s)
{/ts}: {$contact.role}
{/if} {foreach from=$activity.fields item=field} {if $field.type eq \'Date\'} {$field.label}{if $field.category}({$field.category}){/if}: {$field.value|crmDate:$config->dateformatDatetime}
{else} {$field.label}{if $field.category}({$field.category}){/if} : {$field.value} {/if} {/foreach} {foreach from=$activity.customGroups key=customGroupName item=customGroup} ========================================================== {$customGroupName} ========================================================== {foreach from=$customGroup item=field} {if $field.type eq \'Date\'} {$field.label} : {$field.value|crmDate:$config->dateformatDatetime} {else}{$field.label} : {$field.value}
{/if}{/foreach}
', '