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

civicrm_note.privacy should be varchar

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.4.8
    • Fix Version/s: 4.1.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      This column is an implicit foreign key to civicrm_option_value.value, which has a data type of varchar(512). It's possible to create, within the GUI, an option value for the group note_privacy that has a string value, and although this string value is properly included in the "Privacy" select list when editing/creating a note, it can't be saved properly because civicrm_note.privacy currently has a data type of int(10).

      This patch intends to change the data type of this field to varchar(512). I'm not sure if just changing this file is enough, though. Should I also be patching somewhere else?

        Attachments

          Activity

            People

            • Assignee:
              deepak Deepak Srivastava
              Reporter:
              allenshaw Allen Shaw
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: