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

**URL:** <https://forum.mautic.org/t/cant-access-configuration-contacts-reports-etc-after-upgrade-from-v-3-1-0-to-3-3-3/19315>\
**Category:** Mautic 3 - Install/Upgrade Support\
**Created:** [May 3, 2021, 10:38pm UTC](https://forum.mautic.org/t/cant-access-configuration-contacts-reports-etc-after-upgrade-from-v-3-1-0-to-3-3-3/19315 "2021-05-03T22:38:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![yukzanaly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/yukzanaly/32/1769_2.png) [@yukzanaly](https://forum.mautic.org/u/yukzanaly)\
**Post date:** [May 3, 2021, 10:38pm UTC](https://forum.mautic.org/t/cant-access-configuration-contacts-reports-etc-after-upgrade-from-v-3-1-0-to-3-3-3/19315/1 "2021-05-03T22:38:22Z")

</div>

**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.