I’ve attempted to update my installation in the past multiple times using composer (which is a nightmare IMO).
It’s never worked and I’ve always had to restore backups to get up and running again. Hence why I am still running v4.1.2.
Has the updating process been sorted out a bit better? Has anyone else updated from 4.1.2 to a more recent version successfully?
Is there anything I need to watch out for that I can avoid?
What is the command you use to update?
Off the top of my head, I don’t recall but at the time, I was advised to follow the upgrade instructions in the docs.
{after a quick search}
Here is the post that I started when I ran into issues.
composer create-project mautic/recommended-project:^4 Mautic-new --no-interaction
Can you clear this up for me …
Are you updating? new installation? or trying to switch Mautic over to composer installed version?
Hey techbill, I’m trying to update to the newer versions. My current install does not use composer, it was a web-based install. I can’t recall what version I started with but I did go through a handful of web-based updates that worked fine.
I was advised to convert it to a composer-based install and then all updates going forward would be via composer. It was the ONLY option available to me if I wanted to stay current with releases.
PS, thanks for trying to help out!
Now that clears it up …
I would probably stick with web-based installation and just wait until Mautic 5 get released then switch over to composer installed because there is some strange issue when it come to updating Mautic 4 with composer.
Is there a bug you are experiencing or a feature you needed that currently in Mautic 4 that you need to upgrade to?
If you need to upgrade then I would say best way is to backup everything including exporting SQL from the database then do a clean fresh composer Mautic 4 installation and go through the install setup to set it up as a new install.
After you finish the new install, import the SQL back into the database and clear cache. Ideally “it should” work … emphasis → “should work” and maybe you need to run console command to update the database but I am not sure.
I didn’t realize that web-based updates were even still possible. That’s why I’m still on v4.2.1!!!
The last time I saw there was an update it didn’t offer to do a web-based update. It brought me to Github I think,
Anyways, I processed the web update to v4.4.3.
It came back to life…kind of.
Now seeing some errors pop up. Clicking on a contact returns this in the apache logs.
[Tue Oct 25 16:10:55.642720 2022] [proxy_fcgi:error] [pid 6449:tid 140419132262144] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/contacts
[Tue Oct 25 16:10:51.010238 2022] [proxy_fcgi:error] [pid 6222:tid 140419031549696] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/contacts
[Tue Oct 25 16:06:05.617713 2022] [proxy_fcgi:error] [pid 6222:tid 140419081905920] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/contacts
[Tue Oct 25 16:04:37.763161 2022] [proxy_fcgi:error] [pid 6224:tid 140419056727808] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/campaigns/edit/1
[Tue Oct 25 16:04:19.343927 2022] [proxy_fcgi:error] [pid 6224:tid 140419073513216] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/calendar
[Tue Oct 25 16:04:07.224399 2022] [proxy_fcgi:error] [pid 6224:tid 140419191011072] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/campaigns/1
[Tue Oct 25 16:03:29.238599 2022] [proxy_fcgi:error] [pid 6223:tid 140419132262144] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/calendar
[Tue Oct 25 16:03:28.248501 2022] [proxy_fcgi:error] [pid 6223:tid 140419282630400] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/calendar
[Tue Oct 25 16:03:26.771019 2022] [proxy_fcgi:error] [pid 6224:tid 140419039942400] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/calendar
[Tue Oct 25 16:03:18.398025 2022] [proxy_fcgi:error] [pid 6224:tid 140419157440256] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77', referer: https://marketing.torontoheadshot.com/s/calendar
[Tue Oct 25 16:00:05.843709 2022] [proxy_fcgi:error] [pid 6223:tid 140419090298624] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Warning: require(/home/runcloud/webapps/Mautic/var/cache/prod/doctrine/orm/Proxies/__CG__MauticPluginBundleEntityPlugin.php): failed to open stream: No such file or directory in /home/runcloud/webapps/Mautic/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php on line 197PHP message: PHP Fatal error: require(): Failed opening required '/home/runcloud/webapps/Mautic/var/cache/prod/doctrine/orm/Proxies/__CG__MauticPluginBundleEntityPlugin.php' (include_path='.:') in /home/runcloud/webapps/Mautic/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php on line 197PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77'
[Tue Oct 25 15:56:34.728398 2022] [proxy_fcgi:error] [pid 6222:tid 140419140654848] [client 76.64.152.84:0] AH01071: Got error 'PHP message: PHP Warning - file_put_contents(/home/runcloud/webapps/Mautic/var/cache/prod/annotations.map): failed to open stream: No such file or directory - in file /home/runcloud/webapps/Mautic/vendor/symfony/http-kernel/Kernel.php - at line 394PHP message: PHP Warning: file_put_contents(/home/runcloud/webapps/Mautic/var/cache/prod/annotations.map): failed to open stream: No such file or directory in /home/runcloud/webapps/Mautic/vendor/symfony/http-kernel/Kernel.php on line 394PHP message: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77PHP message: PHP Notice: Undefined variable: inline in /home/runcloud/webapps/Mautic/offline.php on line 77PHP message: Symfony\\Component\\Filesystem\\Exception\\IOException: Cannot rename "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerNUBkqNj/getKnpMenu_MatcherService.phpxOn6bZ" to "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerNUBkqNj/getKnpMenu_MatcherService.php". - in file /home/runcloud/webapps/Mautic/vendor/symfony/filesystem/Filesystem.php - at line 290'
I might add that it appears to me that there are multiple ‘cache’ directories in my install.
./Mautic/app/cache
./Mautic/var/cache
./Mautic/temp
Each of those directories had both ‘prod’ and ‘run’ folders within them.
I cleared out the ./Mautic/var/cache folder leaving the ‘ip_data’ folder intact.
is it required that those other folders need to be cleared out as well?
Current Mautic Logs
[2022-10-25 19:58:05] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT t0.id AS id_1, t0.tag AS tag_2, t0.description AS description_3 FROM m_lead_tags t0 INNER JOIN m_lead_tags_xref ON t0.id = m_lead_tags_xref.tag_id WHERE m_lead_tags_xref.lead_id = ? ORDER BY t0.tag ASC' with params ["21799"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.description' in 'field list'" at /home/runcloud/webapps/Mautic/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.id AS id_1, t0.tag AS tag_2, t0.description AS description_3 FROM m_lead_tags t0 INNER JOIN m_lead_tags_xref ON t0.id = m_lead_tags_xref.tag_id WHERE m_lead_tags_xref.lead_id = ? ORDER BY t0.tag ASC' with params [\"21799\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.description' in 'field list' at /home/runcloud/webapps/Mautic/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.description' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.description' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"localhost","pid":25068}
[2022-10-25 16:00:05] mautic.WARNING: PHP Warning - require(/home/runcloud/webapps/Mautic/var/cache/prod/doctrine/orm/Proxies/__CG__MauticPluginBundleEntityPlugin.php): failed to open stream: No such file or directory - in file /home/runcloud/webapps/Mautic/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php - at line 197 {"className":"Mautic\\PluginBundle\\Entity\\Plugin","classMetadata":"[object] (Doctrine\\ORM\\Mapping\\ClassMetadata: Doctrine\\ORM\\Mapping\\ClassMetadataInfo@2399)","proxyClassName":"Proxies\\__CG__\\Mautic\\PluginBundle\\Entity\\Plugin","fileName":"/home/runcloud/webapps/Mautic/var/cache/prod/doctrine/orm/Proxies/__CG__MauticPluginBundleEntityPlugin.php"} {"hostname":"localhost","pid":25174}
[2022-10-25 16:00:05] mautic.ERROR: PHP Notice: require(): Failed opening required '/home/runcloud/webapps/Mautic/var/cache/prod/doctrine/orm/Proxies/__CG__MauticPluginBundleEntityPlugin.php' (include_path='.:') - in file /home/runcloud/webapps/Mautic/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php - at line 197 [] {"hostname":"localhost","pid":25174}
[2022-10-25 16:00:05] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":false,"isAjax":false,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25174}
[2022-10-25 16:00:05] mautic.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Notice: require(): Failed opening required '/home/runcloud/webapps/Mautic/var/cache/prod/doctrine/orm/Proxies/__CG__MauticPluginBundleEntityPlugin.php' (include_path='.:') - in file /home/runcloud/webapps/Mautic/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php - at line 197 [] {"hostname":"localhost","pid":25174}
[2022-10-25 20:00:06] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' (uncaught exception) at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [] {"hostname":"localhost","pid":25138}
[2022-10-25 20:00:06] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"localhost","pid":25138}
[2022-10-25 16:03:18] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":false,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25600}
[2022-10-25 16:03:18] 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 m_lead_lists t0 INNER JOIN m_campaign_leadlist_xref ON t0.id = m_campaign_leadlist_xref.leadlist_id WHERE m_campaign_leadlist_xref.campaign_id = ?' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25600}
[2022-10-25 16:03:26] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":false,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25600}
[2022-10-25 16:03:26] 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 m_lead_lists t0 INNER JOIN m_campaign_leadlist_xref ON t0.id = m_campaign_leadlist_xref.leadlist_id WHERE m_campaign_leadlist_xref.campaign_id = ?' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25600}
[2022-10-25 16:03:28] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":false,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25600}
[2022-10-25 16:03:28] 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 m_lead_lists t0 INNER JOIN m_campaign_leadlist_xref ON t0.id = m_campaign_leadlist_xref.leadlist_id WHERE m_campaign_leadlist_xref.campaign_id = ?' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25600}
[2022-10-25 16:03:29] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":false,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25600}
[2022-10-25 16:03:29] 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 m_lead_lists t0 INNER JOIN m_campaign_leadlist_xref ON t0.id = m_campaign_leadlist_xref.leadlist_id WHERE m_campaign_leadlist_xref.campaign_id = ?' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25600}
[2022-10-25 16:04:07] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":true,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25605}
[2022-10-25 16:04:07] 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 m_lead_lists t0 INNER JOIN m_campaign_leadlist_xref ON t0.id = m_campaign_leadlist_xref.leadlist_id WHERE m_campaign_leadlist_xref.campaign_id = ?' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25605}
[2022-10-25 16:04:19] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":false,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25676}
[2022-10-25 16:04:19] 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 m_lead_lists t0 INNER JOIN m_campaign_leadlist_xref ON t0.id = m_campaign_leadlist_xref.leadlist_id WHERE m_campaign_leadlist_xref.campaign_id = ?' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25676}
[2022-10-25 16:04:37] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":true,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25676}
[2022-10-25 16:04:37] 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 m_lead_lists t0 INNER JOIN m_campaign_leadlist_xref ON t0.id = m_campaign_leadlist_xref.leadlist_id WHERE m_campaign_leadlist_xref.campaign_id = ?' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.last_built_date' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25676}
[2022-10-25 20:05:02] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' (uncaught exception) at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [] {"hostname":"localhost","pid":25698}
[2022-10-25 20:05:02] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"localhost","pid":25698}
[2022-10-25 16:06:05] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":true,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25740}
[2022-10-25 16:06:05] mautic.ERROR: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT t0.id AS id_1, t0.tag AS tag_2, t0.description AS description_3 FROM m_lead_tags t0 INNER JOIN m_lead_tags_xref ON t0.id = m_lead_tags_xref.tag_id WHERE m_lead_tags_xref.lead_id = ? ORDER BY t0.tag ASC' with params ["20844"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.description' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25740}
[2022-10-25 20:10:02] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' (uncaught exception) at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [] {"hostname":"localhost","pid":25823}
[2022-10-25 20:10:02] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"localhost","pid":25823}
[2022-10-25 16:10:51] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":true,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25858}
[2022-10-25 16:10:51] mautic.ERROR: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT t0.id AS id_1, t0.tag AS tag_2, t0.description AS description_3 FROM m_lead_tags t0 INNER JOIN m_lead_tags_xref ON t0.id = m_lead_tags_xref.tag_id WHERE m_lead_tags_xref.lead_id = ? ORDER BY t0.tag ASC' with params ["20844"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.description' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25858}
[2022-10-25 16:10:55] mautic.NOTICE: PHP Notice - Undefined variable: inline - in file /home/runcloud/webapps/Mautic/offline.php - at line 77 {"inTemplate":true,"isAjax":true,"message":"The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.","submessage":"System administrators, check server logs for errors.","inDev":false,"base":"/","root":"/home/runcloud/webapps/Mautic","assetPrefix":"","paths":{"themes":"themes","assets":"media","asset_prefix":"","plugins":"plugins","translations":"translations","local_config":"%kernel.root_dir%/config/local.php","root":"/home/runcloud/webapps/Ma","app":"app","bundles":"app/bundles","vendor":"vendor"},"assetBase":"/media"} {"hostname":"localhost","pid":25858}
[2022-10-25 16:10:55] mautic.ERROR: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT t0.id AS id_1, t0.tag AS tag_2, t0.description AS description_3 FROM m_lead_tags t0 INNER JOIN m_lead_tags_xref ON t0.id = m_lead_tags_xref.tag_id WHERE m_lead_tags_xref.lead_id = ? ORDER BY t0.tag ASC' with params ["21549"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.description' in 'field list' - in file /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 [] {"hostname":"localhost","pid":25858}
[2022-10-25 20:15:02] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' (uncaught exception) at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [] {"hostname":"localhost","pid":25956}
[2022-10-25 20:15:02] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"localhost","pid":25956}
[2022-10-25 20:20:03] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' (uncaught exception) at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [] {"hostname":"localhost","pid":26094}
[2022-10-25 20:20:03] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"localhost","pid":26094}
[2022-10-25 20:25:02] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' (uncaught exception) at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [] {"hostname":"localhost","pid":26270}
[2022-10-25 20:25:02] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"localhost","pid":26270}
Do you think I should do a restore and then step up the updates?
Perhaps the upgrade from v4.2.1 all the way to v4.4.3 in one go was too far a jump.
Well, I’m officially borked now.
As usual, my ADHD distracted me long enough to let this sit long enough for there to be no functioning backup. I just tried to restore and it’s 500 across the board for everything.
I’m really coming close to trashing the whole lot and looking for an alternative to Mautic.
Did you emptied the cache after restoring?
One more question … what version is your php at?
I had been running everything under 7.4 for ages. Everything was fine.
I did empty a cache, whether it was the right one or not, I am not sure. I wrote in a post above that I found multiple cache folders throughout the Mautic install folder.
I just wiped the entire directory where Mautic is installed and extracted v4.4.4. I then went through the setup process and managed to get the UI to come up. But, all my existing data is now stuck in ‘bak_’ tables in the DB.
Export your bak_ database to SQL and then import SQL back in database without the bak_ at the begining of the database name.
hi techbill,
So it’s one DB with tables prepended ‘bak_’. I’ve gone over the tables and they don’t match. Tables with the new prefix ‘m_’, don’t all match up to the older ‘bak_’ prefix tables. So SQL export and import is not going to work. At least smoothly.
I’m also noticing some screwy things in the new tables. Some of them already have data in them. The table ‘m_form_results_1_contact’ has data in it already. That would tell me the setup process imported ‘some’ of the data from the older tables but not all of it.
Here’s a spreadsheet of the bak_ tables and the m_ and how they differ - https://docs.google.com/spreadsheets/d/1uN_udrl1-wza1-9lNMKRHLWxQxu40pZjvy8pyCHhpGo/edit?usp=sharing
that strange …
the bak_ database was supposed to be your previous Mautic database before you reinstall it again.
Honestly, it seems that you somehow lost your local.cfg file when you either upgrade or reinstall your Mautic so it prompt you to do a fresh installation and backup the database that already on there.
Perhaps, I could be wrong about the bak_ database but I think it’s the original previous Mautic installation database since it no longer detect local.cfg during the upgrade or installation if you were trying to upgrade it.
So, my last attempt at trying to get this breathing again…
I restored the last backup I had including the DB.
I cleared the files, uploaded the V4.4.4 extracted files. Copied over all the files from the backup config folder, including local.php.
This managed to let me bring up the UI with all my contacts, emails, forms intact.
But! I am unable to access the email editor at all. clicking Edit does nothing.
Here are the top 16 lines from the ‘mautic_prod-xxxx’ log
[2022-11-02 19:50:05] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' (uncaught exception) at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [] {"hostname":"localhost","pid":14303}
[2022-11-02 19:50:05] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [] {"hostname":"localhost","pid":14303}
[2022-11-02 15:52:11] mautic.WARNING: PHP Warning - file_get_contents(/home/runcloud/webapps/Mautic/media/files/62e6f3705dee70ca00a5682096d5312ecd65814e.jpg): failed to open stream: No such file or directory - in file /home/runcloud/webapps/Mautic/app/bundles/AssetBundle/Entity/Asset.php - at line 1118 {"path":"/home/runcloud/webapps/Mautic/media/files/62e6f3705dee70ca00a5682096d5312ecd65814e.jpg"} {"hostname":"localhost","pid":15093}
[2022-11-02 15:52:11] mautic.CRITICAL: Uncaught PHP Exception UnexpectedValueException: "The Response content must be a string or object implementing __toString(), "boolean" given." at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php line 406 {"exception":"[object] (UnexpectedValueException(code: 0): The Response content must be a string or object implementing __toString(), \"boolean\" given. at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php:406)"} {"hostname":"localhost","pid":15093}
[2022-11-02 15:52:20] mautic.WARNING: PHP Warning - file_get_contents(/home/runcloud/webapps/Mautic/media/files/62e6f3705dee70ca00a5682096d5312ecd65814e.jpg): failed to open stream: No such file or directory - in file /home/runcloud/webapps/Mautic/app/bundles/AssetBundle/Entity/Asset.php - at line 1118 {"path":"/home/runcloud/webapps/Mautic/media/files/62e6f3705dee70ca00a5682096d5312ecd65814e.jpg"} {"hostname":"localhost","pid":15093}
[2022-11-02 15:52:20] mautic.CRITICAL: Uncaught PHP Exception UnexpectedValueException: "The Response content must be a string or object implementing __toString(), "boolean" given." at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php line 406 {"exception":"[object] (UnexpectedValueException(code: 0): The Response content must be a string or object implementing __toString(), \"boolean\" given. at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php:406)"} {"hostname":"localhost","pid":15093}
[2022-11-02 15:52:27] mautic.WARNING: PHP Warning - file_get_contents(/home/runcloud/webapps/Mautic/media/files/62e6f3705dee70ca00a5682096d5312ecd65814e.jpg): failed to open stream: No such file or directory - in file /home/runcloud/webapps/Mautic/app/bundles/AssetBundle/Entity/Asset.php - at line 1118 {"path":"/home/runcloud/webapps/Mautic/media/files/62e6f3705dee70ca00a5682096d5312ecd65814e.jpg"} {"hostname":"localhost","pid":15094}
[2022-11-02 15:52:27] mautic.CRITICAL: Uncaught PHP Exception UnexpectedValueException: "The Response content must be a string or object implementing __toString(), "boolean" given." at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php line 406 {"exception":"[object] (UnexpectedValueException(code: 0): The Response content must be a string or object implementing __toString(), \"boolean\" given. at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php:406)"} {"hostname":"localhost","pid":15094}
[2022-11-02 15:53:17] mautic.WARNING: PHP Warning - file_get_contents(/home/runcloud/webapps/Mautic/media/files/5af89730a481393455acbbcd7eab07e81c8c5f69.jpeg): failed to open stream: No such file or directory - in file /home/runcloud/webapps/Mautic/app/bundles/AssetBundle/Entity/Asset.php - at line 1118 {"path":"/home/runcloud/webapps/Mautic/media/files/5af89730a481393455acbbcd7eab07e81c8c5f69.jpeg"} {"hostname":"localhost","pid":15123}
[2022-11-02 15:53:17] mautic.CRITICAL: Uncaught PHP Exception UnexpectedValueException: "The Response content must be a string or object implementing __toString(), "boolean" given." at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php line 406 {"exception":"[object] (UnexpectedValueException(code: 0): The Response content must be a string or object implementing __toString(), \"boolean\" given. at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php:406)"} {"hostname":"localhost","pid":15123}
[2022-11-02 15:53:19] mautic.WARNING: PHP Warning - file_get_contents(/home/runcloud/webapps/Mautic/media/files/5af89730a481393455acbbcd7eab07e81c8c5f69.jpeg): failed to open stream: No such file or directory - in file /home/runcloud/webapps/Mautic/app/bundles/AssetBundle/Entity/Asset.php - at line 1118 {"path":"/home/runcloud/webapps/Mautic/media/files/5af89730a481393455acbbcd7eab07e81c8c5f69.jpeg"} {"hostname":"localhost","pid":15126}
[2022-11-02 15:53:19] mautic.CRITICAL: Uncaught PHP Exception UnexpectedValueException: "The Response content must be a string or object implementing __toString(), "boolean" given." at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php line 406 {"exception":"[object] (UnexpectedValueException(code: 0): The Response content must be a string or object implementing __toString(), \"boolean\" given. at /home/runcloud/webapps/Mautic/vendor/symfony/http-foundation/Response.php:406)"} {"hostname":"localhost","pid":15126}
[2022-11-02 15:53:48] 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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"localhost","pid":15123}
[2022-11-02 15:53:54] 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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"localhost","pid":15126}
[2022-11-02 15:53: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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"localhost","pid":15123}
[2022-11-02 15:54:01] 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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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 m_lead_lists t0 INNER JOIN m_email_list_xref ON t0.id = m_email_list_xref.leadlist_id WHERE m_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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/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/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"localhost","pid":15126}
And the top 4 lines from the top of the ‘prod-xxx’ log file
[2022-11-02 19:50:05] console.CRITICAL: Error thrown while running command "mautic:segments:update". Message: "An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list'" {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/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 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)","command":"mautic:segments:update","message":"An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list'"} {"hostname":"localhost","pid":14303}
[2022-11-02 19:55:02] console.CRITICAL: Error thrown while running command "mautic:segments:update". Message: "An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list'" {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/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 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)","command":"mautic:segments:update","message":"An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list'"} {"hostname":"localhost","pid":15164}
[2022-11-02 20:00:03] console.CRITICAL: Error thrown while running command "mautic:segments:update". Message: "An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list'" {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/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 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list' at /home/runcloud/webapps/Mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)","command":"mautic:segments:update","message":"An exception occurred while executing 'SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.public_name AS public_name_14, m0_.filters AS filters_15, m0_.is_global AS is_global_16, m0_.is_preference_center AS is_preference_center_17, m0_.last_built_date AS last_built_date_18, m0_.category_id AS category_id_19 FROM m_lead_lists m0_ LEFT JOIN m_categories m1_ ON m0_.category_id = m1_.id ORDER BY m0_.name ASC':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.last_built_date' in 'field list'"} {"hostname":"localhost","pid":15307}
This pops up in the Chrome console
app.js?ve9b30c9c:417 https://marketing.torontoheadshot.com/s/emails/new
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the html.get method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
app.js?ve9b30c9c:417 https://marketing.torontoheadshot.com/s/emails/edit/12
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the html.get method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
/s/emails/edit/12#FFFFFF:1 Failed to load resource: the server responded with a status of 500 ()
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
froala_editor.js?ve9b30c9c:321 Editor should be initialized before calling the destroy method.
(anonymous) @ froala_editor.js?ve9b30c9c:321
/s/emails/edit/12?_=1667421498002&mauticUserLastActive=49&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498003&mauticUserLastActive=51&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498004&mauticUserLastActive=52&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498005&mauticUserLastActive=52&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498006&mauticUserLastActive=53&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498007&mauticUserLastActive=53&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498008&mauticUserLastActive=54&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498019&mauticUserLastActive=105&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498020&mauticUserLastActive=109&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498023&mauticUserLastActive=113&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498024&mauticUserLastActive=114&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498025&mauticUserLastActive=114&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
/s/emails/edit/12?_=1667421498026&mauticUserLastActive=114&mauticLastNotificationId=:1 Failed to load resource: the server responded with a status of 500 ()
libraries.js?ve9b30c9c:766 GET https://marketing.torontoheadshot.com/s/emails/edit/12?_=1667421498027&mauticUserLastActive=296&mauticLastNotificationId= 500
send @ libraries.js?ve9b30c9c:766
ajax @ libraries.js?ve9b30c9c:744
Mautic.loadContent @ app.js?ve9b30c9c:40
Mautic.ajaxifyLink @ app.js?ve9b30c9c:108
(anonymous) @ app.js?ve9b30c9c:91
dispatch @ libraries.js?ve9b30c9c:465
elemData.handle @ libraries.js?ve9b30c9c:451
Error log … Something about froala editor failing to load …
Not sure what a froala editor in the error log is but I am just assuming it an older editor used in Mautic before it was switched over to GrapesJS?
My best guess would be to check to see if the GrapesJS plugin is enabled.