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

Column name change civicrm_mailing.visibility not reflected in views - breaks multilingual

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.4.alpha
    • Fix Version/s: 3.4.beta
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      column rename in upgrade script does not change definition of multilingual views based on the column resuting in a broken view (symptom is that the database fails to backup as it fails on that view)

      From script:

      {if $renameColumnVisibility}

      ALTER TABLE `civicrm_mailing` CHANGE `visibilty` `visibility` ENUM( 'User and User Admin Only', 'Public Pages' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'User and User Admin Only' COMMENT 'In what context(s) is the mailing contents visible (online viewing)';

      {/if}

        Attachments

          Activity

            People

            • Assignee:
              eileen Eileen McNaughton
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: