Error on install - foreign key constraint fails

[magnolia61]

I would love to use this extension but unfortunately cannot get it to work. Running latest Stable 5.43

When I install it fails and I get the following message in the error log

[db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTOcivicrm_mailing_event_queue(job_id,email_id,contact_id,hash) VALUES ( 2033 , 2425 , 1820 , 'fc001a390f192936' ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (xyzdb_civi.civicrm_mailing_event_queue, CONSTRAINTFK_civicrm_mailing_event_queue_job_idFOREIGN KEY (job_id) REFERENCEScivicrm_mailing_job(id) ON DELETE CASCADE)]"]

Does this ring a bell to something easily solvable?

[jitendrapurohit]

@magnolia61 Do you mean it fails with the above error immediately after you install the extension? or it fails when you perform some operation after enabling the extension? If the latter, can you pls list the steps on what action were you trying to perform?

[magnolia61]

When I click to install the extension, it seems to do something and then quits with a fatal: The website encountered an unexpected error. Please try again later.

When I lookup the errorlog it mentions the above FK error.

[jitendrapurohit]

weird. Do you have any backtrace printed in the log file?

[magnolia61]

This is the full error: The contact_id is that of my cron user I can see the extension creates 2 tables and an activity type option value, but is there something else imported in this process which could cause this?

 [error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO `civicrm_mailing_event_queue` (`job_id` , `email_id` , `contact_id` , `hash` ) VALUES ( 2033 ,  2425 ,  1820 , '9cb71382ae66043e' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xyzdb_civi`.`civicrm_mailing_event_queue`, CONSTRAINT `FK_civicrm_mailing_event_queue_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO `civicrm_mailing_event_queue` (`job_id` , `email_id` , `contact_id` , `hash` ) VALUES ( 2033 ,  2425 ,  1820 , '9cb71382ae66043e' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xyzdb_civi`.`civicrm_mailing_event_queue`, CONSTRAINT `FK_civicrm_mailing_event_queue_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO `civicrm_mailing_event_queue` (`job_id` , `email_id` , `contact_id` , `hash` ) VALUES ( 2033 ,  2425 ,  1820 , '9cb71382ae66043e' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`xyzdb_civi`.`civicrm_mailing_event_queue`, CONSTRAINT `FK_civicrm_mailing_event_queue_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job` (`id`) ON DELETE CASCADE)]"]
)

[magnolia61]

Strange: I deleted some older archived mailings and retried. Installed like a charm. If more people use this extension on 5.43 maybe the info.xml could reflect that

Just found out about this gem. Agree this stuff should be in core.