# Sql database error

**URL:** <https://forum.mautic.org/t/sql-database-error/17306>\
**Category:** Product Support\
**Created:** [December 5, 2020, 8:25pm UTC](https://forum.mautic.org/t/sql-database-error/17306 "2020-12-05T20:25:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chente38](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/chente38/32/522_2.png) [@chente38](https://forum.mautic.org/u/chente38)\
**Post date:** [December 5, 2020, 8:25pm UTC](https://forum.mautic.org/t/sql-database-error/17306/1 "2020-12-05T20:25:53Z")

</div>

**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)"}

---

<div class="post-metadata">

**Author:** ![chente38](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/chente38/32/522_2.png) [@chente38](https://forum.mautic.org/u/chente38)\
**Post date:** [December 5, 2020, 8:34pm UTC](https://forum.mautic.org/t/sql-database-error/17306/2 "2020-12-05T20:34:02Z")

</div>

solved, using http://[your-mautic-url]/s/update/schema

thanks