# Error when update to 4.1.0

**URL:** https://forum.mautic.org/t/error-when-update-to-4-1-0/21845
**Category:** Product Support
**Tags:** mautic-4
**Created:** [December 1, 2021, 1:41am UTC](https://forum.mautic.org/t/error-when-update-to-4-1-0/21845 "2021-12-01T01:41:50Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ekatronik](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ekatronik/32/120_2.png) [@ekatronik](https://forum.mautic.org/u/ekatronik)
#### Post date: [December 1, 2021, 1:41am UTC](https://forum.mautic.org/t/error-when-update-to-4-1-0/21845/1 "2021-12-01T01:41:50Z")

</div>

**Your software**  
My Mautic version is: 4.0.2  
My PHP version is: 7.4  
My Database type and version is:

**Your problem**  
My problem is:

I try update mautic via terminal console.

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

and the log file is this

```auto
[2021-12-01 01:35:46] mautic.NOTICE: Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing 'ALTER TABLE maudb_leads ADD generated_email_domain VARCHAR(255) AS (SUBSTRING(email, LOCATE("@", email) + 1)) COMMENT '(DC2Type:generated)'; ALTER TABLE maudb_leads ADD INDEX `maudb_generated_email_domain`(generated_email_domain)': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ALTER TABLE maudb_leads ADD INDEX `maudb_generated_email_domain`(generated_em...' at line 2 (uncaught exception) at /home/dsignpix/email.panduancepat.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 98 while running console command `doctrine:migrations:migrate` [] []
[2021-12-01 01:35:46] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 [] []
[2021-12-01 01:35:46] mautic.WARNING: Command `mautic:update:apply` exited with status code 1 [] []

```

Any advice?

thanks