Unable to load mautic configuration, it keeps loading

Hi,

Mautic v3.3.2
PHP 7.3
mysql Ver 15.1 Distrib 10.2.32-MariaDB, for Linux (x86_64) using readline 5.1

Recently, we have updated the Mautic to the latest version, since then, Mautic configuration page is not loading

It is keep loading as above image

We also found some errors in the server logs

++++++++++

domain/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Can’t create table admin_maut475.maukp_bundle_grapesjsbuilder (errno: 150 “Foreign key constraint is incorrectly formed”) at domain/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:151)",“command”:“doctrine:schema:update --force”,“message”:“An exception occurred while executing ‘ALTER TABLE maukp_bundle_grapesjsbuilder ADD CONSTRAINT FK_B4DBBDF5A832C1C9 FOREIGN KEY (email_id) REFERENCES maukp_emails (id) ON DELETE CASCADE’:\n\nCan’t create table admin_maut475.maukp_bundle_grapesjsbuilder (errno: 150 “Foreign key constraint is incorrectly formed”)”}
+++++++++++++

Can anyone advise on this? what could be the reason for this issue?

Thank you

Hi,

Anyone can advise in this case, please?

Thank you.

Something must have gone wrong during the upgrade. Wifi cut, cookies, browser cache, etc.

Load the back up. I bet you must be having a back up before upgrading. If you don’t check automatic back ups.

Once the back up is running, start the upgrade process in a clean environment and stick on the page to ensure nothing goes wrong.

Hi,

May I know is it not possible to resolve this issue without updating again?

Are there no other solutions available?

Thank You

Configurations not loading is a sign something broke during the update.

The only option you have is to use your backup. That’s why it’s highly recommended to do backups before doing an update. Automatic backups made it even easier.

You actually don’t need to upgrade again. You can use your backup as it is. Since the update broke your installation, I’d recommend not upgrading for now and wait for the next update. Continue enjoying Mautic in the meantime.

When the next update comes. Upgrade in a clean environment and monitor the process to ensure nothing breaks.

Hi,

Thank you for the suggestion.

We have already gone through the update three times since each update had issues. We have done using Mautic automatic update and also done manual backend update as well. We saw some pending updates in the backend also and it never completes. Here is the result below,

php bin/console doctrine:migration:status

== Configuration

>> Name:                                               Mautic Migrations
>> Database Driver:                                    mysqli
>> Database Host:                                      localhost
>> Database Name:                                      xxxxxxxxx
>> Configuration Source:                               manually configured
>> Version Table Name:                                 maukp_migrations
>> Version Column Name:                                version
>> Migrations Namespace:                               Mautic\Migrations
>> Migrations Directory:                               /path/to/file/domain.com/mautic.domain.com/sg/app/migrations
>> Previous Version:                                   2021-01-04 17:10:05 (20210104171005)
>> Current Version:                                    2021-02-23 17:47:02 (20210223174702)
>> Next Version:                                       Already at latest version
>> Latest Version:                                     2021-02-23 17:47:02 (20210223174702)
>> Executed Migrations:                                162
>> Executed Unavailable Migrations:                    134
>> Available Migrations:                               28
>> New Migrations:                                     0

May I know why this is causing and can we solve it? What is the suggested way for the update?

Thank you so much for your help and waiting for the reply.

Hi,

Anyone can advise in this case, please?

Thank you.

Hi,

Please help us with this case. We are really having issues using the Mautic now. An update with this case is really appreciated.

Thank you.

Hello,
What happens if you disable the GrapeJS plugin?
Then log out, and log back in?
Joey