Migration from 3.1.2 to 3.2.2 error Unknown database type json requested

[danielhilst]

Your software
My Mautic version is: 3.2.2
My PHP version is: 7.2
My Database type and version is: MySQL 5.7

Your problem
My problem is: Error while trying php bin/console mautic:update:apply --finish

These errors are showing in the log:
Step 1 [->--------------------------] Migrating database schema…

An error occurred while updating the database. Check log for more details.

==> var/logs/mautic_prod-2021-01-12.php <==
[2021-01-12 12:28:51] 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-3.1.2-migration-failed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php line 436 while running console command doctrine:migrations:migrate
[2021-01-12 12:28:51] mautic.WARNING: Command doctrine:migrations:migrate exited with status code 1
[2021-01-12 12:28:51] mautic.WARNING: Command mautic:update:apply exited with status code 1

==> var/logs/prod-2021-01-12.php <==
[2021-01-12 12:28:51] console.ERROR: Error thrown while running command “doctrine:migrations:migrate --quiet --no-interaction”. Message: “Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.” {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. at /var/www/html/mautic-3.1.2-migration-failed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php:436)",“command”:“doctrine:migrations:migrate --quiet --no-interaction”,“message”:“Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.”}

Steps I have tried to fix the problem: I’m really confused since MySQL should support JSON natively, what I’m missing?

[rcheesley]

This was a bug that was fixed I believe in 3.2:

Bump minimum MySQL version to 5.7

Also reported in

Mautic 3.1.2 installed - Plugins are not available

Your software My Mautic version is: 3.1.2 My PHP version is: 7.3 My Database type and version is: [image] Your problem My problem is: Moutic shows only “OneSignal” and “Twilio” Plugin. [image] I’m not familiar with Mautic and my programming skills are limited. I did some research and came across this article: https://github.com/mautic/mautic/issues/9273 Ruth forwarded me to this post https://github.com/mautic/mautic/issues/9200#issuecomment-694274904 But there is no config.php in my ap…

Multiple errors with two fresh installations of 3.1.1

Your software My Mautic version is: 3.1.1 My PHP version is: 7.2 Your problem My problem is: I have two instances of Mautic running on my VPS. One was installed via Softaculous on Cpanel, the other was installed manually. Neither instance shows a directory for /apps/cache or /apps/logs when I am going through directories via FTP I get a persistent error when I try go to/update/schema on both installations. Both sites return this error when I try to connect to Zapier: authenticati…

An error occurred while updating the database

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 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 …

Maybe check your file has been updated? See the file changes here.

[danielhilst]

Hi Ruth, thank you.

Yeah changing db_server_version from 5.5 to 5.7 in app/config/local.php solved the problem, thank you so much!

Regards

[rcheesley]

Hurrah - yes it might catch folk out who are updating as we realised the issue after the release was made. Glad you got it solved!