Mautic Community Forums

Saving edited campaing error

Hi,

I have a pretty bad error that happens sometimes. When a user (not admin) edit a campaign sometimes he gets this error and all events that have been deleted are still there (in upper left corner when opening the builder again).

In the log I have this error:

[2016-04-27 10:01:57] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘DELETE FROM mauqo_campaign_events WHERE id = ?’ with params [262]: Cannot delete or update a parent row: a foreign key constraint fails (maut812.mauqo_campaign_events, CONSTRAINT FK_25BBE925727ACA70 FOREIGN KEY (parent_id) REFERENCES mauqo_campaign_events (id))” at /PATH-TO-MAUTIC/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘DELETE FROM mauqo_campaign_events WHERE id = ?’ with params [262]:nnCannot delete or update a parent row: a foreign key constraint fails (maut812.mauqo_campaign_events, CONSTRAINT FK_25BBE925727ACA70 FOREIGN KEY (parent_id) REFERENCES mauqo_campaign_events (id)) at /PATH-TO-MAUTIC/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 1451): Cannot delete or update a parent row: a foreign key constraint fails (maut812.mauqo_campaign_events, CONSTRAINT FK_25BBE925727ACA70 FOREIGN KEY (parent_id) REFERENCES mauqo_campaign_events (id)) at /PATH-TO-MAUTIC/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:166)"} []



Would you have any idea/advice? Server is Ubuntu LTS, with Apache/MySQL



Thanks in advance,

Salvatore.

Hi,
I have a pretty bad error that happens sometimes. When a user (not admin) edit a campaign sometimes he gets this error and all events that have been deleted are still there (in upper left corner when opening the builder again).
In the log I have this error:
[2016-04-27 10:01:57] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘DELETE FROM mauqo_campaign_events WHERE id = ?’ with params [262]: Cannot delete or update a parent row: a foreign key constraint fails (maut812.mauqo_campaign_events, CONSTRAINT FK_25BBE925727ACA70 FOREIGN KEY (parent_id) REFERENCES mauqo_campaign_events (id))” at /PATH-TO-MAUTIC/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘DELETE FROM mauqo_campaign_events WHERE id = ?’ with params [262]:nnCannot delete or update a parent row: a foreign key constraint fails (maut812.mauqo_campaign_events, CONSTRAINT FK_25BBE925727ACA70 FOREIGN KEY (parent_id) REFERENCES mauqo_campaign_events (id)) at /PATH-TO-MAUTIC/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 1451): Cannot delete or update a parent row: a foreign key constraint fails (maut812.mauqo_campaign_events, CONSTRAINT FK_25BBE925727ACA70 FOREIGN KEY (parent_id) REFERENCES mauqo_campaign_events (id)) at /PATH-TO-MAUTIC/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:166)"} []

Would you have any idea/advice? Server is Ubuntu LTS, with Apache/MySQL

Thanks in advance,
Salvatore.