Your software
My Mautic version is:v3.2.1
My PHP version is: 7.3
My Database type and version is:
Your problem
My problem is:
Hi,
i have an issue in my database ( i guess)
i cannot open a contact in mautic.
Any idea to solve it?
Thanks a lot
These errors are showing in the log:
[2020-12-05 14:15:13] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 78440 ORDER BY s.date_sent DESC LIMIT 25’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 78440 ORDER BY s.date_sent DESC LIMIT 25’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"}
[2020-12-05 14:15:16] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 78440 ORDER BY s.date_sent DESC LIMIT 25’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 78440 ORDER BY s.date_sent DESC LIMIT 25’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"}
[2020-12-05 14:15:17] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 31593 ORDER BY s.date_sent DESC LIMIT 25’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 31593 ORDER BY s.date_sent DESC LIMIT 25’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"}
[2020-12-05 14:15:23] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 78170 ORDER BY s.date_sent DESC LIMIT 25’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 78170 ORDER BY s.date_sent DESC LIMIT 25’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"}
[2020-12-05 14:15:25] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 25069 ORDER BY s.date_sent DESC LIMIT 25’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT s.sms_id, s.id, s.date_sent as dateSent, e.name, e.name as sms_name, s.is_failed as isFailed, s.list_id, l.name as list_name, s.tracking_hash as idHash, s.lead_id, s.details FROM mau_sms_message_stats s LEFT JOIN mau_sms_messages e ON s.sms_id = e.id LEFT JOIN mau_lead_lists l ON s.list_id = l.id WHERE s.lead_id = 25069 ORDER BY s.date_sent DESC LIMIT 25’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.is_failed’ in ‘field list’ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"}