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

When length of custom field increased, length of corresponding field in logs not increased

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.4.6
    • Fix Version/s: 4.6.16
    • Component/s: None
    • Labels:
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      I recently had to increase the length of a custom field. On the actual table holding the custom field, it correctly went from VARCHAR(255) to VARCHAR(510). The length was not automatically changed in the corresponding log table, which remained at 255, requiring an ALTER TABLE command.

      This represents a possible loss of future log data if data long enough to require the increased length is then entered without manually making the change to the log table.

      Fixing this only applies to increases. If a field is decreased in length we probably don't want to reflect that in the log as it could truncate existing log data.

      Also, in my case the field in question was a multiple-choice set of checkboxes with an option group. I found it a bit odd that the text length of the field was an option in this case.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              DaveFF David Knoll
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: