CiviCRM Community Forums (archive)

Hi Everyone

I am trying to run the import of all the custom fields and profiles that come with the giftaid module for CiviCRM and i have got an error message that im not sure how to solve. It only seems to have a problem pulling over the Cusatom Profile, not the individual fields. All of the custom fields imported perfectly but if fails on the custom profile with this error:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('custom_7' ,  1 ,  0 ,  1 ,  1 , '<p>By selecting \'Yes\' above you are confirming that\n<ol>\n<li>you are a UK taxpayer and</li>\n<li>the amount of income and/or capital gains tax you pay is at least as much as we will reclaim on your donations in this tax year.</li>\n</ol>\n<p><b>About Gift Aid</b><p>\n<p>Gift Aid increases the value of donations to charities by allowing them to reclaim basic rate tax on your gift.  We would like to reclaim gift aid on your behalf.  We can only reclaim Gift Aid if you are a UK taxpayer.  Please confirm that you are a eligible for gift aid above.  <a href=\"http://www.hmrc.gov.uk/individuals/giving/gift-aid.htm\">More about Gift Aid</a>.</p>' , 'User and User Admin Only' ,  0 ,  0 , 'Can we reclaim gift aid on your donation?' , 'Contribution' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('custom_7' ,  1 ,  0 ,  1 ,  1 , '<p>By selecting \'Yes\' above you are confirming that\n<ol>\n<li>you are a UK taxpayer and</li>\n<li>the amount of income and/or capital gains tax you pay is at least as much as we will reclaim on your donations in this tax year.</li>\n</ol>\n<p><b>About Gift Aid</b><p>\n<p>Gift Aid increases the value of donations to charities by allowing them to reclaim basic rate tax on your gift.  We would like to reclaim gift aid on your behalf.  We can only reclaim Gift Aid if you are a UK taxpayer.  Please confirm that you are a eligible for gift aid above.  <a href=\"http://www.hmrc.gov.uk/individuals/giving/gift-aid.htm\">More about Gift Aid</a>.</p>' , 'User and User Admin Only' ,  0 ,  0 , 'Can we reclaim gift aid on your donation?' , 'Contribution' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('custom_7' ,  1 ,  0 ,  1 ,  1 , '<p>By selecting \'Yes\' above you are confirming that\n<ol>\n<li>you are a UK taxpayer and</li>\n<li>the amount of income and/or capital gains tax you pay is at least as much as we will reclaim on your donations in this tax year.</li>\n</ol>\n<p><b>About Gift Aid</b><p>\n<p>Gift Aid increases the value of donations to charities by allowing them to reclaim basic rate tax on your gift.  We would like to reclaim gift aid on your behalf.  We can only reclaim Gift Aid if you are a UK taxpayer.  Please confirm that you are a eligible for gift aid above.  <a href=\"http://www.hmrc.gov.uk/individuals/giving/gift-aid.htm\">More about Gift Aid</a>.</p>' , 'User and User Admin Only' ,  0 ,  0 , 'Can we reclaim gift aid on your donation?' , 'Contribution' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]"]
)


Ideas anyone?

Chelcone

I must have made a mistake on the install because i reinstalled and it worked fine. Human error!

Thanks anyway