Your software
My Mautic version is: 5.03
My PHP version is: 8.1.27
My Database type and version is: 8.0.28-0ubuntu0.20.04.3
Your problem
My problem is:
Half of mautic functionality not working.
These errors are showing in the log:
mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception: “Unknown column type “json_array” requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information.” at /home/username/domainname.com/mautic5/vendor/doctrine/dbal/src/Exception.php line 115 {“exception”:“[object] (Doctrine\DBAL\Exception(code: 0): Unknown column type "json_array" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information. at /home/username/domainname.com/mautic5/vendor/doctrine/dbal/src/Exception.php:115)”} {“hostname”:“XXXXXXXXX”,“pid”:421955}
Steps I have tried to fix the problem:
Created this support post, because I have no idea how to fix this.