CiviCRM Community Forums (archive)

I am getting these DB Error: constraint violation errors throughout the site.

Complete a contribution page.
Merge/Dedupe
Import contacts or memberships

Any idea's or help would be greatly appreciated.

This when trying to submit a contribution. (does this both with and without a coupon)

[code]backTrace
#0 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 E:\Websites\MCWT-2\modules\civicrm\packages\PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 E:\Websites\MCWT-2\modules\civicrm\packages\DB.php(969): PEAR_Error->PEAR_Error("DB Error: constraint violation", -3, 16, (Array:2), "INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , ...")
#4 E:\Websites\MCWT-2\modules\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-3, 16, (Array:2), "INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , ...")
#5 E:\Websites\MCWT-2\modules\civicrm\packages\DB\common.php(1905): PEAR->raiseError(NULL, -3, NULL, NULL, "INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , ...", "DB_Error", TRUE)
#6 E:\Websites\MCWT-2\modules\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-3, NULL, NULL, NULL, "1452 ** Cannot add or update a child row: a foreign key constraint fails (`ci...")
#7 E:\Websites\MCWT-2\modules\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#8 E:\Websites\MCWT-2\modules\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , ...")
#9 E:\Websites\MCWT-2\modules\civicrm\packages\DB\DataObject.php(2421): DB_common->query("INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , ...")
#10 E:\Websites\MCWT-2\modules\civicrm\packages\DB\DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , ...")
#11 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\DAO.php(287): DB_DataObject->insert()
#12 E:\Websites\MCWT-2\modules\civicrm\CRM\Member\BAO\MembershipLog.php(52): CRM_Core_DAO->save()
#13 E:\Websites\MCWT-2\modules\civicrm\CRM\Member\BAO\Membership.php(133): CRM_Member_BAO_MembershipLog::add((Array:8), (Array:0))
#14 E:\Websites\MCWT-2\modules\civicrm\CRM\Member\BAO\Membership.php(307): CRM_Member_BAO_Membership::add((Array:15), (Array:1))
#15 E:\Websites\MCWT-2\modules\civicrm\CRM\Member\BAO\Membership.php(1744): CRM_Member_BAO_Membership::create((Array:15), (Array:1), FALSE, "Membership Signup")
#16 E:\Websites\MCWT-2\modules\civicrm\CRM\Member\BAO\Membership.php(1343): CRM_Member_BAO_Membership::renewMembership("2", "1", FALSE, Object(CRM_Contribute_Form_Contribution_Confirm), NULL, "2", (Array:0), 1)
#17 E:\Websites\MCWT-2\modules\civicrm\CRM\Contribute\Form\Contribution\Confirm.php(931): CRM_Member_BAO_Membership::postProcessMembership((Array:59), "2", Object(CRM_Contribute_Form_Contribution_Confirm), (Array:47), (Array:0), (Array:0))
#18 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Form.php(246): CRM_Contribute_Form_Contribution_Confirm->postProcess()
#19 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\StateMachine.php(160): CRM_Core_Form->mainProcess()
#20 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\QuickForm\Action\Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next", "Next")
#21 E:\Websites\MCWT-2\modules\civicrm\packages\HTML\QuickForm\Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next")
#22 E:\Websites\MCWT-2\modules\civicrm\packages\HTML\QuickForm\Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution_Confirm), "next")
#23 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Controller.php(316): HTML_QuickForm_Page->handle("next")
#24 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Invoke.php(292): CRM_Core_Controller->run((Array:3), NULL)
#25 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Invoke.php(70): CRM_Core_Invoke::runItem((Array:15))
#26 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#27 E:\Websites\MCWT-2\modules\civicrm\drupal\civicrm.module(436): CRM_Core_Invoke::invoke((Array:3))
#28 [internal function](): civicrm_invoke("contribute", "transact")
#29 E:\Websites\MCWT-2\includes\menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#30 E:\Websites\MCWT-2\index.php(21): menu_execute_active_handler()
#31 {main}
Sorry but we are not able to provide this at the moment.
________________________________________
DB Error: constraint violation
Error Details
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_membership_id` FOREIGN KEY (`membership_id`) REFERENCES `civicrm_membership_donotuse` (`id`) ON DELETE CASCADE), 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_membership_log (membership_id , status_id , start_date , end_date , modified_id , modified_date ) VALUES ( 0 ,  1 ,  20140120 ,  20150119 ,  2 ,  20140120 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_membership_id` FOREIGN KEY (`membership_id`) REFERENCES `civicrm_membership_donotuse` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , end_date , modified_id , modified_date ) VALUES ( 0 ,  1 ,  20140120 ,  20150119 ,  2 ,  20140120 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_membership_id` FOREIGN KEY (`membership_id`) REFERENCES `civicrm_membership_donotuse` (`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_membership_log (membership_id , status_id , start_date , end_date , modified_id , modified_date ) VALUES ( 0 ,  1 ,  20140120 ,  20150119 ,  2 ,  20140120 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_membership_id` FOREIGN KEY (`membership_id`) REFERENCES `civicrm_membership_donotuse` (`id`) ON DELETE CASCADE)]"]

This during a dedupe by email address

backTrace

#0 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 E:\Websites\MCWT-2\modules\civicrm\packages\PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 E:\Websites\MCWT-2\modules\civicrm\packages\DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...")
#4 E:\Websites\MCWT-2\modules\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...")
#5 E:\Websites\MCWT-2\modules\civicrm\packages\DB\common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...", "DB_Error", TRUE)
#6 E:\Websites\MCWT-2\modules\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "2006 ** MySQL server has gone away")
#7 E:\Websites\MCWT-2\modules\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#8 E:\Websites\MCWT-2\modules\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...")
#9 E:\Websites\MCWT-2\modules\civicrm\packages\DB\DataObject.php(2421): DB_common->query("INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...")
#10 E:\Websites\MCWT-2\modules\civicrm\packages\DB\DataObject.php(1613): DB_DataObject->_query("INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...")
#11 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\DAO.php(155): DB_DataObject->query("INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...")
#12 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\DAO.php(917): CRM_Core_DAO->query("INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...", TRUE)
#13 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\BAO\PrevNextCache.php(182): CRM_Core_DAO::executeQuery("INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, ca...")
#14 E:\Websites\MCWT-2\modules\civicrm\CRM\Contact\Page\DedupeFind.php(276): CRM_Core_BAO_PrevNextCache::setItem((Array:8295))
#15 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Invoke.php(292): CRM_Contact_Page_DedupeFind->run((Array:3), NULL)
#16 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#17 E:\Websites\MCWT-2\modules\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#18 E:\Websites\MCWT-2\modules\civicrm\drupal\civicrm.module(436): CRM_Core_Invoke::invoke((Array:3))
#19 [internal function](): civicrm_invoke("contact", "dedupefind")
#20 E:\Websites\MCWT-2\includes\menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#21 E:\Websites\MCWT-2\index.php(21): menu_execute_active_handler()
#22 {main}

Sorry but we are not able to provide this at the moment.
DB Error: unknown error
Error Details
Database Error Code: MySQL server has gone away, 2006
Additional Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, cacheKey, data ) VALUES
 ( 'civicrm_contact', 2, 149, 'merge Individual_4_0', 'a:6:{s:5:\"srcID\";s:1:\"2\";s:7:\"srcName\";s:15:\"NAme\";s:5:\"dstID\";s:3:\"149\";s:7:\"dstName\";s:11:\"Name\";s:6:\"weight\";s:2:\"10\";s:8:\"canMerge\";b:1;}' ) ,

That was it for the contributions! thanks! Apparently someone (me) tried to dedup the membership database on the sql side and messed it up...

Any ideas for the merge/dedupe error?

No, that was it... except for that one table I deleted.... no just kidding, that was it