Mautic Community Forums

Database error i sending mail

When I try to send an email I had this problems:

[2016-09-06 15:46:09] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionUniqueConstraintViolationException: “An exception occurred while executing ‘INSERT INTO maugl_channel_url_trackables (channel_id, channel, hits, unique_hits, redirect_id) VALUES (?, ?, ?, ?, ?)’ with params [36, “email”, 0, 0, 1383]: Duplicate entry ‘email-0-0’ for key ‘PRIMARY’” at /home/…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 66 {“exception”:"[object] (Doctrine\DBAL\Exception\UniqueConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO maugl_channel_url_trackables (channel_id, channel, hits, unique_hits, redirect_id) VALUES (?, ?, ?, ?, ?)’ with params [36, “email”, 0, 0, 1383]:nnDuplicate entry ‘email-0-0’ for key ‘PRIMARY’ at /home/…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:66, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Duplicate entry ‘email-0-0’ for key ‘PRIMARY’ at /home/…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:165)"} []



I understand that I have a duplicate key. Someone know What I had to do? I can’t send email.

Is that a one time thing or does it happen with every email? If so, provide the steps to replicate it, please.

When I try to send an email I had this problems:
[2016-09-06 15:46:09] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionUniqueConstraintViolationException: “An exception occurred while executing ‘INSERT INTO maugl_channel_url_trackables (channel_id, channel, hits, unique_hits, redirect_id) VALUES (?, ?, ?, ?, ?)’ with params [36, “email”, 0, 0, 1383]: Duplicate entry ‘email-0-0’ for key ‘PRIMARY’” at /home/…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 66 {“exception”:"[object] (Doctrine\DBAL\Exception\UniqueConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO maugl_channel_url_trackables (channel_id, channel, hits, unique_hits, redirect_id) VALUES (?, ?, ?, ?, ?)’ with params [36, “email”, 0, 0, 1383]:nnDuplicate entry ‘email-0-0’ for key ‘PRIMARY’ at /home/…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:66, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Duplicate entry ‘email-0-0’ for key ‘PRIMARY’ at /home/…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:165)"} []

I understand that I have a duplicate key. Someone know What I had to do? I can’t send email.