Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-5370

Joomla Installer failing with fatal SQL error on insert of msg_template data

    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}

      ', '

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 hour
                1h
                Remaining:
                Remaining Estimate - 1 hour
                1h
                Logged:
                Time Spent - Not Specified
                Not Specified