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

DB Error on creating Smart Group with Is Empty and/or Not Empty operators via search builder

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.4.1
    • Fix Version/s: 4.5
    • Component/s: None
    • Labels:

      Description

      Steps to reproduce the issue:
      1) Go to Search Builder and use EMPTY and/or NOT EMPTY operator on any the attribute w/o search fields then click 'Search'.
      2) Select contacts and choose 'New Smart Group' action
      3) Give title to Smart group and then submit.

      DB Error: unknown error
      Database Error Code: Data truncated for column 'operator' at row 1, 1265

      Issue is occurring because we are trying to insert 'IS NOT EMPTY' or 'IS EMPTY' value for operator column of civicrm_mapping_field. Since 'operator' column is of type enum doesn't have the entry for these two operator so it result into this error.

        Attachments

          Activity

            People

            • Assignee:
              gautam.buddadev Gautam Buddadev
              Reporter:
              monish.deb Monish Deb
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: