CiviCRM Community Forums (archive)

OK, I created profile for membership and I am showing it on the contribution page.
However, right now, when I click Continue on the last-second contribution page I am getting database error:
Sorry. A non-recoverable error has occurred.
DB Error: constraint violation
I have migrated site to another server and I guess it could be the reason of that error.
Before migration I was able to save contribution, all contact details were savad in place but non of membership fields values were saved.
I am happy to move this post to "Professional Services" section where I am hopping to find an expert to get it sorted.
So, I am waiting for your quotes and info if it can be done and/or if not what is the best way to collect custom membership fields on crm

Thanks for your reply,
1. YES
2. YES
3. Unfortunately it doesn't save these details and it generates an error
I am looking for a professional service now so if you want to try do it then please let me know, I can pm you site details and username/login for test
Thank you again

Thanks, but I am working on joomla site

I did check it (first post here)
It is not showing an error but it is not saving these values

Thanks, I hope I'll know where to report this bug
I have to add custom fields and create new profile again as it was cleared since I've done it before.
Thank you

mea culpa, mea culpa, mea maxima culpa,
I have created custom fields and profile again and it is working this time (believe me it didn't then)
It is saving these details there, so the problem is on my side somewhere

Any idea what could I brake down?

Big thank you Kurund again

Hi, I've upgradet to 4.0.5

when I try to confirm contribution I am getting the below error message (I swapped the database and site name with xxxxx):

<div id="crm-container" lang="en" xml:lang="en">
<style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css);</style>
<style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/extras.css);</style>
<script type="text/javascript" src="/administrator/components/com_civicrm/civicrm/js/jquery/jquery.crmaccordions.js"></script>
<div class="messages status"> <div class="icon red-icon alert-icon"></div>
<span class="status-fatal">Sorry. A non-recoverable error has occurred.</span>
<div class="crm-section crm-error-message"></div>
<hr style="solid 1px" />
<div class="crm-section crm-error-message">DB Error: constraint violation</div>
<div class="crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block">
<div class="crm-accordion-header">
<div class="icon crm-accordion-pointer"></div>
Error Details </div><!-- /.crm-accordion-header -->
<div class="crm-accordion-body">
<div class="crm-section">Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`xxxx_xxxx/civicrm_value_school__qualification_details_4`, CONSTRAINT `FK_civicrm_value_school__qualificat_baed7fcbea6e79a4` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` (`id`), 1452</div>
<div class="crm-section">Additional Details: <p><pre>Array
(
[callback] =&gt; Array
(
[0] =&gt; CRM_Core_Error
[1] =&gt; handle
)
[code] =&gt; -3
[message] =&gt; DB Error: constraint violation
[mode] =&gt; 16
[debug_info] =&gt; INSERT INTO civicrm_value_school__qualification_details_4 ( qualification_date_11,student_members_please_state_dat_12,entity_id ) VALUES ( null,null,1 ) ON DUPLICATE KEY UPDATE qualification_date_11 = null,student_members_please_state_dat_12 = null [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xxxxx_xxxxx/civicrm_value_school__qualification_details_4`, CONSTRAINT `FK_civicrm_value_school__qualificat_baed7fcbea6e79a4` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` (`id`)]
[type] =&gt; DB_Error
[user_info] =&gt; INSERT INTO civicrm_value_school__qualification_details_4 ( qualification_date_11,student_members_please_state_dat_12,entity_id ) VALUES ( null,null,1 ) ON DUPLICATE KEY UPDATE qualification_date_11 = null,student_members_please_state_dat_12 = null [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xxxx_xxxx/civicrm_value_school__qualification_details_4`, CONSTRAINT `FK_civicrm_value_school__qualificat_baed7fcbea6e79a4` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` (`id`)]
[to_string] =&gt; [db_error: message=&quot;DB Error: constraint violation&quot; code=-3 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;INSERT INTO civicrm_value_school__qualification_details_4 ( qualification_date_11,student_members_please_state_dat_12,entity_id ) VALUES ( null,null,1 ) ON DUPLICATE KEY UPDATE qualification_date_11 = null,student_members_please_state_dat_12 = null [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xxxx_xxxx/civicrm_value_school__qualification_details_4`, CONSTRAINT `FK_civicrm_value_school__qualificat_baed7fcbea6e79a4` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` (`id`)]&quot;]
)
</pre></p><p></p></div>
</div><!-- /.crm-accordion-body -->
</div><!-- /.crm-accordion-wrapper -->
<p><a href="http://www.xxxxxxx.ie/" title="Main Menu">Return to home page.</a></p>
</div>
</div>
<script type="text/javascript">
cj(function() {
cj().crmaccordions();
});
</script>
Is there anyone who has solved similar problem?
I want to add that I am getting this error only when I am showing on the contribution page two profiles together.
When I have them on to two separate contribution pages it works fine - I mean it saves/collects data without any problem but I can not use two separate contribution pages for renewal my membership because it will renew it twice.