CiviCRM Community Forums (archive)

Hi Experts,

Im trying to use API and Entity Line Item to create a line item record.. but its throwing the following error
 [nativecode=1062 ** Duplicate entry 'civicrm_contribution-1-1-1' for key 'UI_line_item_value']' (length=385)
  'trace' => string '#0 [internal function]: CRM_Core_Error::exceptionHandler(Object(DB_Error))

Im getting the same error when i tried manually using Sql statement as well

my sql query is : 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 , deductible_amount ) VALUES ('civicrm_contribution' ,  1 ,  1 , 'Edoka' ,  1 ,  444 ,  444 ,  1 ,  1 ,  1 ,  0 )


Can anyone pls help me to solve this..

Many Thanks in advance!!

Using "show create table civicrm_line_item", I can see that UNIQUE index you mention:

  UNIQUE KEY `UI_line_item_value` (`entity_table`,`entity_id`,`price_field_value_id`,`price_field_id`),

This seems to be saying that given a particular record (e.g. given entity_table="civicrm_participant" and entity_id=5), each price field value can only be used once. This seems like a sensible restriction based on how "price sets" work.

(Aside: There is probably some difference between Civi's "PriceSets/LineItems" model and the mental model of a paper-based "Order/LineItem" form. In some "Order/LineItem" models, you could create two separate line-items to purchase two copies of the same product. In Civi's model, I don't think that would happen -- if multiple copies of an item can be purchased, then you would design price-fields specifically to allow that.)

I guess the next questions -- Why is it trying to create a new price-field-value when one already exists? If you want to update an existing item, most APIs will accept the existing item's "id". (Warning: I haven't used the particular APIs that you're using, so I don't know for sure.)