Forms Submissions Not Beeing Posted

Product Support
1

Hi

I really love Mautic but i am feeling a little scared.

My form submissions aren´t being posted. Leads aren´t being collected.

I have a WordPress site where i collect leads from various contact forms.

I also have Leadin, now Hubspot Marketing Free, that i use to make sure i am getting all the leads.

https://www.hubspot.com/products/marketing/free

I have tested with other paid marketing automation tools and all leads are being collected.

I am estimating that i might be loosing at least 10% of the leads.

The only errors i see in the log file are:



[2017-02-16 12:06:39] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionUniqueConstraintViolationException: “An exception occurred while executing ‘INSERT INTO malead_ips_xref (lead_id, ip_id) VALUES (?, ?)’ with params [255393, 298003]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’” at /home/XXXXXXXXXX/public_html/m/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 malead_ips_xref (lead_id, ip_id) VALUES (?, ?)’ with params [255393, 298003]:nnSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’ at /home/XXXXXXXXXX/public_html/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:66, Doctrine\DBAL\Driver\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’ at /home/XXXXXXXXXX/public_html/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’ at /home/XXXXXXXXXX/public_html/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

[2017-02-16 16:52:29] mautic.NOTICE: PHP Notice - unserialize(): Error at offset 7 of 12 bytes - in file /home/XXXXXXXXXX/public_html/m/app/bundles/CoreBundle/Model/AbstractCommonModel.php - at line 263 [] []



Did anyboy have the same issue?

Paulo

2

Hi
I really love Mautic but i am feeling a little scared.
My form submissions aren´t being posted. Leads aren´t being collected.
I have a WordPress site where i collect leads from various contact forms.
I also have Leadin, now Hubspot Marketing Free, that i use to make sure i am getting all the leads.
https://www.hubspot.com/products/marketing/free
I have tested with other paid marketing automation tools and all leads are being collected.
I am estimating that i might be loosing at least 10% of the leads.
The only errors i see in the log file are:

[2017-02-16 12:06:39] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionUniqueConstraintViolationException: “An exception occurred while executing ‘INSERT INTO malead_ips_xref (lead_id, ip_id) VALUES (?, ?)’ with params [255393, 298003]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’” at /home/XXXXXXXXXX/public_html/m/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 malead_ips_xref (lead_id, ip_id) VALUES (?, ?)’ with params [255393, 298003]:nnSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’ at /home/XXXXXXXXXX/public_html/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:66, Doctrine\DBAL\Driver\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’ at /home/XXXXXXXXXX/public_html/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘255393-298003’ for key ‘PRIMARY’ at /home/XXXXXXXXXX/public_html/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
[2017-02-16 16:52:29] mautic.NOTICE: PHP Notice - unserialize(): Error at offset 7 of 12 bytes - in file /home/XXXXXXXXXX/public_html/m/app/bundles/CoreBundle/Model/AbstractCommonModel.php - at line 263 [] []

Did anyboy have the same issue?
Paulo