# Database Error after success update to 3.3.2

**URL:** <https://forum.mautic.org/t/database-error-after-success-update-to-3-3-2/18735>\
**Category:** Product Support\
**Created:** [March 27, 2021, 12:50am UTC](https://forum.mautic.org/t/database-error-after-success-update-to-3-3-2/18735 "2021-03-27T00:50:35Z")\
**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:** [March 27, 2021, 12:50am UTC](https://forum.mautic.org/t/database-error-after-success-update-to-3-3-2/18735/1 "2021-03-27T00:50:35Z")

</div>

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

**Your problem**  
My problem is:  
Database error when mautic success updated to 3.3.2

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

These errors are showing in the log:

[2021-03-27 00:00:09] console.ERROR: Error thrown while running command “‘mautic:webhooks:command’ --env=prod”. Message: “Command “mautic:webhooks:command” is not defined. Did you mean this? mautic:webhooks:process” {“exception”:"[object] (Symfony\Component\Console\Exception\CommandNotFoundException(code: 0): Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process at /home/asokamai/public\_html/vendor/symfony/console/Application.php:646)",“command”:"‘mautic:webhooks:command’ --env=prod",“message”:“Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process”}   
[2021-03-27 00:15:05] console.ERROR: Error thrown while running command “‘mautic:webhooks:command’ --env=prod”. Message: “Command “mautic:webhooks:command” is not defined. Did you mean this? mautic:webhooks:process” {“exception”:"[object] (Symfony\Component\Console\Exception\CommandNotFoundException(code: 0): Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process at /home/asokamai/public\_html/vendor/symfony/console/Application.php:646)",“command”:"‘mautic:webhooks:command’ --env=prod",“message”:“Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process”}   
[2021-03-27 07:20:44] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --no-interaction --env=prod --no-debug”. Message: “An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2” {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)",“command”:“doctrine:migrations:migrate --no-interaction --env=prod --no-debug”,“message”:“An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2”}   
[2021-03-27 07:23:58] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --no-interaction --env=prod --no-debug”. Message: “An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2” {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)",“command”:“doctrine:migrations:migrate --no-interaction --env=prod --no-debug”,“message”:“An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2”}   
[2021-03-27 07:25:49] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --no-interaction --env=prod --no-debug”. Message: “An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2” {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)",“command”:“doctrine:migrations:migrate --no-interaction --env=prod --no-debug”,“message”:“An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2”}   
[2021-03-27 07:25:56] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --no-interaction --env=prod --no-debug”. Message: “An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2” {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)",“command”:“doctrine:migrations:migrate --no-interaction --env=prod --no-debug”,“message”:“An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2”}   
[2021-03-27 00:30:11] console.ERROR: Error thrown while running command “‘mautic:webhooks:command’ --env=prod”. Message: “Command “mautic:webhooks:command” is not defined. Did you mean this? mautic:webhooks:process” {“exception”:"[object] (Symfony\Component\Console\Exception\CommandNotFoundException(code: 0): Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process at /home/asokamai/public\_html/vendor/symfony/console/Application.php:646)",“command”:"‘mautic:webhooks:command’ --env=prod",“message”:“Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process”}   
[2021-03-27 07:34:39] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --no-interaction --env=prod --no-debug”. Message: “An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2” {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)",“command”:“doctrine:migrations:migrate --no-interaction --env=prod --no-debug”,“message”:“An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2”}   
[2021-03-27 00:45:05] console.ERROR: Error thrown while running command “‘mautic:webhooks:command’ --env=prod”. Message: “Command “mautic:webhooks:command” is not defined. Did you mean this? mautic:webhooks:process” {“exception”:"[object] (Symfony\Component\Console\Exception\CommandNotFoundException(code: 0): Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process at /home/asokamai/public\_html/vendor/symfony/console/Application.php:646)",“command”:"‘mautic:webhooks:command’ --env=prod",“message”:“Command “mautic:webhooks:command” is not defined.\n\nDid you mean this?\n mautic:webhooks:process”}   
[2021-03-27 07:47:56] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --no-interaction --env=prod --no-debug”. Message: “An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2” {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2 at /home/asokamai/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)",“command”:“doctrine:migrations:migrate --no-interaction --env=prod --no-debug”,“message”:“An exception occurred while executing ‘ALTER TABLE maucv\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), ‘-’, LPAD(MONTH(date\_sent), 2, ‘0’), ‘-’, LPAD(DAY(date\_sent), 2, ‘0’))) COMMENT ‘(DC2Type:generated)’;\n ALTER TABLE maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’:\n\nYou 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 maucv\_email\_stats ADD INDEX `maucv_generated_sent_date_email_id`(…’ at line 2”}

Steps I have tried to fix the problem: