# An error occurred while updating the database

**URL:** https://forum.mautic.org/t/an-error-occurred-while-updating-the-database/17056
**Category:** Product Support
**Created:** [November 17, 2020, 2:55pm UTC](https://forum.mautic.org/t/an-error-occurred-while-updating-the-database/17056 "2020-11-17T14:55:56Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![chervenkov](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/chervenkov/32/719_2.png) [@chervenkov](https://forum.mautic.org/u/chervenkov)
#### Post date: [November 17, 2020, 2:55pm UTC](https://forum.mautic.org/t/an-error-occurred-while-updating-the-database/17056/1 "2020-11-17T14:55:56Z")

</div>

**Your software**  
My Mautic version is: 3.2.1.  
My PHP version is:7.2.24, on Ubuntu 18.04  
My Database type and version is: MySQL

**Your problem**  
My problem is: i have this error : “An error occurred while updating the database. Check log for more details.” when i’m hitting this link: [https://mydomain/mautic/s/update/schema](https://mydomain/mautic/s/update/schema)

These errors are showing in the log:2020-11-17 14:31:29] mautic.NOTICE: Doctrine\DBAL\DBALException: Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. (uncaught exception) at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php line 436 while running console command `doctrine:migrations:migrate`    
[2020-11-17 14:31:29] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1    
[2020-11-17 14:31:29] mautic.ERROR: [UPGRADE ERROR] Exit code 1; Mautic Migrations \ Migrating up to 20200815153711 from 0 Migration 20181111095447 failed during Pre-Checks. Error Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. \ In AbstractPlatform.php line 436: \ Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. \ 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] [–] \

Steps I have tried to fix the problem:

---

<div class="post-metadata">

### Author: ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)
#### Post date: [November 19, 2020, 1:31am UTC](https://forum.mautic.org/t/an-error-occurred-while-updating-the-database/17056/2 "2020-11-19T01:31:12Z")

</div>

What version of MySQL do you run?

---

<div class="post-metadata">

### Author: ![dennisameling](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dennisameling/32/958_2.png) [@dennisameling](https://forum.mautic.org/u/dennisameling)
#### Post date: [November 24, 2020, 11:49am UTC](https://forum.mautic.org/t/an-error-occurred-while-updating-the-database/17056/3 "2020-11-24T11:49:05Z")

</div>

We’ve fixed this bug with MySQL 5.7 (`Unknown database type json requested`) in Mautic 3.2, to be released on **November 30**. The fix will only apply to **new** installations and to installations that don’t have `db_server_version` in their `app/config/local.php` yet (this is the case if you haven’t changed the default configuration in Mautic’s UI before). Otherwise you have to change the version in `app/config/local.php` yourself, as mentioned in [Mautic 3.1.2 installed - Plugins are not available](https://forum.mautic.org/t/mautic-3-1-2-installed-plugins-are-not-available/17003/3).

Apologies for the inconvenience and thanks for reporting this!
