search

mautic / docker-mautic

Docker Image for Mautic
https://www.mautic.org
381 stars 280 forks source link

How to upgrade from v4 to v5 #267

Closed mchojrin closed 9 months ago

mchojrin commented 9 months ago

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 9 months ago

@mchojrin that's a Mautic specific issue, not related to the docker images. Please check https://github.com/mautic/mautic/issues/13281 for mitigations or solutions.

I'll close this issue here, as it can't be solved here

mchojrin commented 9 months ago

I see. Thanks for the help and sorry for the noise ;)