CiviCRM Community Forums (archive)

My attempted upgrade from 4.3.5 to 4.3.6 is failing on the following SQL statement:

UPDATE civicrm_price_set_entity cpse LEFT JOIN civicrm_price_set cps ON cps.id = cpse.price_set_id LEFT JOIN civicrm_price_field cpf ON cps.id = cpf.price_set_id LEFT JOIN civicrm_price_field_value cpfv ON cpf.id = cpfv.price_field_id LEFT JOIN civicrm_event ce ON cpse.entity_id = ce.id AND cpse.entity_table = 'civicrm_event' LEFT JOIN civicrm_contribution_page ccg ON cpse.entity_id = ccg.id AND cpse.entity_table = 'civicrm_contribution_page' SET cpfv.financial_type_id = CASE WHEN ce.id IS NOT NULL THEN ce.financial_type_id WHEN ccg.id IS NOT NULL THEN ccg.financial_type_id END, cps.financial_type_id = CASE WHEN ce.id IS NOT NULL THEN ce.financial_type_id WHEN ccg.id IS NOT NULL THEN ccg.financial_type_id END WHERE cps.is_quick_config = 1

The error message is:  (
#1452 - Cannot add or update a child row: a foreign key constraint fails (`nsteorg_crm`.`civicrm_price_set`, CONSTRAINT `FK_civicrm_price_set_financial_type_id` FOREIGN KEY (`financial_type_id`) REFERENCES `civicrm_financial_type` (`id`))

I have tried running the SQL statement from PhpMyAdmin, but that is giving the same results.  Any other ideas?