Database Error after success update to 3.3.2

Product Support
1

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
image1361×441 9.65 KB

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:

1 Like