Your software
My PHP version is : 7.4.26
My MySQL/MariaDB version is 10.4.25-MariaDB-cll-lve
Updating/Installing Errors
I am: Updating
Upgrading via : Web
These errors are showing in the installer : None
These errors are showing in the Mautic log :
[2022-09-11 23:37:00] 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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"h19.seohost.pl","pid":3007262}
[2022-09-11 23:37:30] mautic.ERROR: 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 ma_lead_lists t0 INNER JOIN ma_campaign_leadlist_xref ON t0.id = ma_campaign_leadlist_xref.leadlist_id WHERE ma_campaign_leadlist_xref.campaign_id = ?' with params [33]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"h19.seohost.pl","pid":3007262}
[2022-09-11 23:37:45] 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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"h19.seohost.pl","pid":3007262}
[2022-09-11 23:37:46] 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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"h19.seohost.pl","pid":3007262}
[2022-09-11 23:37:47] 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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"h19.seohost.pl","pid":3007262}
[2022-09-11 23:38:02] 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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_email_list_xref.email_id = ?' with params [13]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list'" at /home/srv35830/domains/wernermusic.pl/public_html/mail/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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_email_list_xref.email_id = ?' with params [13]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' at /home/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"h19.seohost.pl","pid":3007262}
[2022-09-11 23:38:06] 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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_email_list_xref.email_id = ?' with params [8]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list'" at /home/srv35830/domains/wernermusic.pl/public_html/mail/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 ma_lead_lists t0 INNER JOIN ma_email_list_xref ON t0.id = ma_email_list_xref.leadlist_id WHERE ma_email_list_xref.email_id = ?' with params [8]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' at /home/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/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/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"h19.seohost.pl","pid":3044898}
[2022-09-11 23:45:40] mautic.ERROR: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.random_id AS random_id_2, m0_.secret AS secret_3, m0_.redirect_uris AS redirect_uris_4, m0_.allowed_grant_types AS allowed_grant_types_5, m0_.role_id AS role_id_6 FROM ma_oauth2_clients m0_': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.role_id' in 'field list' - in file /home/srv35830/domains/wernermusic.pl/public_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"h19.seohost.pl","pid":3098286}
Your problem
My problem is : The instalation frozen on clearing cache. Then I had 403 forbidden when I’ve tried to log into Mautic. I’ve changed the .htacces file and put a comments on this line of code:
#<FilesMatch "\.php$">
# Require all denied
#</FilesMatch>
Then I was able to log in. Then I’ve discovered two problems for now:
- I can’t edit any email that I have created before update. I can create new ones.
- On the page with API Credentials I see this sentence:
The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.
System administrators, check server logs for errors.
Steps I have tried to fix the problem :
- Changed .htacces file
- Cleared cache (deleted all folder inside “var/cache”)
