CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • DB Error when creating new membership for a contact
Pages: [1]

Author Topic: DB Error when creating new membership for a contact  (Read 448 times)

nant

  • I post frequently
  • ***
  • Posts: 143
  • Karma: 4
    • Joomlapolis
  • CiviCRM version: 4.3.4
  • CMS version: Joomla 2.5.11
  • MySQL version: 5
  • PHP version: 5.3
DB Error when creating new membership for a contact
May 19, 2014, 07:08:06 am
I have just been getting an error every time I try to add a membership to any contact.

With debug on I am getting:

Code: [Select]
May 19 13:46:32  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id , financial_type_id ) VALUES ('civicrm_contribution' ,  1228 ,  3 , 'ΜΕΛΟΣ ΔΗΞΑ' ,  1 ,  10.00 ,  10 ,  0 ,  3 ,  2 )  [nativecode=1062 ** Duplicate entry 'civicrm_contribution-1228-3-3' for key 'UI_line_item_value']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id , financial_type_id ) VALUES ('civicrm_contribution' ,  1228 ,  3 , 'ΜΕΛΟΣ ΔΗΞΑ' ,  1 ,  10.00 ,  10 ,  0 ,  3 ,  2 )  [nativecode=1062 ** Duplicate entry 'civicrm_contribution-1228-3-3' for key 'UI_line_item_value']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id , financial_type_id ) VALUES ('civicrm_contribution' ,  1228 ,  3 , 'ΜΕΛΟΣ ΔΗΞΑ' ,  1 ,  10.00 ,  10 ,  0 ,  3 ,  2 )  [nativecode=1062 ** Duplicate entry 'civicrm_contribution-1228-3-3' for key 'UI_line_item_value']"]
)


May 19 13:46:32  [info] $backTrace = #0 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: already exists", -5, 16, (Array:2), "INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#4 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-5, 16, (Array:2), "INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#5 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -5, NULL, NULL, "INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...", "DB_Error", TRUE)
#6 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-5, NULL, NULL, NULL, "1062 ** Duplicate entry 'civicrm_contribution-1228-3-3' for key 'UI_line_item...")
#7 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#9 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#10 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#11 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
#12 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Price/BAO/LineItem.php(65): CRM_Core_DAO->save()
#13 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Price/BAO/LineItem.php(292): CRM_Price_BAO_LineItem::create((Array:17))
#14 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(2791): CRM_Price_BAO_LineItem::processPriceSet("1228", (Array:1), Object(CRM_Contribute_BAO_Contribution), "civicrm_contribution", TRUE)
#15 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(178): CRM_Contribute_BAO_Contribution::recordFinancialAccounts((Array:25), (Array:3))
#16 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(266): CRM_Contribute_BAO_Contribution::add((Array:25), (Array:3))
#17 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Member/BAO/Membership.php(2678): CRM_Contribute_BAO_Contribution::create((Array:25), (Array:3))
#18 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Member/BAO/Membership.php(332): CRM_Member_BAO_Membership::recordMembershipContribution((Array:26), (Array:3), "1044")
#19 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Member/Form/Membership.php(1592): CRM_Member_BAO_Membership::create((Array:26), (Array:3))
#20 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(246): CRM_Member_Form_Membership->postProcess()
#21 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(151): CRM_Core_Form->mainProcess()
#22 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Member_Form_Membership), "upload")
#23 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Member_Form_Membership), "upload")
#24 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Member_Form_Membership), "upload")
#25 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("upload")
#26 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Member/Page/Tab.php(245): CRM_Core_Controller->run()
#27 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Member/Page/Tab.php(309): CRM_Member_Page_Tab->edit()
#28 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(292): CRM_Member_Page_Tab->run((Array:4), NULL)
#29 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:14))
#30 /home/dimiourg/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#31 /home/dimiourg/public_html/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:4))
#32 /home/dimiourg/public_html/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#33 /home/dimiourg/public_html/libraries/joomla/application/component/helper.php(380): require_once("/home/dimiourg/public_html/administrator/components/com_civicrm/admin.civicrm...")
#34 /home/dimiourg/public_html/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent("/home/dimiourg/public_html/administrator/components/com_civicrm/admin.civicrm...")
#35 /home/dimiourg/public_html/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#36 /home/dimiourg/public_html/administrator/index.php(46): JAdministrator->dispatch()
#37 {main}


Any clue on what the issue/cause is ?
--
Nick (aka nant from CB Team)

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: DB Error when creating new membership for a contact
May 29, 2014, 03:06:15 pm
Definitely something wrong with the price set associated with that membership.  Try creating a membership type named "test" with no price set associated with that membership type.  Add that membership to a contact.  If necessary try re-creating the prices sets to determine when the break occurs.
Try CiviTeacher: the online video tutorial CiviCRM learning library.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • DB Error when creating new membership for a contact

This forum was archived on 2017-11-26.