CiviCRM Community Forums (archive)

I have just moved a live CiviCRM installation from one VPS to another, following the migration steps as closely as possible. 

The reason for the move was that the hosting co, while providing support for something else, installed a set of buggy MySQL 5.1 client libraries which severely limited a lot of command line functionality - for eg executing the SQL command USE 'dbname' would result in 'there is an error in your SQL syntax'

This meant that using tools like mysqldump for the migration was impossible.  Thankfully, PHP appeared to be using a working older MySQL 5.0 library, so I was able to use phpMyAdmin's SQL Export functionality to retrieve the database. I again used phpMyAdmin on the new server to recreate the database, tables, structure, and data.

So far, after a day's use, everything appears to be fine (contacts can be created, updated, participants registered at events etc) except for one thing. Attempting to delete a mailing in CiviMAIL results in the error:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_mailing  WHERE (  civicrm_mailing.id = 15 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`ace-crm`.`civicrm_mailing_job`, CONSTRAINT `parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_mailing_job` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_mailing  WHERE (  civicrm_mailing.id = 15 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`ace-crm`.`civicrm_mailing_job`, CONSTRAINT `parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_mailing_job` (`id`))]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_mailing  WHERE (  civicrm_mailing.id = 15 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`ace-crm`.`civicrm_mailing_job`, CONSTRAINT `parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_mailing_job` (`id`))]"]
)

Do you think this is a bug in 3.3.1, or an indication that something is more widely structurally wrong in the database?

Thanks for your help

Robin

That's a great relief, thanks Donald. Is there a way I could have found that out without posting to the forum? I spent a fair bit of time on Google!

Mny thanks,

Robin