CiviCRM Community Forums (archive)

I am upgrading from 1.9 (which was originally 1.8 ) to 2.05.  I have followed the outlined upgrade instructions methodically, and rebuilt the 1.9 database to ensure integrity.  However, on step six I get the following error:

ALTER TABLE `civicrm_contribution_page` ADD CONSTRAINT `FK_civicrm_contribution_page_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wcpr_civicrm19Fix/#sql-6e4_be2e4`, CONSTRAINT `FK_civicrm_contribution_page_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE )]

Based on pouring through other similar problems that other people have had, I know that something in civicrm_contribution_page is orphaned.  It seems like doing a DELETE and LEFT JOIN command, like for the other cleanups, would fix this, but I am not all that proficient with SQL, and would appreciate some help getting the correct command.

Thanks,

Josh

Thanks for the help.  That snippet seemed to have fixed the first problem, but now upon running step six I get this problem:

    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_mailing`
    ADD CONSTRAINT `FK_civicrm_mailing_footer_id` FOREIGN KEY (`footer_id`) REFERENCES `civicrm_mailing_component` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_civicrm_mailing_header_id` FOREIGN KEY (`header_id`) REFERENCES `civicrm_mailing_component` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_civicrm_mailing_msg_template_id` FOREIGN KEY (`msg_template_id`) REFERENCES `civicrm_msg_template` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_civicrm_mailing_optout_id` FOREIGN KEY (`optout_id`) REFERENCES `civicrm_mailing_component` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_civicrm_mailing_reply_id` FOREIGN KEY (`reply_id`) REFERENCES `civicrm_mailing_component` (`id`) ON DELETE SET NULL,
    ADD CONSTRAINT `FK_civicrm_mailing_unsubscribe_id` FOREIGN KEY (`unsubscribe_id`) REFERENCES `civicrm_mailing_component` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wcpr_civicrm19Fix/#sql-6e4_d36c3`, CONSTRAINT `FK_civicrm_mailing_optout_id` FOREIGN KEY (`optout_id`) REFERENCES `civicrm_mailing_component` (`id`) ON DELETE SET NULL)]

Any ideas?  I followed the upgrade instructions thoroughly, and I know that my database's schema is correct.

Thanks!