CiviCRM Community Forums (archive)

In the back-offfice, the end-user sometimes have the need to edit the "non_deductible_amount" field for existing contributions. This works fine for cash and check contributions, but its read only for credit card contributions.

To allow editing for credit card contributions, I edited the file "CRM/Contribute/Form/AdditionalInfo.php" and commented out line #108. ( I am using CiviCRM version 4.3.

This appears to work at a glance, ie the field is editable for the end-user for credit card contributions.  However when they click "save" they get the following SQL error message:


#0 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/bnai2/public_html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/bnai2/public_html/sites/all/modules/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/bnai2/public_html/sites/all/modules/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/bnai2/public_html/sites/all/modules/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/bnai2/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-5, NULL, NULL, NULL, "1062 ** Duplicate entry 'civicrm_contribution-211-63-10' for key 'UI_line_ite...")
#7 /home/bnai2/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/bnai2/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#9 /home/bnai2/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#10 /home/bnai2/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , la...")
#11 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
#12 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Price/BAO/LineItem.php(65): CRM_Core_DAO->save()
#13 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Price/BAO/LineItem.php(292): CRM_Price_BAO_LineItem::create((Array:15))
#14 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(2791): CRM_Price_BAO_LineItem::processPriceSet("211", (Array:1), Object(CRM_Contribute_BAO_Contribution), "civicrm_contribution", TRUE)
#15 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(178): CRM_Contribute_BAO_Contribution::recordFinancialAccounts((Array:38), (Array:1))
#16 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(266): CRM_Contribute_BAO_Contribution::add((Array:38), (Array:1))
#17 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution.php(1237): CRM_Contribute_BAO_Contribution::create((Array:38), (Array:1))
#18 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Contribute_Form_Contribution->postProcess()
#19 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(151): CRM_Core_Form->mainProcess()
#20 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contribute_Form_Contribution), "upload")
#21 /home/bnai2/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contribute_Form_Contribution), "upload")
#22 /home/bnai2/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution), "upload")
#23 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("upload")
#24 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(302): CRM_Core_Controller->run()
#25 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(351): CRM_Contribute_Page_Tab->edit()
#26 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(292): CRM_Contribute_Page_Tab->run((Array:4), NULL)
#27 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#28 /home/bnai2/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#29 /home/bnai2/public_html/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:4))
#30 [internal function](): civicrm_invoke("contact", "view", "contribution")
#31 /home/bnai2/public_html/includes/menu.inc(516): call_user_func_array("civicrm_invoke", (Array:3))
#32 /home/bnai2/public_html/index.php(21): menu_execute_active_handler()
#33 {main}

Any ideas on why civicrm is attempting to insert a new record in the table "civicrm_line_item"? This issue does not impact check/cash/offline contributions