# Problems after updating from 4.0.0 to 4.4.3 (Cannot update schema)

**URL:** <https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822>\
**Category:** Mautic 4 Install/Upgrade Support\
**Created:** [October 25, 2022, 11:10am UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822 "2022-10-25T11:10:13Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![patodorf](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/patodorf/32/3034_2.png) [@patodorf](https://forum.mautic.org/u/patodorf)\
**Post date:** [October 25, 2022, 11:10am UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822/1 "2022-10-25T11:10:13Z")

</div>

**Your software**  
_My PHP version is_ :7.4.32  
\*My MySQL/MariaDB version is:10.2.33-MariaDB-1:10.2.33+maria~bionic

**Updating/Installing Errors**  
\*I am: Updating  
\*Upgrading/ via: Web  
_These errors are showing in the installer_ :

_These errors are showing in the Mautic log_ :

[2022-10-25 07:24:08] 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 lead\_tags t0 INNER JOIN lead\_tags\_xref ON t0.id = lead\_tags\_xref.tag\_id WHERE lead\_tags\_xref.lead\_id = ? ORDER BY t0.tag ASC’ with params [“38531”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.description’ in ‘field list’ - in file /var/www/vhosts/mail.werecruit.it/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 79 {“hostname”:“werecruitit”,“pid”:5931}

**Your problem**  
_My problem is_ :

I cannot update Schema from /update/schema  
I cannot Edit contacts.

_Steps I have tried to fix the problem_ :

Clear Cache  
Update Schema

---

<div class="post-metadata">

**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\
**Post date:** [October 26, 2022, 11:03pm UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822/2 "2022-10-26T23:03:24Z")

</div>

Please look into cli way of updating: \< [Updating at command line | Mautic](https://docs.mautic.org/en/setup/how-to-update-mautic/updating-at-command-line) \> as its more stable.

---

<div class="post-metadata">

**Author:** ![patodorf](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/patodorf/32/3034_2.png) [@patodorf](https://forum.mautic.org/u/patodorf)\
**Post date:** [November 17, 2022, 3:49am UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822/3 "2022-11-17T03:49:41Z")

</div>

Thank you for your answer…

I’m trying that, but I don’t even know how to access the command line.

I installed it on my Digital Ocean / Plesk.

Can you please just point me where to go/search?

Thank you in advance!!!

---

<div class="post-metadata">

**Author:** ![robm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/robm/32/260_2.png) [@robm](https://forum.mautic.org/u/robm)\
**Post date:** [November 17, 2022, 7:53am UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822/4 "2022-11-17T07:53:19Z")

</div>

Log into your DO Account  
Selecet your Droplet  
Click access  
click launch droplet console.

That will give you command line access.

Take a snap shot before doing anything.

The follow these instructions.

`php /var/www/mautic/bin/console mautic:update:apply`

U will need to set the right path to your mautic for example a diff option might be

`php /var/www/html/mautic/bin/console mautic:update:apply`

Make sure your path is correct.

You will be asked if you are sure. Enter Y

This goes and gets the latest version of mautic and runs the update - simple.

Once this complete u need to finish by

`php /var/www/mautic/bin/console mautic:update:apply --finish`

Then we need to clear the cache

`rm -rf /var/www/mautic/var/cache/*`

And finally make sure the file permissions are correct

`chown www-data:www-data /var/www/mautic`

---

<div class="post-metadata">

**Author:** ![patodorf](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/patodorf/32/3034_2.png) [@patodorf](https://forum.mautic.org/u/patodorf)\
**Post date:** [November 17, 2022, 5:55pm UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822/5 "2022-11-17T17:55:55Z")

</div>

Thank you very much for the hand!

**Im doing this:**  
root@posta-02:~# php/var/www/mautic/bin/console mautic:update:find

**And I’m getting this meesage:**  
Could not open input file: /var/www/mautic/bin/console

If I’m making a mistake with the path, how can I find it?

---

<div class="post-metadata">

**Author:** ![patodorf](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/patodorf/32/3034_2.png) [@patodorf](https://forum.mautic.org/u/patodorf)\
**Post date:** [November 29, 2022, 6:21pm UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822/6 "2022-11-29T18:21:07Z")

</div>

Sorry, I don’t want to be an annoyance but I’ve been looking and I can’t find the path  
(I don’t even know how to Google it…)

Can someone please give me a clue? I’m needing to know what the path is so I can run the command line!

---

<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:** [November 29, 2022, 6:24pm UTC](https://forum.mautic.org/t/problems-after-updating-from-4-0-0-to-4-4-3-cannot-update-schema/25822/7 "2022-11-29T18:24:23Z")

</div>

The bin/console is a directory in your Mautic instance.

So you need to find out the file path on your server to Mautic, and then add /bin/console to the end of it.

You can also check in Mautic’s system information (under the config menu at the top right, looks like a cog) in the file & folder permissions, that should give you a headstart!
