Your software
My Mautic version is: 2.15.3
My PHP version is: 7.2
Your problem
My problem is:
When I go to “Contacts” and click on any contact, the page indicates that it is loading with the blue lines at the top, but does not open. I just stay on the same page. If I open the contact details in a new tab (i.e.http://millwrightsites.com/wordpress/mautic/index.php/s/contacts/view/267), I get “500 Internal Server Error.”
These errors are showing in the log:
[2019-12-20 15:52:36] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT ip.date_added, ip.ip_address, ip.lead_id, ip.id FROM (SELECT MAX(l.date_added) as date_added, MIN(l.id) as id, l.ip_address, l.object_id as lead_id FROM dbaudit_log l WHERE (l.bundle = ‘lead’) AND (l.object = ‘lead’) AND (l.action = ‘ipadded’) AND ((l.object_id = 267) AND (l.date_added >= ‘1576871181’)) GROUP BY l.ip_address) ip ORDER BY ip.date_added DESC LIMIT 25’: SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘1576871181’” at D:\Websites\millwrightsites.com\wordpress\mautic\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT ip.date_added, ip.ip_address, ip.lead_id, ip.id FROM (SELECT MAX(l.date_added) as date_added, MIN(l.id) as id, l.ip_address, l.object_id as lead_id FROM dbaudit_log l WHERE (l.bundle = ‘lead’) AND (l.object = ‘lead’) AND (l.action = ‘ipadded’) AND ((l.object_id = 267) AND (l.date_added >= ‘1576871181’)) GROUP BY l.ip_address) ip ORDER BY ip.date_added DESC LIMIT 25’:\n\nSQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘1576871181’ at D:\Websites\millwrightsites.com\wordpress\mautic\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘1576871181’ at D:\Websites\millwrightsites.com\wordpress\mautic\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:106, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘1576871181’ at D:\Websites\millwrightsites.com\wordpress\mautic\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:104)"}
Steps I have tried to fix the problem:
