CiviCRM Community Forums (archive)

I wish to delete an import/export mapping from "CiviCRM » Administer CiviCRM » Import/Export Mappings" but am getting the following:

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

How do I identify (and delete) the saved search that appears to be causing the problem?

I can get the mapping ID from the civicrm_mapping table, and I can see which civicrm_saved_search uses that mapping ID... but the only thing in the civicrm_saved_search record that looks like it might point to something in civicrm_group is the form_values field, which contains:

a:7:{s:5:"qfKey";s:32:"bb7aea1caf174fd24747f9ce19cf04c6";s:6:"mapper";a:2:{i:1;a:1:{i:0;a:2:{i:0;s:10:"Individual";i:1;s:9:"custom_50";}}i:2;a:1:{i:0;a:1:{i:0;s:0:"";}}}s:8:"operator";a:2:{i:1;a:1:{i:0;s:11:"IS NOT NULL";}i:2;a:1:{i:0;s:0:"";}}s:5:"value";a:2:{i:1;a:1:{i:0;s:0:"";}i:2;a:1:{i:0;s:0:"";}}s:4:"task";s:2:"13";s:8:"radio_ts";s:6:"ts_all";s:11:"uf_group_id";s:0:"";}

Needless to say, I don't know how to decode this ;-)

I will want to keep the smart group that's using the mapping for the search, but "decouple" it from the mapping (so I can delete it).

Yes, I used search builder to create a smart group (so yes I want to keep the smart group).

I then selected the "export" option from the smart group results and selected the option to create an export mapping.  It was just a test, to see what the exported results would look like.  It is this mapping -- appropriately named "Test_Export" -- that I now want to delete (i.e. as if I had never elected to export the results of my smart group search).

FWIW, here are the error details when I try to delete the mapping from "CiviCRM » Administer CiviCRM » Import/Export Mappings"

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    [ code] => -3
    

[message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_mapping  WHERE (  civicrm_mapping.id = 5 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`conservative_demo/civicrm_saved_search`, CONSTRAINT `FK_civicrm_saved_search_mapping_id` FOREIGN KEY (`mapping_id`) REFERENCES `civicrm_mapping` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_mapping  WHERE (  civicrm_mapping.id = 5 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`conservative_demo/civicrm_saved_search`, CONSTRAINT `FK_civicrm_saved_search_mapping_id` FOREIGN KEY (`mapping_id`) REFERENCES `civicrm_mapping` (`id`))]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_mapping  WHERE (  civicrm_mapping.id = 5 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`conservative_demo/civicrm_saved_search`, CONSTRAINT `FK_civicrm_saved_search_mapping_id` FOREIGN KEY (`mapping_id`) REFERENCES `civicrm_mapping` (`id`))]"]
)

you created that mapping when u did a test export from a search builder type saved search, right?

I'm not very sure why saved_search has an FK to your export mapping, and seems like it is a bug there. If important to you, please consider investigating and finding out what is happening and why. Ping us on IRC if u need help getting started

lobo