# Problems with failed web update **URL:** \ **Category:** Product Support\ **Created:** [May 26, 2022, 12:14pm UTC](https://forum.mautic.org/t/problems-with-failed-web-update/24225 "2022-05-26T12:14:39Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![siteleas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/siteleas/32/1047_2.png) [@siteleas](https://forum.mautic.org/u/siteleas)\ **Post date:** [May 26, 2022, 12:14pm UTC](https://forum.mautic.org/t/problems-with-failed-web-update/24225/1 "2022-05-26T12:14:39Z")
I was attempting to migrate from mautic 3.x to mautic 4.x using the update in the web console. That didn’t complete. So I dropped down and performed the steps outlined here - [Mautic update failed - how to recover | Mautic](https://docs.mautic.org/en/troubleshooting/update-failed) This is where I am stuck: autopilot.coolreturns.ca \> php bin/console doctrine:migration:migrate ++ adding generated column generated\_email\_domain → ALTER TABLE mauo1la\_leads ADD generated\_email\_domain VARCHAR(255) AS (SUBSTRING(email, LOCATE("@", email) + 1)) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mauo1la\_leads ADD INDEX `mauo1la_generated_email_domain`(generated\_email\_domain) In AbstractMySQLDriver.php line 98: An exception occurred while executing ‘ALTER TABLE mauo1la\_leads ADD generated\_email\_domain VARCHAR(255) AS (SUBSTRING(email, LOCATE("@", email) + 1 )) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mauo1la\_leads ADD INDEX `mauo1la_generated_email_domain`(generated\_email\_domain)’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE m auo1la\_leads ADD INDEX `mauo1la_generated_email_domain`(generated\_e’ at line 2 In ConnectionError.php line 21: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE m auo1la\_leads ADD INDEX `mauo1la_generated_email_domain`(generated\_e’ at line 2 doctrine:migrations:migrate [–write-sql [WRITE-SQL]] [–dry-run] [–query-time] [–allow-no-migration] [–all-or-nothing [ALL-OR-NOTHING]] [–configuration [CONFIGURATION]] [–db-configuration [DB-CONFIGURATION]] [–db DB] [–em EM] [–shard SHARD] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–] [] What do I do to resolve this? ---
**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:** [May 26, 2022, 12:55pm UTC](https://forum.mautic.org/t/problems-with-failed-web-update/24225/2 "2022-05-26T12:55:07Z")
With a simple forum search for your error message I found this thread with a solution: > [@Strange Issue with Upgrading from 3.2.4 to 4.1.0](https://forum.mautic.org/t/strange-issue-with-upgrading-from-3-2-4-to-4-1-0/21964/5): > > I have now tried a few more tricks and nothing worked. I tried to delete all the contacts to see if it was something with the length of an email address or name. This did not work I tried to install 4.1.0 by itself and then import the old database - obviously this did not work either. Tried to upgrade to 3.3.4 first and then 4.1 - still did not work. I removed the two plugins that I have installed here: Multidomain and RSS feed - still did not work Perhaps you could try that? ---
**Author:** ![rotorfido](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rotorfido/32/580_2.png) [@rotorfido](https://forum.mautic.org/u/rotorfido)\ **Post date:** [May 30, 2022, 3:53pm UTC](https://forum.mautic.org/t/problems-with-failed-web-update/24225/3 "2022-05-30T15:53:23Z")
from my opinion Mauti needs more work, updates are so unreliable, they are buggy, how can you rely on a software if it can break any time…I think I am giving up beucase I see so many users breaking their mautic installations after upgrade…it is ridiculous… ---
**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\ **Post date:** [May 31, 2022, 8:02am UTC](https://forum.mautic.org/t/problems-with-failed-web-update/24225/4 "2022-05-31T08:02:46Z")
@rotorfido maybe you saw that Ruth replied to this message with a solution within the same day of posting - this is amazing. No one here is getting paid to help others, it is a community where people support each other. If you are having specific problems write them out here, there is a two fold benefit of this: 1. Maybe others have the same problem you are seeing. 2. Someone will reach out and help you creating a solution for any one that falls into point 1. I think Mautic is an amazing tool and has huge potential and we see it growing day by day.