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:
authentication failed: Requested URL not found: /api/contacts?limit=1&minimal=1
-
I only see two plugins available: OneSignal and Twilio
These errors are showing in the log:
[2020-10-04 01:28:53] mautic.NOTICE: Doctrine\DBAL\DBALException: Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. (uncaught exception) at /home/sofosadmin/go.sofosinvestments.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php line 436 while running console command doctrine:migrations:migrate
[2020-10-04 01:28:53] mautic.WARNING: Command doctrine:migrations:migrate
exited with status code 1
[2020-10-04 01:28:53] 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] [–] \
[2020-10-04 02:37:31] mautic.NOTICE: Doctrine\DBAL\DBALException: Unknown database type json requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. (uncaught exception) at /home/sofosadmin/go.sofosinvestments.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php line 436 while running console command doctrine:migrations:migrate
[2020-10-04 02:37:31] mautic.WARNING: Command doctrine:migrations:migrate
exited with status code 1
[2020-10-04 02:37:31] mautic.ERROR: [UPGRADE ERROR] Exit code 1; Mautic Migrations \ Migrating u
Steps I have tried to fix the problem:
I have scoured the forums, I cleared the cache via command line, I tried to migrate the DB (which led to me doing the manual installation), etc.
Is there a more stable version of 3 I can use until 3.1.1 is fixed or does anyone have a clue what could be causing my problems?
Thanks in advance!