Mautic upgrade from 4.4.10 to latest version 5.2

Product Support Mautic 5 Install/Upgrade Support
1

Hi everyone !

Your software
My Mautic version is: 4.4.10
My PHP version is: 8.X
My Database type and version is: MySQL V8.0.34

Your problem
My problem is:

I’m trying to update Mautic with the following process:

  • Update to Mautic V5.0.4
  • Switch install to composer
  • Update to 5.2.X with composer

To update to V5.0.4 i’m doing:

php bin/console mautic:update:apply --update-package=/root/5.0.4-update.zip
php bin/console mautic:update:apply --update-package=/root/5.0.4-update.zip --finish

Then i’m switching to composer install: no issue

Finally, when I try to update to Mautic V5.2.X and run php bin/console doctrine:schema:update --no-interaction --force, I get the same errors as described in this issue: oAuth Access token Foreign Key on client_id · Issue #9129 · mautic/mautic · GitHub

Steps I have tried to fix the problem:
I tried to revert code and db to 4.4.10 and when i do an php bin/console doctrine:schema:update --dump-sql, i see a lots of schema update waiting to be applied.

image
image1521×619 44.7 KB

Trying to apply them, give me those errors:

image
image1613×412 36.3 KB

There are no migrations to be done; it’s as if the database were in an old state from a previous Mautic version…

image
image874×347 37.6 KB

Do you have any idea how to fix this issue ?

Thanks !

2

Did you try submitting this errot to Chat GPT or Claude? I can usually use either to solve these kinds of issues.

3

Yep ! But not so helpful as this is specific :frowning:

4

no one able to help ??