Mautic Community Forums

Can't access configuration, contacts, reports etc after upgrade from v. 3.1.0 to 3.3.3

Your software
My PHP version is : 7.3
My MySQL/MariaDB version is (delete as applicable): MySQL/MariaDB version

Updating/Installing Errors
I am (delete as applicable): / Updating
Upgrading/installing via (delete as applicable) : Web /

These errors are showing in the installer :

These errors are showing in the Mautic log : Log from prod
[2021-05-04 05:11:32] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --no-interaction --env=prod --no-debug”. Message: “An exception occurred while executing ‘ALTER TABLE mau57_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 mau57_email_stats ADD INDEX mau57_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 mau57_email_stats ADD INDEX mau57_generated_sent_date_email_id(…’ at line 2” {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE mau57_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 mau57_email_stats ADD INDEX mau57_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 mau57_email_stats ADD INDEX mau57_generated_sent_date_email_id(…’ at line 2 at /home/wpmmyid/aufaniyukzanali.me/portal/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 mau57_email_stats ADD INDEX mau57_generated_sent_date_email_id(…’ at line 2 at /home/wpmmyid/aufaniyukzanali.me/portal/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 mau57_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 mau57_email_stats ADD INDEX mau57_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 mau57_email_stats ADD INDEX mau57_generated_sent_date_email_id(…’ at line 2”}

These errors are showing in the upgrade_log.txt file (located in the root of your Mautic instance when an upgrade has been attempted - ensure you remove or redact any sensitive data such as domain names in the file path) :

Your problem
My problem is :

I installed mautic on cPanel. First I created staging then I upgrade using web. when I go to /s/update it shows Great! You are running the current version of Mautic.

but, I can’t go to configuration, emails, contacts, reports and segments.

there’s no log files except from prod folder

Steps I have tried to fix the problem : I have clear cache folder.