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

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 AS id_1, t0.tag AS tag_2, t0.description AS description_3 FROM lead_tags t0 INNER JOIN lead_tags_xref ON = 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/ - 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

Please look into cli way of updating: < Updating at command line | Mautic > as its more stable.

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

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

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?

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!

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!