Mautic Community Forums

Weird error from database

Hello folks,



Got this weir error. Anybody encountered this before?



[2016-06-08 21:53:52] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘DELETE FROM campaign_events WHERE id = ?’ with params [5]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (swgins_maudb.campaign_events, CONSTRAINT FK_8EC42EE7727ACA70 FOREIGN KEY (parent_id) REFERENCES campaign_events (id))” at /var/www/webURL/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘DELETE FROM campaign_events WHERE id = ?’ with params [5]:nnSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (webURL_maudb.campaign_events, CONSTRAINT FK_8EC42EE7727ACA70 FOREIGN KEY (parent_id) REFERENCES campaign_events (id)) at /var/www/webURL.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (swgins_maudb.campaign_events, CONSTRAINT FK_8EC42EE7727ACA70 FOREIGN KEY (parent_id) REFERENCES campaign_events (id)) at /var/www/webURL.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855)"} []

Hello folks,

Got this weir error. Anybody encountered this before?

[2016-06-08 21:53:52] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘DELETE FROM campaign_events WHERE id = ?’ with params [5]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (swgins_maudb.campaign_events, CONSTRAINT FK_8EC42EE7727ACA70 FOREIGN KEY (parent_id) REFERENCES campaign_events (id))” at /var/www/webURL/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘DELETE FROM campaign_events WHERE id = ?’ with params [5]:nnSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (webURL_maudb.campaign_events, CONSTRAINT FK_8EC42EE7727ACA70 FOREIGN KEY (parent_id) REFERENCES campaign_events (id)) at /var/www/webURL.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (swgins_maudb.campaign_events, CONSTRAINT FK_8EC42EE7727ACA70 FOREIGN KEY (parent_id) REFERENCES campaign_events (id)) at /var/www/webURL.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855)"} []