# Problems with Mautic 4.2 updade

**URL:** <https://forum.mautic.org/t/problems-with-mautic-4-2-updade/22890>\
**Category:** Mautic 4 Install/Upgrade Support\
**Created:** [March 2, 2022, 3:36pm UTC](https://forum.mautic.org/t/problems-with-mautic-4-2-updade/22890 "2022-03-02T15:36:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mneumann](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mneumann/32/2512_2.png) [@mneumann](https://forum.mautic.org/u/mneumann)\
**Post date:** [March 2, 2022, 3:36pm UTC](https://forum.mautic.org/t/problems-with-mautic-4-2-updade/22890/1 "2022-03-02T15:36:24Z")

</div>

**Your software**  
_My PHP version is_ : 7.4.28

**Updating/Installing Errors**  
_I am_: Updating  
_Upgrading/installing via_ : Web

_These errors are showing in the installer_ : It was hanging at the moment of clearing the cache.  
Now it says it is upgraded to Mautic 4.2, but I cannot duplicate or edit any email. Tried to clear the cache in the command line but did not resolve it.

I am publishing the first errors showing up, there are still more in the log file.

_These errors are showing in the Mautic log_ :

[2022-03-02 14:50:01] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘SELECT l0\_.is\_published AS is\_published\_0, l0\_.date\_added AS date\_added\_1, l0\_.created\_by AS created\_by\_2, l0\_.created\_by\_user AS created\_by\_user\_3, l0\_.date\_modified AS date\_modified\_4, l0\_.modified\_by AS modified\_by\_5, l0\_.modified\_by\_user AS modified\_by\_user\_6, l0\_.checked\_out AS checked\_out\_7, l0\_.checked\_out\_by AS checked\_out\_by\_8, l0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, l0\_.id AS id\_10, l0\_.name AS name\_11, l0\_.description AS description\_12, l0\_.alias AS alias\_13, l0\_.public\_name AS public\_name\_14, l0\_.filters AS filters\_15, l0\_.is\_global AS is\_global\_16, l0\_.is\_preference\_center AS is\_preference\_center\_17, l0\_.last\_built\_date AS last\_built\_date\_18, l0\_.category\_id AS category\_id\_19 FROM lead\_lists l0\_ LEFT JOIN categories c1\_ ON l0\_.category\_id = c1\_.id ORDER BY l0\_.name ASC’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0\_.last\_built\_date’ in ‘field list’ (uncaught exception) at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update`    
[2022-03-02 14:50:01] mautic.WARNING: Command `mautic:segments:update` exited with status code 1    
[2022-03-02 15:51:31] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [58]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [58]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 15:52:14] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [58]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [58]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 15:52:28] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [56]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [56]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 15:52:32] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [56]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [56]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 15:54:29] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [6]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [6]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 15:54:34] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [6]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [6]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 15:54:55] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [10]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [10]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 14:55:02] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘SELECT l0\_.is\_published AS is\_published\_0, l0\_.date\_added AS date\_added\_1, l0\_.created\_by AS created\_by\_2, l0\_.created\_by\_user AS created\_by\_user\_3, l0\_.date\_modified AS date\_modified\_4, l0\_.modified\_by AS modified\_by\_5, l0\_.modified\_by\_user AS modified\_by\_user\_6, l0\_.checked\_out AS checked\_out\_7, l0\_.checked\_out\_by AS checked\_out\_by\_8, l0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, l0\_.id AS id\_10, l0\_.name AS name\_11, l0\_.description AS description\_12, l0\_.alias AS alias\_13, l0\_.public\_name AS public\_name\_14, l0\_.filters AS filters\_15, l0\_.is\_global AS is\_global\_16, l0\_.is\_preference\_center AS is\_preference\_center\_17, l0\_.last\_built\_date AS last\_built\_date\_18, l0\_.category\_id AS category\_id\_19 FROM lead\_lists l0\_ LEFT JOIN categories c1\_ ON l0\_.category\_id = c1\_.id ORDER BY l0\_.name ASC’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0\_.last\_built\_date’ in ‘field list’ (uncaught exception) at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update`    
[2022-03-02 14:55:02] mautic.WARNING: Command `mautic:segments:update` exited with status code 1    
[2022-03-02 15:55:12] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [10]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [10]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}   
[2022-03-02 15:55:14] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [10]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’” at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is\_published AS is\_published\_1, t0.date\_added AS date\_added\_2, t0.created\_by AS created\_by\_3, t0.created\_by\_user AS created\_by\_user\_4, t0.date\_modified AS date\_modified\_5, t0.modified\_by AS modified\_by\_6, t0.modified\_by\_user AS modified\_by\_user\_7, t0.checked\_out AS checked\_out\_8, t0.checked\_out\_by AS checked\_out\_by\_9, t0.checked\_out\_by\_user AS checked\_out\_by\_user\_10, t0.id AS id\_11, t0.name AS name\_12, t0.description AS description\_13, t0.alias AS alias\_14, t0.public\_name AS public\_name\_15, t0.filters AS filters\_16, t0.is\_global AS is\_global\_17, t0.is\_preference\_center AS is\_preference\_center\_18, t0.last\_built\_date AS last\_built\_date\_19, t0.category\_id AS category\_id\_20 FROM lead\_lists t0 INNER JOIN email\_list\_xref ON t0.id = email\_list\_xref.leadlist\_id WHERE email\_list\_xref.email\_id = ?’ with params [10]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last\_built\_date’ in ‘field list’ at /home/customer/www/msg.rundumgesund.org/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [March 3, 2022, 2:55pm UTC](https://forum.mautic.org/t/problems-with-mautic-4-2-updade/22890/2 "2022-03-03T14:55:24Z")

</div>

This is a duplicate of an existing issue:

> [@Error after upgrading to 4.2 clearing cache fails and error: Unknown column last\_built\_date in field list](https://forum.mautic.org/t/error-after-upgrading-to-4-2-from-4-unknown-column-last-built-date-in-field-list/22866/4):
>
> Right - @tobsowo had a similar problem. Other than the usual ‘don’t update in the browser’ message, here’s what helped him: Clear the cache by deleting the cache folder Follow these steps:

Please follow those steps and reply in that thread if you continue to experience a problem.

Thanks!

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [March 3, 2022, 3:02pm UTC](https://forum.mautic.org/t/problems-with-mautic-4-2-updade/22890/3 "2022-03-03T15:02:54Z")

</div>