CiviCRM Community Forums (archive)

We use Drupal 6 and after we upgraded to 4.15, anonymous users got an error when trying to register for an event:

Sorry. A non-recoverable error has occurred.

DB Error: Constraint violation

Please see the screen capture below:

http://screencast.com/t/peA8Pcal

Any advice, please?

Thanks a lot!

I enabled debugging and clicked Save. I got a blank page. Then I ran these two:

// Example URL
http://...../?q=civicrm/admin&sessionReset=2
 
// Example with Clean URLs
http://...../civicrm/admin?sessionReset=2

I still got blank page respectively.

I checked the error log on our server. Here are a few of them:

[Mon Jul 16 15:09:51 2012] [error] [Mon Jul 16 15:09:51 2012] [error] [client] Directory index forbidden by Options directive: /var/www/vhosts/mysite.com/httpdocs/learnersvoice/wp-content/themes/Chameleon/epanel/shortcodes/js/, referer: http://mysite:80/learnersvoice
[Mon Jul 16 15:24:37 2012] [error] [client ] Directory index forbidden by Options directive: /var/www/vhosts/mysite.com/httpdocs/sites/default/, referer: https://www.assessment.com:443/resources/
[Mon Jul 16 15:24:37 2012] [error] [client] Directory index forbidden by Options directive: /var/www/vhosts/mysite.com/httpdocs/sites/default/, referer: https://www.assessment.com:443/resources/
[Mon Jul 16 16:04:48 2012] [warn] mod_fcgid: stderr: PHP Warning: curl_setopt() [<a href='function.curl-setopt'>function.curl-setopt</a>]: CURLOPT_FOLLOWLOCATION cannot be activated when safe_mode is enabled or an open_basedir is set in /var/www/vhosts/mysite.com/httpdocs/learnersvoice/wp-content/plugins/wp-stats-dashboard/classes/util/metrics/WPSDStats.php on line 270
[Mon Jul 16 16:21:32 2012] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request function
[Mon Jul 16 16:31:55 2012] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request function Directory index forbidden by Options directive: /var/www/vhosts/www.mysite.com/httpdocs/learnersvoice/wp-content/themes/Chameleon/epanel/shortcodes/js/, referer: http://mysite.com:80/learnersvoice
[Mon Jul 16 15:24:37 2012] [error] [client ] Directory index forbidden by Options directive: /var/www/vhosts/mysite.com/httpdocs/sites/default/, referer: https://www.assessment.com:443/resources/
[Mon Jul 16 15:24:37 2012] [error] [client ] Directory index forbidden by Options directive: /var/www/vhosts/mysite.com/httpdocs/sites/default/, referer: https://www.assessment.com:443/resources/
[Mon Jul 16 16:04:48 2012] [warn] mod_fcgid: stderr: PHP Warning: curl_setopt() [<a href='function.curl-setopt'>function.curl-setopt</a>]: CURLOPT_FOLLOWLOCATION cannot be activated when safe_mode is enabled or an open_basedir is set in /var/www/vhosts/mysite.com/httpdocs/learnersvoice/wp-content/plugins/wp-stats-dashboard/classes/util/metrics/WPSDStats.php on line 270
[Mon Jul 16 16:21:32 2012] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request function
[Mon Jul 16 16:31:55 2012] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request function

Thanks a lot for your help!!

I do not see in there what is causing a blank page.

Perhaps consider removing sites/default/civicrm.settings.php, then re-installing into a fresh DB, insure that CiviCRM 4.1.5 runs OK and then edit your new civicrm.settings.php to point to the old DB and see what happens.

I'm not sure what the issue is so we must debug it...

No that doesn't look like it. Did you enable debugging in CiviCRM?

Error Details:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`cetlcrm`.`civicrm_value_fall_teaching_kick_off_10`, CONSTRAINT `FK_civicrm_value_fall_teaching_kick_d0794b3f0fedefbc` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELE), 1452
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_fall_teaching_kick_off_10  ( please_check_off_all_the_session_16,entity_id ) VALUES ( '
kick_off_1
',3743 ) ON DUPLICATE KEY UPDATE please_check_off_all_the_session_16 = '
kick_off_1
' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cetlcrm`.`civicrm_value_fall_teaching_kick_off_10`, CONSTRAINT `FK_civicrm_value_fall_teaching_kick_d0794b3f0fedefbc` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_fall_teaching_kick_off_10  ( please_check_off_all_the_session_16,entity_id ) VALUES ( '
kick_off_1
',3743 ) ON DUPLICATE KEY UPDATE please_check_off_all_the_session_16 = '
kick_off_1
' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cetlcrm`.`civicrm_value_fall_teaching_kick_off_10`, CONSTRAINT `FK_civicrm_value_fall_teaching_kick_d0794b3f0fedefbc` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_fall_teaching_kick_off_10  ( please_check_off_all_the_session_16,entity_id ) VALUES ( '
kick_off_1
',3743 ) ON DUPLICATE KEY UPDATE please_check_off_all_the_session_16 = '
kick_off_1
' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cetlcrm`.`civicrm_value_fall_teaching_kick_off_10`, CONSTRAINT `FK_civicrm_value_fall_teaching_kick_d0794b3f0fedefbc` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_participant` (`id`) ON DELE)]"]
)

most likely that custom group changed from extending event to extending participant. There was a bug in a prior version of civicrm which did not fix the correspnding FK

Your best bet might be to create a new custom table that extends participant and use those fields for that event

lobo