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