# Upgraded to 2.2 / 500 error at Contacts **URL:** \ **Category:** Product Support\ **Created:** [October 10, 2016, 1:45pm UTC](https://forum.mautic.org/t/upgraded-to-2-2-500-error-at-contacts/6170 "2016-10-10T13:45:02Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![eplaku](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/eplaku/32/49_2.png) [@eplaku](https://forum.mautic.org/u/eplaku)\ **Post date:** [October 10, 2016, 1:45pm UTC](https://forum.mautic.org/t/upgraded-to-2-2-500-error-at-contacts/6170/1 "2016-10-10T13:45:02Z")
Hi everyone, I was so excited to get the latest version of Mautic because I thought it would solve many of the issues I was and having now with the latest version. The most important one is the fact that once I click to see the list of Contacts I get a 500 error. This is what my log file says: Code: [2016-10-10 16:43:26] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: "An exception occurred while executing 'SELECT l.id, l.email FROM lead\_donotcontact dnc LEFT JOIN leads l ON l.id = dnc.lead\_id WHERE (dnc.channel = "email") AND (l.email \<\> '')': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list'" at /home/albkrist/public\_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT l.id, l.email FROM lead\_donotcontact dnc LEFT JOIN leads l ON l.id = dnc.lead\_id WHERE (dnc.channel = "email") AND (l.email \<\> '')':nnSQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list' at /home/albkrist/public\_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list' at /home/albkrist/public\_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list' at /home/albkrist/public\_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)"} [] ---
**Author:** ![eplaku](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/eplaku/32/49_2.png) [@eplaku](https://forum.mautic.org/u/eplaku)\ **Post date:** [October 10, 2016, 1:45pm UTC](https://forum.mautic.org/t/upgraded-to-2-2-500-error-at-contacts/6170/2 "2016-10-10T13:45:02Z")
Hi everyone, I was so excited to get the latest version of Mautic because I thought it would solve many of the issues I was and having now with the latest version. The most important one is the fact that once I click to see the list of Contacts I get a 500 error. This is what my log file says: `[2016-10-10 16:43:26] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: "An exception occurred while executing 'SELECT l.id, l.email FROM lead_donotcontact dnc LEFT JOIN leads l ON l.id = dnc.lead_id WHERE (dnc.channel = "email") AND (l.email <> '')': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list'" at /home/albkrist/public_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT l.id, l.email FROM lead_donotcontact dnc LEFT JOIN leads l ON l.id = dnc.lead_id WHERE (dnc.channel = "email") AND (l.email <> '')':nnSQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list' at /home/albkrist/public_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list' at /home/albkrist/public_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.email' in 'field list' at /home/albkrist/public_html/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)"} [] ` ---
**Author:** ![Yannick038](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/yannick038/32/117_2.png) [@Yannick038](https://forum.mautic.org/u/Yannick038)\ **Post date:** [October 10, 2016, 1:49pm UTC](https://forum.mautic.org/t/upgraded-to-2-2-500-error-at-contacts/6170/3 "2016-10-10T13:49:00Z")
How did you make the update ? Did it finished ? Here I broke my mautic install using GUI and i had to restore a backup and perform the update via command line ---
**Author:** ![eplaku](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/eplaku/32/49_2.png) [@eplaku](https://forum.mautic.org/u/eplaku)\ **Post date:** [October 10, 2016, 1:56pm UTC](https://forum.mautic.org/t/upgraded-to-2-2-500-error-at-contacts/6170/4 "2016-10-10T13:56:52Z")
Hi, I basically uploaded all the new version files, after deleting all the old ones, then uploaded the local.php file with the configuration and did a schema upgrade via the browser. I’m not good at using GUI ---
**Author:** ![eplaku](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/eplaku/32/49_2.png) [@eplaku](https://forum.mautic.org/u/eplaku)\ **Post date:** [October 10, 2016, 2:51pm UTC](https://forum.mautic.org/t/upgraded-to-2-2-500-error-at-contacts/6170/5 "2016-10-10T14:51:50Z")
+1