# URGENT: Upgrade to 4.2.1 \> Error viewing contact details

**URL:** <https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637>\
**Category:** Product Support\
**Tags:** mautic-4\
**Created:** [April 6, 2022, 1:45pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637 "2022-04-06T13:45:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![aglyons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/aglyons/32/2825_2.png) [@aglyons](https://forum.mautic.org/u/aglyons)\
**Post date:** [April 6, 2022, 1:45pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/1 "2022-04-06T13:45:00Z")

</div>

**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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/2/286d78691a0d6f51e3b53988bf32398160263af9.png)

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**

```auto
[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/

```

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [April 6, 2022, 2:20pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/2 "2022-04-06T14:20:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![aglyons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/aglyons/32/2825_2.png) [@aglyons](https://forum.mautic.org/u/aglyons)\
**Post date:** [April 6, 2022, 3:15pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/3 "2022-04-06T15:15:12Z")

</div>

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?**

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/0/040fcaa31f01c4bc69d5531ba9de538291bf0ece.png)

**Apache Error Log**

```auto
[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**

```auto
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’”}

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [April 6, 2022, 3:31pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/4 "2022-04-06T15:31:30Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![aglyons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/aglyons/32/2825_2.png) [@aglyons](https://forum.mautic.org/u/aglyons)\
**Post date:** [April 6, 2022, 3:38pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/5 "2022-04-06T15:38:29Z")

</div>

@silavapi 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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/e240f81c5c139acf3d59578d20a07892d5f53a02.png)

---

<div class="post-metadata">

**Author:** ![aglyons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/aglyons/32/2825_2.png) [@aglyons](https://forum.mautic.org/u/aglyons)\
**Post date:** [April 12, 2022, 11:04pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/6 "2022-04-12T23:04:43Z")

</div>

@silavapi

Any comments or opinions regarding my viewpoint here?

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

---

<div class="post-metadata">

**Author:** ![adiux](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/adiux/32/5793_2.png) [@adiux](https://forum.mautic.org/u/adiux)\
**Post date:** [April 13, 2022, 6:58am UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/7 "2022-04-13T06:58:24Z")

</div>

Hi @aglyons, this looks like a problem with the database migration. As @silavapi 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.

---

<div class="post-metadata">

**Author:** ![aglyons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/aglyons/32/2825_2.png) [@aglyons](https://forum.mautic.org/u/aglyons)\
**Post date:** [May 16, 2022, 6:13pm UTC](https://forum.mautic.org/t/urgent-upgrade-to-4-2-1-error-viewing-contact-details/23637/8 "2022-05-16T18:13:36Z")

</div>

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.