I am not able to install NPM on my Mautic instance now so I’ll just post my error log and information here. Surely, installing NPM should not be a obvious fix for this issue anyways?
Your software
OS: CentOS 7
My Mautic version is: 4.4.12 and trying to upgrade to 5.0.4
My PHP version is: 8.0.30
My Database type and version is: mysql Ver 8.0.39 for Linux on x86_64 (MySQL Community Server - GPL)
Extra info
Before trying to upgrade from 4.4.12, I’ve also upgraded from 4.2.0 to 4.4.12 as well as upgrading MySQL from 5.7 to 8.0.39 due to EOL of MySQL, and upgraded PHP from PHP 7.4.x to PHP 8.0.30.
The Mautic instance is running behind a proxy that is not allowed to access github, thus I have downloaded the upgrade package locally.
Upgrade steps
[root@mautic-node production]# php bin/console mautic:update:apply --update-package=/home/viktor/5.0.4-update.zip
Are you sure you wish to update Mautic to the latest version? yes
Step 5 [----->----------------------] Clearing the cache
<warning>IMPORTANT: Run the same command again with --finish. For example 'php bin/console mautic:update:apply --finish'</warning>
[root@mautic-node production]# php bin/console mautic:update:apply --update-package=/home/viktor/5.0.4-update.zip --finish
Step 1 [>---------------------------] Migrating database schema...
An error occurred while updating the database. Check log for more details.
Mautic log
[2024-08-16T09:55:26.657631+02:00] console.CRITICAL: Error thrown while running command "doctrine:migrations:migrate --quiet --no-interaction". Message: "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." {"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 /var/www/html/production/vendor/doctrine/dbal/src/Exception.php:115)","command":"doctrine:migrations:migrate --quiet --no-interaction","message":"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."} {"hostname":"mautic-node","pid":66939}
So, what am I supposed to do to fix this problem? Switch to composer? Am I missing a PHP module? Am I doing the upgrade wrong?
Hoping to get some attention to this old post 
Best
Viktor