# Error on migrate to 4.4.0

**URL:** <https://forum.mautic.org/t/error-on-migrate-to-4-4-0/24778>\
**Category:** Mautic 4 Install/Upgrade Support\
**Created:** [July 15, 2022, 3:48pm UTC](https://forum.mautic.org/t/error-on-migrate-to-4-4-0/24778 "2022-07-15T15:48:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![abdou80](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/abdou80/32/6772_2.png) [@abdou80](https://forum.mautic.org/u/abdou80)\
**Post date:** [July 15, 2022, 3:48pm UTC](https://forum.mautic.org/t/error-on-migrate-to-4-4-0/24778/1 "2022-07-15T15:48:17Z")

</div>

**Your software**  
_My PHP version is_ : 7.4.30  
_My MySQL/MariaDB version is_ : 10.5.16-MariaDB-1:10.5.16+maria~bionic

**Updating/Installing Errors**  
_I am_ :Updating  
_Upgrading/installing via_ : Command Line

_These errors are showing in the installer_ :

php bin/console doctrine:migrations:migrate

```
                Mautic Migrations                    

```

WARNING! You are about to execute a database migration that could result in schema changes and data loss. Are you sure you wish to continue? (y/n)y  
Migrating up to 20220111202917 from 20200220172041

++ migrating 20200227110431

```
 -> CREATE INDEX dnc_channel_id_search ON lead_donotcontact (channel_id)

```

Migration 20200227110431 failed during Execution. Error An exception occurred while executing ‘CREATE INDEX dnc\_channel\_id\_search ON lead\_donotcontact (channel\_id)’:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘dnc\_channel\_id\_search’

In AbstractMySQLDriver.php line 128:

An exception occurred while executing ‘CREATE INDEX dnc\_channel\_id\_search ON lead\_donotcontact (channel\_id)’:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘dnc\_channel\_id\_search’

In Exception.php line 18:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘dnc\_channel\_id\_search’

In PDOConnection.php line 141:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘dnc\_channel\_id\_search’

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] [–] []

_These errors are showing in the Mautic log_ :

SQLSTATE[42000]: Syntax error or access violation: 1176 Key ‘manually\_removed’ doesn’t exist in table ‘l’ (uncaught exception) at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 while running console command `mautic:segments:update` {“hostname”:“ip-172-31-39-7”,“pid”:13803}  
[2022-07-15 15:45:02] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 {“hostname”:“ip-172-31-39-7”,“pid”:13803}  
[2022-07-15 15:45:02] mautic.DEBUG: CAMPAIGN: No events to process {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:45:02] mautic.DEBUG: CAMPAIGN: Triggering scheduled events {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:45:02] mautic.DEBUG: CAMPAIGN: 0 events scheduled to execute. {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:45:02] mautic.DEBUG: CAMPAIGN: No events to process {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:45:02] mautic.DEBUG: CAMPAIGN: Triggering inaction events {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:45:02] mautic.DEBUG: CAMPAIGN: No events to process {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:45:02] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT count(l.lead\_id) as thecount, l.leadlist\_id FROM lead\_lists\_leads l USE INDEX (manually\_removed) WHERE (l.leadlist\_id = 1) AND (l.manually\_removed = ?) GROUP BY l.leadlist\_id’ with params [0]:

SQLSTATE[42000]: Syntax error or access violation: 1176 Key ‘manually\_removed’ doesn’t exist in table ‘l’ (uncaught exception) at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 while running console command `mautic:campaigns:trigger` {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:45:02] mautic.WARNING: Command `mautic:campaigns:trigger` exited with status code 1 {“hostname”:“ip-172-31-39-7”,“pid”:13801}  
[2022-07-15 15:46:40] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘CREATE INDEX dnc\_channel\_id\_search ON lead\_donotcontact (channel\_id)’:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘dnc\_channel\_id\_search’ (uncaught exception) at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 while running console command `doctrine:migrations:migrate` {“hostname”:“ip-172-31-39-7”,“pid”:13818}  
[2022-07-15 15:46:40] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 {“hostname”:“ip-172-31-39-7”,“pid”:13818}

**Your problem**  
_My problem is_ :

Email marketing from mautic campaign is not sending

_Steps I have tried to fix the problem_ : no thing