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

Search builder export crashed when using not null operator

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 4.4.6
    • Fix Version/s: 4.4.7
    • Component/s: None
    • Labels:
      None
    • Documentation Required?:
      None

      Description

      SQL error due to enum definition not including the IS NULL & IS NOT NULL operators

      [debug_info] => INSERT INTO civicrm_mapping_field (mapping_id , name , contact_type , column_number , grouping , operator , value ) VALUES ( 544 , 'membership_status' , 'Membership' , 0 , 1 , 'IS NOT NULL' , '' ) [nativecode=1265 ** Data truncated for column 'operator' at row 1]
      [type] => DB_Error

      Note the commit for this can be merged into 4.5 without doing any damage as it is in the 4.4.7 upgrade file & later changes to the operator field (converting it to a 16 char varchar will still take place

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: