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