URGENT: Upgrade to 4.2.1 > Error viewing contact details

[aglyons]

Your software
My Mautic version is: 4.2.1
My PHP version is: 7.4.28
My Database type and version is:10.2.43-MariaDB

Your problem
My problem is: After upgrading to 4.2.1 I can’t view contact details

These errors are shown in the log:

prod-2022-04-06.php

`
[2022-04-06 13:30: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:132)",“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’"} []

`

*Web Server Log

[Wed Apr 06 09:27:05.329207 2022] [proxy_fcgi:error] [pid 25220:tid 139852875994880] [client 76.70.83.119: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: Symfony\\Component\\Filesystem\\Exception\\IOException: Cannot rename "/home/runcloud/webapps/Mautic/var/cache/prod/appAppKernelProdContainer.php.metabkUwpE" to "/home/runcloud/webapps/Mautic/var/cache/prod/appAppKernelProdContainer.php.meta". - in file /home/runcloud/webapps/Mautic/vendor/symfony/filesystem/Filesystem.php - at line 290', referer: https://marketing.torontoheadshot.com/s/contacts/view/11556
[Wed Apr 06 09:27:00.785510 2022] [proxy_fcgi:error] [pid 25220:tid 139853010278144] [client 76.70.83.119: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: Symfony\\Component\\Filesystem\\Exception\\IOException: Cannot rename "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerIxbfMcX/getFileEncodingValidatorService.phpYKLZMK" to "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerIxbfMcX/getFileEncodingValidatorService.php". - in file /home/runcloud/webapps/Mautic/vendor/symfony/filesystem/Filesystem.php - at line 290', referer: https://marketing.torontoheadshot.com/s/update
[Wed Apr 06 09:26:47.986183 2022] [proxy_fcgi:error] [pid 25221:tid 139853001885440] [client 76.70.83.119: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: Symfony\\Component\\Filesystem\\Exception\\IOException: Cannot rename "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerTLjE2dM/get_ServiceLocator_2frCdQQService.phpfrYHe7" to "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerTLjE2dM/get_ServiceLocator_2frCdQQService.php". - in file /home/runcloud/webapps/Mautic/vendor/symfony/filesystem/Filesystem.php - at line 290'
[Wed Apr 06 04:19:16.342313 2022] [proxy_fcgi:error] [pid 25220:tid 139852959921920] [client 54.164.82.255:0] AH01071: Got error 'PHP message: PHP Notice:  Trying to access array offset on value of type bool in /home/runcloud/webapps/Mautic/app/bundles/PageBundle/Entity/HitRepository.php on line 276', referer: https://torontoheadshot.com/contact/
[Wed Apr 06 04:04:35.646769 2022] [proxy_fcgi:error] [pid 25221:tid 139852867602176] [client 54.164.82.255:0] AH01071: Got error 'PHP message: PHP Notice:  Trying to access array offset on value of type bool in /home/runcloud/webapps/Mautic/app/bundles/PageBundle/Entity/HitRepository.php on line 276', referer: https://torontoheadshot.com/corporate-headshots-gallery/
[Wed Apr 06 03:51:24.122084 2022] [proxy_fcgi:error] [pid 25222:tid 139852875994880] [client 54.164.82.255:0] AH01071: Got error 'PHP message: PHP Notice:  Trying to access array offset on value of type bool in /home/runcloud/webapps/Mautic/app/bundles/PageBundle/Entity/HitRepository.php on line 276', referer: https://torontoheadshot.com/about-me/

[rcheesley]

It looks like you have not fully completed the upgrade.

See this thread which has the same error:

Error after upgrading to 4.2 clearing cache fails and error: Unknown column last_built_date in field list

Right - @tobsowo had a similar problem. Other than the usual ‘don’t update in the browser’ message, here’s what helped him: Clear the cache by deleting the cache folder Follow these steps:

[aglyons]

I restored a BU of 4.1.2 and retried the update to 4.2.1. Exact same issue popped up. It gets stuck on the “Clearing Application Cache” step and stays there.

Could this be an issue upgrading from v4.1.2 to 4.2.1 skipping 4.2.0?

Apache Error Log

[Wed Apr 06 10:56:47.500230 2022] [proxy_fcgi:error] [pid 26187:tid 139852867602176] [client 76.70.83.119: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: Symfony\\Component\\Filesystem\\Exception\\IOException: Cannot rename "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerBxY3MPB/getDoctrineMigrations_UpToDateCommandService.phpjPisBF" to "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerBxY3MPB/getDoctrineMigrations_UpToDateCommandService.php". - in file /home/runcloud/webapps/Mautic/vendor/symfony/filesystem/Filesystem.php - at line 290'
[Wed Apr 06 10:51:47.146398 2022] [proxy_fcgi:error] [pid 26186:tid 139852909565696] [client 76.70.83.119: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: Symfony\\Component\\Filesystem\\Exception\\IOException: Cannot rename "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerW2qxRpG/getMautic_Helper_PhoneNumberService.phpwYgpzz" to "/home/runcloud/webapps/Mautic/var/cache/prod/ContainerW2qxRpG/getMautic_Helper_PhoneNumberService.php". - in file /home/runcloud/webapps/Mautic/vendor/symfony/filesystem/Filesystem.php - at line 290'

NGINX Access Log

76.70.83.119 - - [06/Apr/2022:11:11:45 -0400] "GET /upgrade/upgrade.php?task=clearCache&updateState=eyJwbHVnaW5Db21wbGV0ZSI6dHJ1ZSwiYnVuZGxlQ29tcGxldGUiOnRydWUsImNhY2hlQ29tcGxldGUiOmZhbHNlLCJjb3JlQ29tcGxldGUiOnRydWUsInZlbmRvckNvbXBsZXRlIjp0cnVlLCJjb21wbGV0ZWRCdW5kbGVzIjp7IkVtYWlsQnVuZGxlIjp0cnVlLCJGb3JtQnVuZGxlIjp0cnVlLCJDaGFubmVsQnVuZGxlIjp0cnVlLCJVc2VyQnVuZGxlIjp0cnVlLCJDb25maWdCdW5kbGUiOnRydWUsIkR5bmFtaWNDb250ZW50QnVuZGxlIjp0cnVlLCJXZWJob29rQnVuZGxlIjp0cnVlLCJDYWNoZUJ1bmRsZSI6dHJ1ZSwiQ2F0ZWdvcnlCdW5kbGUiOnRydWUsIlNtc0J1bmRsZSI6dHJ1ZSwiUG9pbnRCdW5kbGUiOnRydWUsIlN0YXRzQnVuZGxlIjp0cnVlLCJNYXJrZXRwbGFjZUJ1bmRsZSI6dHJ1ZSwiRGFzaGJvYXJkQnVuZGxlIjp0cnVlLCJSZXBvcnRCdW5kbGUiOnRydWUsIkxlYWRCdW5kbGUiOnRydWUsIlF1ZXVlQnVuZGxlIjp0cnVlLCJTdGFnZUJ1bmRsZSI6dHJ1ZSwiQXNzZXRCdW5kbGUiOnRydWUsIkluc3RhbGxCdW5kbGUiOnRydWUsIk5vdGlmaWNhdGlvbkJ1bmRsZSI6dHJ1ZSwiQXBpQnVuZGxlIjp0cnVlLCJQYWdlQnVuZGxlIjp0cnVlLCJJbnRlZ3JhdGlvbnNCdW5kbGUiOnRydWUsIkNhbXBhaWduQnVuZGxlIjp0cnVlLCJDb3JlQnVuZGxlIjp0cnVlLCJDYWxlbmRhckJ1bmRsZSI6dHJ1ZSwiUGx1Z2luQnVuZGxlIjp0cnVlfSwiY29tcGxldGVkVmVuZG9ycyI6eyJzeW1mb255Ijp0cnVlLCJrYW1lcm1hbnMiOnRydWUsIm1hbGt1c2NoIjp0cnVlLCJwc3kiOnRydWUsImZyaWVuZHNvZnN5bWZvbnkiOnRydWUsInByZWRpcyI6dHJ1ZSwiZWd1bGlhcyI6dHJ1ZSwiamJyb2Fkd2F5Ijp0cnVlLCJtYWVubmNoZW4iOnRydWUsImd1enpsZWh0dHAiOnRydWUsImtucGxhYnMiOnRydWUsInN3aWZ0bWFpbGVyIjp0cnVlLCJwaHAtYW1xcGxpYiI6dHJ1ZSwidGhlb2ZpZHJ5Ijp0cnVlLCJ0d2lnIjp0cnVlLCJhd3MiOnRydWUsInZva3UiOnRydWUsImV6eWFuZyI6dHJ1ZSwic2ltc2hhdW4iOnRydWUsImxpZ2h0c2FtbCI6dHJ1ZSwic2Vuc2lvIjp0cnVlLCJtb25vbG9nIjp0cnVlLCJzZWxkIjp0cnVlLCJwaHBzdGFuIjp0cnVlLCJsZWFndWUiOnRydWUsImNvbXBvc2VyIjp0cnVlLCJnYXVmcmV0dGUiOnRydWUsImJhbmR3aWR0aC10aHJvdHRsZSI6dHJ1ZSwicGhwb2ZmaWNlIjp0cnVlLCJtdGRvd2xpbmciOnRydWUsInJlYWN0Ijp0cnVlLCJzcGFya3Bvc3QiOnRydWUsIm1pc2QiOnRydWUsIm1hdG9tbyI6dHJ1ZSwic2VuZGdyaWQiOnRydWUsInN0YWNrIjp0cnVlLCJqbXMiOnRydWUsIm9uZXVwIjp0cnVlLCJsYW1pbmFzIjp0cnVlLCJnZW9pcDIiOnRydWUsImludGVydmVudGlvbiI6dHJ1ZSwiam9vbWxhIjp0cnVlLCJmcmllbmRzb2ZwaHAiOnRydWUsIm1yY2xheSI6dHJ1ZSwicm9icmljaGFyZHMiOnRydWUsImNsdWUiOnRydWUsIm5veGxvZ2ljIjp0cnVlLCJ0d2lsaW8iOnRydWUsInN0dWRpby00MiI6dHJ1ZSwicGhwLWh0dHAiOnRydWUsIm1hdXRpYyI6dHJ1ZSwibWFya2Jha2VyIjp0cnVlLCJtdXN0YW5nb3N0YW5nIjp0cnVlLCJyYW1zZXkiOnRydWUsInBzciI6dHJ1ZSwicGhwc2VjbGliIjp0cnVlLCJoZWxpb3MtYWciOnRydWUsImdpZ2dzZXkiOnRydWUsImp1c3RpbnJhaW5ib3ciOnRydWUsImRvY3RyaW5lIjp0cnVlLCJwZGEiOnRydWUsImJhcnJ5dmRoIjp0cnVlLCJuaWtpYyI6dHJ1ZSwicmFsb3VwaGllIjp0cnVlLCJ0aWdodGVuY28iOnRydWUsIm1heG1pbmQiOnRydWUsIndpbGxkdXJhbmQiOnRydWUsIm1heG1pbmQtZGIiOnRydWUsImlwMmxvY2F0aW9uIjp0cnVlLCJsZWV6eSI6dHJ1ZSwibXljbGFicyI6dHJ1ZSwicGFyYWdvbmllIjp0cnVlfSwiY29tcGxldGVkU3ltZm9ueSI6eyJyb3V0aW5nIjp0cnVlLCJodHRwLWNsaWVudCI6dHJ1ZSwiY2FjaGUiOnRydWUsImVycm9yLWhhbmRsZXIiOnRydWUsIm1vbm9sb2ctYnVuZGxlIjp0cnVlLCJ5YW1sIjp0cnVlLCJzZXJ2aWNlLWNvbnRyYWN0cyI6dHJ1ZSwidmFyLWR1bXBlciI6dHJ1ZSwidHJhbnNsYXRpb24iOnRydWUsInBvbHlmaWxsLW1ic3RyaW5nIjp0cnVlLCJpbmZsZWN0b3IiOnRydWUsImh0dHAtY2xpZW50LWNvbnRyYWN0cyI6dHJ1ZSwiZXhwcmVzc2lvbi1sYW5ndWFnZSI6dHJ1ZSwiaHR0cC1mb3VuZGF0aW9uIjp0cnVlLCJjc3Mtc2VsZWN0b3IiOnRydWUsInBvbHlmaWxsLWludGwtbm9ybWFsaXplciI6dHJ1ZSwiY29uc29sZSI6dHJ1ZSwicG9seWZpbGwtaW50bC1ncmFwaGVtZSI6dHJ1ZSwicG9seWZpbGwtaW50bC1pZG4iOnRydWUsInBvbHlmaWxsLXBocDgxIjp0cnVlLCJwb2x5ZmlsbC1pbnRsLWljdSI6dHJ1ZSwicG9seWZpbGwtcGhwNzQiOnRydWUsImRvY3RyaW5lLWJyaWRnZSI6dHJ1ZSwidGVtcGxhdGluZyI6dHJ1ZSwicG9seWZpbGwtY3R5cGUiOnRydWUsImZpbGVzeXN0ZW0iOnRydWUsInBvbHlmaWxsLXBocDczIjp0cnVlLCJmaW5kZXIiOnRydWUsInBvbHlmaWxsLXBocDgwIjp0cnVlLCJzZWN1cml0eS1idW5kbGUiOnRydWUsImRlcGVuZGVuY3ktaW5qZWN0aW9uIjp0cnVlLCJzd2lmdG1haWxlci1idW5kbGUiOnRydWUsInZhbGlkYXRvciI6dHJ1ZSwiY2FjaGUtY29udHJhY3RzIjp0cnVlLCJjb25maWciOnRydWUsImRvdGVudiI6dHJ1ZSwiZm9ybSI6dHJ1ZSwicG9seWZpbGwtaWNvbnYiOnRydWUsIm1vbm9sb2ctYnJpZGdlIjp0cnVlLCJwcm9wZXJ0eS1hY2Nlc3MiOnRydWUsInNlY3VyaXR5Ijp0cnVlLCJ0d2lnLWJ1bmRsZSI6dHJ1ZSwiZGVwcmVjYXRpb24tY29udHJhY3RzIjp0cnVlLCJmbGV4Ijp0cnVlLCJ2YXItZXhwb3J0ZXIiOnRydWUsInR3aWctYnJpZGdlIjp0cnVlLCJpbnRsIjp0cnVlLCJhc3NldCI6dHJ1ZSwic3RvcHdhdGNoIjp0cnVlLCJldmVudC1kaXNwYXRjaGVyLWNvbnRyYWN0cyI6dHJ1ZSwibG9jayI6dHJ1ZSwidHJhbnNsYXRpb24tY29udHJhY3RzIjp0cnVlLCJzdHJpbmciOnRydWUsImZyYW1ld29yay1idW5kbGUiOnRydWUsIm9wdGlvbnMtcmVzb2x2ZXIiOnRydWUsImV2ZW50LWRpc3BhdGNoZXIiOnRydWUsInByb2Nlc3MiOnRydWUsInNlY3VyaXR5LWFjbCI6dHJ1ZSwibWltZSI6dHJ1ZSwiZGVidWciOnRydWUsInBvbHlmaWxsLXBocDcyIjp0cnVlLCJodHRwLWtlcm5lbCI6dHJ1ZX19&_=1649256651612&mauticUserLastActive=1348&mauticLastNotificationId= HTTP/2.0" 200 1627 "https://marketing.torontoheadshot.com/s/update" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36" "-"
76.70.83.119 - - [06/Apr/2022:11:11:45 -0400] "GET /upgrade/upgrade.php?task=clearCache&updateState=eyJwbHVnaW5Db21wbGV0ZSI6dHJ1ZSwiYnVuZGxlQ29tcGxldGUiOnRydWUsImNhY2hlQ29tcGxldGUiOmZhbHNlLCJjb3JlQ29tcGxldGUiOnRydWUsInZlbmRvckNvbXBsZXRlIjp0cnVlLCJjb21wbGV0ZWRCdW5kbGVzIjp7IkVtYWlsQnVuZGxlIjp0cnVlLCJGb3JtQnVuZGxlIjp0cnVlLCJDaGFubmVsQnVuZGxlIjp0cnVlLCJVc2VyQnVuZGxlIjp0cnVlLCJDb25maWdCdW5kbGUiOnRydWUsIkR5bmFtaWNDb250ZW50QnVuZGxlIjp0cnVlLCJXZWJob29rQnVuZGxlIjp0cnVlLCJDYWNoZUJ1bmRsZSI6dHJ1ZSwiQ2F0ZWdvcnlCdW5kbGUiOnRydWUsIlNtc0J1bmRsZSI6dHJ1ZSwiUG9pbnRCdW5kbGUiOnRydWUsIlN0YXRzQnVuZGxlIjp0cnVlLCJNYXJrZXRwbGFjZUJ1bmRsZSI6dHJ1ZSwiRGFzaGJvYXJkQnVuZGxlIjp0cnVlLCJSZXBvcnRCdW5kbGUiOnRydWUsIkxlYWRCdW5kbGUiOnRydWUsIlF1ZXVlQnVuZGxlIjp0cnVlLCJTdGFnZUJ1bmRsZSI6dHJ1ZSwiQXNzZXRCdW5kbGUiOnRydWUsIkluc3RhbGxCdW5kbGUiOnRydWUsIk5vdGlmaWNhdGlvbkJ1bmRsZSI6dHJ1ZSwiQXBpQnVuZGxlIjp0cnVlLCJQYWdlQnVuZGxlIjp0cnVlLCJJbnRlZ3JhdGlvbnNCdW5kbGUiOnRydWUsIkNhbXBhaWduQnVuZGxlIjp0cnVlLCJDb3JlQnVuZGxlIjp0cnVlLCJDYWxlbmRhckJ1bmRsZSI6dHJ1ZSwiUGx1Z2luQnVuZGxlIjp0cnVlfSwiY29tcGxldGVkVmVuZG9ycyI6eyJzeW1mb255Ijp0cnVlLCJrYW1lcm1hbnMiOnRydWUsIm1hbGt1c2NoIjp0cnVlLCJwc3kiOnRydWUsImZyaWVuZHNvZnN5bWZvbnkiOnRydWUsInByZWRpcyI6dHJ1ZSwiZWd1bGlhcyI6dHJ1ZSwiamJyb2Fkd2F5Ijp0cnVlLCJtYWVubmNoZW4iOnRydWUsImd1enpsZWh0dHAiOnRydWUsImtucGxhYnMiOnRydWUsInN3aWZ0bWFpbGVyIjp0cnVlLCJwaHAtYW1xcGxpYiI6dHJ1ZSwidGhlb2ZpZHJ5Ijp0cnVlLCJ0d2lnIjp0cnVlLCJhd3MiOnRydWUsInZva3UiOnRydWUsImV6eWFuZyI6dHJ1ZSwic2ltc2hhdW4iOnRydWUsImxpZ2h0c2FtbCI6dHJ1ZSwic2Vuc2lvIjp0cnVlLCJtb25vbG9nIjp0cnVlLCJzZWxkIjp0cnVlLCJwaHBzdGFuIjp0cnVlLCJsZWFndWUiOnRydWUsImNvbXBvc2VyIjp0cnVlLCJnYXVmcmV0dGUiOnRydWUsImJhbmR3aWR0aC10aHJvdHRsZSI6dHJ1ZSwicGhwb2ZmaWNlIjp0cnVlLCJtdGRvd2xpbmciOnRydWUsInJlYWN0Ijp0cnVlLCJzcGFya3Bvc3QiOnRydWUsIm1pc2QiOnRydWUsIm1hdG9tbyI6dHJ1ZSwic2VuZGdyaWQiOnRydWUsInN0YWNrIjp0cnVlLCJqbXMiOnRydWUsIm9uZXVwIjp0cnVlLCJsYW1pbmFzIjp0cnVlLCJnZW9pcDIiOnRydWUsImludGVydmVudGlvbiI6dHJ1ZSwiam9vbWxhIjp0cnVlLCJmcmllbmRzb2ZwaHAiOnRydWUsIm1yY2xheSI6dHJ1ZSwicm9icmljaGFyZHMiOnRydWUsImNsdWUiOnRydWUsIm5veGxvZ2ljIjp0cnVlLCJ0d2lsaW8iOnRydWUsInN0dWRpby00MiI6dHJ1ZSwicGhwLWh0dHAiOnRydWUsIm1hdXRpYyI6dHJ1ZSwibWFya2Jha2VyIjp0cnVlLCJtdXN0YW5nb3N0YW5nIjp0cnVlLCJyYW1zZXkiOnRydWUsInBzciI6dHJ1ZSwicGhwc2VjbGliIjp0cnVlLCJoZWxpb3MtYWciOnRydWUsImdpZ2dzZXkiOnRydWUsImp1c3RpbnJhaW5ib3ciOnRydWUsImRvY3RyaW5lIjp0cnVlLCJwZGEiOnRydWUsImJhcnJ5dmRoIjp0cnVlLCJuaWtpYyI6dHJ1ZSwicmFsb3VwaGllIjp0cnVlLCJ0aWdodGVuY28iOnRydWUsIm1heG1pbmQiOnRydWUsIndpbGxkdXJhbmQiOnRydWUsIm1heG1pbmQtZGIiOnRydWUsImlwMmxvY2F0aW9uIjp0cnVlLCJsZWV6eSI6dHJ1ZSwibXljbGFicyI6dHJ1ZSwicGFyYWdvbmllIjp0cnVlfSwiY29tcGxldGVkU3ltZm9ueSI6eyJyb3V0aW5nIjp0cnVlLCJodHRwLWNsaWVudCI6dHJ1ZSwiY2FjaGUiOnRydWUsImVycm9yLWhhbmRsZXIiOnRydWUsIm1vbm9sb2ctYnVuZGxlIjp0cnVlLCJ5YW1sIjp0cnVlLCJzZXJ2aWNlLWNvbnRyYWN0cyI6dHJ1ZSwidmFyLWR1bXBlciI6dHJ1ZSwidHJhbnNsYXRpb24iOnRydWUsInBvbHlmaWxsLW1ic3RyaW5nIjp0cnVlLCJpbmZsZWN0b3IiOnRydWUsImh0dHAtY2xpZW50LWNvbnRyYWN0cyI6dHJ1ZSwiZXhwcmVzc2lvbi1sYW5ndWFnZSI6dHJ1ZSwiaHR0cC1mb3VuZGF0aW9uIjp0cnVlLCJjc3Mtc2VsZWN0b3IiOnRydWUsInBvbHlmaWxsLWludGwtbm9ybWFsaXplciI6dHJ1ZSwiY29uc29sZSI6dHJ1ZSwicG9seWZpbGwtaW50bC1ncmFwaGVtZSI6dHJ1ZSwicG9seWZpbGwtaW50bC1pZG4iOnRydWUsInBvbHlmaWxsLXBocDgxIjp0cnVlLCJwb2x5ZmlsbC1pbnRsLWljdSI6dHJ1ZSwicG9seWZpbGwtcGhwNzQiOnRydWUsImRvY3RyaW5lLWJyaWRnZSI6dHJ1ZSwidGVtcGxhdGluZyI6dHJ1ZSwicG9seWZpbGwtY3R5cGUiOnRydWUsImZpbGVzeXN0ZW0iOnRydWUsInBvbHlmaWxsLXBocDczIjp0cnVlLCJmaW5kZXIiOnRydWUsInBvbHlmaWxsLXBocDgwIjp0cnVlLCJzZWN1cml0eS1idW5kbGUiOnRydWUsImRlcGVuZGVuY3ktaW5qZWN0aW9uIjp0cnVlLCJzd2lmdG1haWxlci1idW5kbGUiOnRydWUsInZhbGlkYXRvciI6dHJ1ZSwiY2FjaGUtY29udHJhY3RzIjp0cnVlLCJjb25maWciOnRydWUsImRvdGVudiI6dHJ1ZSwiZm9ybSI6dHJ1ZSwicG9seWZpbGwtaWNvbnYiOnRydWUsIm1vbm9sb2ctYnJpZGdlIjp0cnVlLCJwcm9wZXJ0eS1hY2Nlc3MiOnRydWUsInNlY3VyaXR5Ijp0cnVlLCJ0d2lnLWJ1bmRsZSI6dHJ1ZSwiZGVwcmVjYXRpb24tY29udHJhY3RzIjp0cnVlLCJmbGV4Ijp0cnVlLCJ2YXItZXhwb3J0ZXIiOnRydWUsInR3aWctYnJpZGdlIjp0cnVlLCJpbnRsIjp0cnVlLCJhc3NldCI6dHJ1ZSwic3RvcHdhdGNoIjp0cnVlLCJldmVudC1kaXNwYXRjaGVyLWNvbnRyYWN0cyI6dHJ1ZSwibG9jayI6dHJ1ZSwidHJhbnNsYXRpb24tY29udHJhY3RzIjp0cnVlLCJzdHJpbmciOnRydWUsImZyYW1ld29yay1idW5kbGUiOnRydWUsIm9wdGlvbnMtcmVzb2x2ZXIiOnRydWUsImV2ZW50LWRpc3BhdGNoZXIiOnRydWUsInByb2Nlc3MiOnRydWUsInNlY3VyaXR5LWFjbCI6dHJ1ZSwibWltZSI6dHJ1ZSwiZGVidWciOnRydWUsInBvbHlmaWxsLXBocDcyIjp0cnVlLCJodHRwLWtlcm5lbCI6dHJ1ZX19&_=1649256651611&mauticUserLastActive=1348&mauticLastNotificationId= HTTP/2.0" 200 1627 "https://marketing.torontoheadshot.com/s/update" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36" "-"

Mautic Production Log

[2022-04-06 13:30: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:132)",“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’”}

[rcheesley]

Probably this is server config related, running out of resources at some point in the update. Please update at the command line and not in the browser.

[aglyons]

@rcheesley I read the post about the changes to v5. I was just about to write a post in another forum regarding the shift to Composer.

I have no idea what Composer is. I’m running my Mautic in a webapp on Runcloud. The server is a Linode box but Runcloud manages all my sites.

As such, SSHing into the server and running commands is concerning in that it can affect all of my sites. Runcloud configures the servers in their own way. If something were to go wrong with a command I could be stuck trying to repair the entire server. Not a pleasurable thing.

I also run a couple of OSTicket installs and the update process for that is simple. Clear out the webservers DIR and extract the new versions zip file. The scripts are smart enough to process any DB changes and everything is back up in less than a minute. Why could Mautic not operate the same way?

I fear that I won’t be able to keep up to date if the CLI is the only way to update Mautic going forward.

If it helps…PHP Settings

[aglyons]

@rcheesley

Any comments or opinions regarding my viewpoint here?

I can’t be the only person in this position.

[adiux]

Hi @aglyons, this looks like a problem with the database migration. As @rcheesley was saying:

Probably this is server config related, running out of resources at some point in the update. Please update at the command line and not in the browser.

So you can adapt your server config or try the command line. Should you decide to try it in the command line you would need to run the migration command.
bin/console doctrine:migration:migrate

If you do a database backup before you should be relatively safe.

[aglyons]

SSH’d into my server, ran the code you suggested and all I got back was

“No such file or directory”

It’s great and all that developers want to move to CLI and composer (whatever that is), but many users of Mautic are not developers, including myself.

I have no idea what I need to do to process an update.

Yeah, Mautic is free which I appreciate. But if you make it hard to use, people are going to drop it. Just as I am considering.