Issue with logging in to mautic 6.0 after upgrade from 5.2.5

Product Support Mautic 6 Install/Upgrade Support
4

@rcheesley Thanks for the info, I have started this again, and seen where this does not work.

Upgrading from v5.2.1 to 5.2.5 results in the migration not happening as I mentioned here, so adding in the missing field works.

Then upgrading from 5.2.5 to 6.0.0 results in this error being shown below.
I have no idea what Integrity constraint violation is, so I am adding the error here, so someone knows what to do.

[2025-05-06T11:46:29.880888+00:00] console.CRITICAL: Error thrown while running command "doctrine:migrations:migrate --quiet --no-interaction". Message: "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `mautic_emails.headers` failed for `mautic_xxxxx`.`mautic_emails`" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 4025): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `mautic_emails.headers` failed for `mautic_xxxxx`.`mautic_emails` at /home/mautic-xxxx/webapps/j3mautic/public/go/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 4025): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `mautic_emails.headers` failed for `mautic_xxxxx`.`mautic_emails` at /home/mautic-xxxx/webapps/j3mautic/public/go/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `mautic_emails.headers` failed for `mautic_xxxxx`.`mautic_emails` at /home/mautic-xxxx/webapps/j3mautic/public/go/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"doctrine:migrations:migrate --quiet --no-interaction","message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `mautic_emails.headers` failed for `mautic_xxxxx`.`mautic_emails`"} {"hostname":"a-srv24-wwm-ubuntu24","pid":1942844}

Since I know this has to do with uuid field missing on certain tables, I have done a compare of the tables from a new v6.0.0 install and identified the following tables, which have the field uuid.

mautic_assets
mautic_campaigns
mautic_campaign_events
mautic_categories
mautic_dynamic_content
mautic_emails
mautic_focus
mautic_forms
mautic_form_actions
mautic_form_fields
mautic_lead_fields
mautic_lead_lists
mautic_lead_tags
mautic_messages
mautic_message_channels
mautic_monitoring
mautic_pages
mautic_permissions
mautic_points
mautic_point_trigger_events
mautic_point_triggers
mautic_push_notifications
mautic_reports
mautic_roles
mautic_sms_messages
mautic_stages

I am assuming the migration did not run, due to the error. So I manually ran the following command to add the uuid field to the tables.

ALTER TABLE mautic_assets ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_campaigns ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_campaign_events ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_categories ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_dynamic_content ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_emails ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_focus ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_forms ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_form_actions ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_form_fields ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_lead_fields ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_lead_lists ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_lead_tags ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_messages ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_message_channels ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_monitoring ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_pages ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_permissions ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_points ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_point_trigger_events ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_point_triggers ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_push_notifications ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_reports ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_roles ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_sms_messages ADD COLUMN `uuid` char(36) DEFAULT NULL;
ALTER TABLE mautic_stages ADD COLUMN `uuid` char(36) DEFAULT NULL;

Once this was done, I could log back into the mautic instance.
I hope this helps anyone with the same issues.
Matthew

1 Like