CiviCRM Community Forums (archive)

I have a D7 CiviCRM 4.2.6 site with a bad DB shema so I rebuilt it and ran the CiviCRM 4.4.3 upgrader and got:

Sorry but we are not able to provide this at the moment.
Oops, it looks like you have orphaned recurring contribution records in your database. Before this upgrade can complete they will need to be fixed or deleted. You can review steps to correct this situation on the documentation wiki.

so I ran the SQL and got:

SQL query:

UPDATE civicrm_contribution_recur contri_recur LEFT JOIN civicrm_financial_type ON contri_recur.financial_type_id = civicrm_financial_type.id SET contri_recur.financial_type_id = NULL WHERE civicrm_financial_type.id IS NULL AND contri_recur.financial_type_id IS NOT NULL;

MySQL said:
#1146 - Table 'dev_civicrm.civicrm_financial_type' doesn't exist

I found a newer SQL here http://issues.civicrm.org/jira/browse/CRM-13446 but it fails on the same error.

Any suggestions how to proceed?