DB Error: constraint violation when I try to add profiles to contribution page

Question

I cannot seem to enable profiles on contribution pages. There are no drop-down menus for including profiles, and when I try to type in an existing profile, I get a page with "DB: error: constraint violation." What am I missing? (I am using CiviCRM 4.6.3 on Wordpress 4.2.2.)

Update: Here is a screenshot of the page:

Update:Here is the error/backtrace:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (rpwrhsor_civicrm.civicrm_uf_join, CONSTRAINT FK_civicrm_uf_join_uf_group_id FOREIGN KEY (uf_group_id) REFERENCES civicrm_uf_group (id)), 1452 Additional Details: Array ( [callback] => Array ( [0] => CRM_Core_Error 1 => handle )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_uf_join (is_active , module , entity_table , entity_id , weight , uf_group_id ) VALUES ( 1 , 'CiviContribute' , 'civicrm_contribution_page' ,  3 ,  2 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rpwrhsor_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_uf_join (is_active , module , entity_table , entity_id , weight , uf_group_id ) VALUES ( 1 , 'CiviContribute' , 'civicrm_contribution_page' ,  3 ,  2 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rpwrhsor_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_join (is_active , module , entity_table , entity_id , weight , uf_group_id ) VALUES ( 1 , 'CiviContribute' , 'civicrm_contribution_page' ,  3 ,  2 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`rpwrhsor_civicrm`.`civicrm_uf_join`, CONSTRAINT `FK_civicrm_uf_join_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`))]"]

)

Answer 1

1. Can you compare your screen with this page:

http://wp46.demo.civicrm.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/contribute/custom&reset=1&action=update&id=2

(you will need to login as demo / demo)

2. I suspect its not the same, and most likely there are some javascript errors occuring on your site. You should check the js console when you load the page

3. Seems like the values submitted (i.e. a 0 for uf_group_id) is not expected and hence u get the mysql error

Answer 2

I'm currently running into the same issues, which a check on the js console reveals is caused by javascript errors.

The error message reads as follows:

JQMIGRATE: Migrate is installed, version 1.4.1 
crm.designerapp.js?r=uMjIi:11 Uncaught TypeError: Cannot read property 'Application' of undefined
at HTMLDocument.<anonymous> (crm.designerapp.js?r=uMjIi:11)
at j (jquery.js:3148)
at Object.fireWith [as resolveWith] (jquery.js:3260)
at Function.ready (jquery.js:3472)
at HTMLDocument.J (jquery.js:3503)
backbone.collectionsubset.js?r=uMjIi:225 Uncaught TypeError: Backbone.CollectionSubset is not a constructor at child.Backbone.Collection.subcollection (backbone.collectionsubset.js?r=uMjIi:225)
at HTMLInputElement.<anonymous> (jquery.crmProfileSelector.js?r=uMjIi:34)
at Function.each (jquery.js:384)
at m.fn.init.each (jquery.js:136)
at m.fn.init.$.fn.crmProfileSelector (jquery.crmProfileSelector.js?r=uMjIi:25)
at HTMLInputElement.<anonymous> (jquery.crmProfileSelector.js?r=uMjIi:89)
at Function.each (jquery.js:384)
at m.fn.init.each (jquery.js:136)
at HTMLDivElement.<anonymous> (jquery.crmProfileSelector.js?r=uMjIi:88)
at HTMLDivElement.dispatch (jquery.js:4670)

Any advice on resolving these errors?

Answer 3

It's likely a problem/conflict with the javascript from another module.

From this thread on our old forum: https://forum.civicrm.org/index.php?topic=35079.msg149115#msg149115

might be "Jetpack". Try to disable it to see what's happening.

In general: disable the other modules until you find the one that conflicts with civi