CiviCRM Community Forums (archive)

When upgrading a 4.2.7 site to 4.3 b2 I get the error:
nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`d6_crm`.`civicrm_line_item`, CONSTRAINT `FK_civicrm_line_item_financial_type_id` FOREIGN KEY (`financial_type_id`) REFERENCES `civicrm_financial_type` (`id`))

Does that ring a bell with anyone? This is during [Create financial records for contributions]

The sql query is:
UPDATE civicrm_line_item li LEFT JOIN civicrm_contribution con ON (li.entity_id = con.id AND li.entity_table = 'civicrm_contribution') LEFT JOIN civicrm_price_field_value cpfv ON li.price_field_value_id = cpfv.id LEFT JOIN civicrm_participant cp ON (li.entity_id = cp.id AND li.entity_table = 'civicrm_participant') LEFT JOIN civicrm_event ce ON ce.id = cp.event_id SET li.financial_type_id = CASE WHEN (con.contribution_page_id IS NULL || li.price_field_value_id IS NULL) AND cp.id IS NULL THEN con.financial_type_id WHEN (con.contribution_page_id IS NOT NULL AND cp.id IS NULL) || (cp.id IS NOT NULL AND li.price_field_value_id IS NOT NULL) THEN cpfv.financial_type_id WHEN cp.id IS NOT NULL AND li.price_field_value_id IS NULL THEN ce.financial_type_id END