How to upgrade from v4 to v5
mchojrin opened this issue · 2 comments
mchojrin commented
Hi:
I have a Mautic installation based on v4. I'm trying to move it to v5. So far, I downloaded and successfully installed a v5 locally. I understand I need to copy my media files and local configuration to the new instance.
The problem I'm having is in getting the database up to date.
What I did is to take a dump of my v4 db and imported it into my v5 installation, then tried to run the migrations but got this error:
[notice] Migration Mautic\Migrations\Version20221128145933 skipped during Pre-Checks. Reason: "Schema includes this migration"
[error] Migration Mautic\Migrations\Version20230522141144 failed during Pre-Checks. Error: "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."
In Exception.php line 115:
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#getMappedData
baseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information.
Any idea? Thanks!
mollux commented
@mchojrin that's a Mautic specific issue, not related to the docker images.
Please check mautic/mautic#13281 for mitigations or solutions.
I'll close this issue here, as it can't be solved here
mchojrin commented
I see. Thanks for the help and sorry for the noise ;)