CRM-6267 Search builder creates "blank"/unnecessary rows for import/exxport mappings

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Won't Fix
    • Affects Version/s: 3.1.4, 3.2
    • Fix Version/s: 4.3.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      Hi,
      On one of our internal sites as well as on the 3.1.x demo and the 3.2 demo, I created a new Smart Group via the search builder using the following criteria:

      Street address IS NOT NULL
      City IS NOT NULL
      State IS NOT NULL
      Postal Code IS NOT NULL
      Country IS NOT NULL

      Here are the results of my testing:
      On all sites the results were the same: the smart group was created along with "blank" import/export mappings. Attempts to delete the mappings result in the following error:
      Sorry. A non-recoverable error has occurred.

      DB Error: constraint violation

      Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails (`afscsandbox_civicrm/civicrm_saved_search`, CONSTRAINT `FK_civicrm_saved_search_mapping_id` FOREIGN KEY (`mapping_id`) REFERENCES `civicrm_mapping` (`id`)), 1451

      To see the "blank" mapping, go to "Administer", "Configure", "Import/Export mappings". I realize why they can't be deleted but I wonder why they are being created in that "table".

      Thanks,
      Cynthia

        Attachments

          Activity

          [CRM-6267] Search builder creates "blank"/unnecessary rows for import/exxport mappings
          Donald A. Lobo added a comment -


          search builder support for "IS NOT NULL" is not complete, IMO. We'll try to take a look at this when time permits. would be great if someone at AFSC can take a look and submit a patch, in which case we can pull it in earlier

          Donald A. Lobo added a comment -

          These 448 issues have not been worked on for the past 18 months.

          Doing a bulk close of old issues to make the issue queue more manageable. We should do this on a periodic basis.

            People

            • Assignee:
              Donald A. Lobo
              Reporter:
              Cynthia Tarascio

              Dates

              • Created:
                Updated:
                Resolved: