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

participant.fee_level text truncated at 255 characters

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.2.7
    • Fix Version/s: 3.1
    • Component/s: CiviEvent
    • Labels:
      None

      Description

      If an event's price set has many options, the values will be truncated when stored in teh participant table, once the concatenated values reaches 255 characters in length. It is not critical, but the values will not be included in participant export files.

      Suggested to increase the varchar(255) field length to a text field:

      alter table civicrm_participant modify column fee_level text collate utf8_unicode_ci default NULL COMMENT 'Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that we store the label value and not the key';

      This may also be required in the contribution field, or other tables not known.

        Attachments

          Activity

            People

            • Assignee:
              sushant Sushant Paste
              Reporter:
              gnott Graham Nott
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 30 minutes
                30m
                Remaining:
                Remaining Estimate - 30 minutes
                30m
                Logged:
                Time Spent - Not Specified
                Not Specified