# Issue with logging in to mautic 6.0 after upgrade from 5.2.5 **URL:** \ **Category:** Mautic 6 Install/Upgrade Support\ **Created:** [May 1, 2025, 12:06pm UTC](https://forum.mautic.org/t/issue-with-logging-in-to-mautic-6-0-after-upgrade-from-5-2-5/35610 "2025-05-01T12:06:25Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![raramuridesign](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/raramuridesign/32/13226_2.png) [@raramuridesign](https://forum.mautic.org/u/raramuridesign)\ **Post date:** [May 6, 2025, 12:02pm UTC](https://forum.mautic.org/t/issue-with-logging-in-to-mautic-6-0-after-upgrade-from-5-2-5/35610/4 "2025-05-06T12:02:04Z")
@silavapi 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. > [@V6.0.0 Upgrade- Error when creating or editing forms](https://forum.mautic.org/t/v6-0-0-upgrade-error-when-creating-or-editing-forms/35381/4): > > @silavapi I ran this command manually on the database and it fixed the issue. Thanks for the info. ALTER TABLE form\_fields ADD COLUMN is\_read\_only TINYINT(1) DEFAULT 0; or direct cli command php bin/console doctrine:migrations:migrate “Mautic\Migrations\Version20241227065658” --env=prod 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. ```auto [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. ```auto 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 --- _[View the full topic](https://forum.mautic.org/t/issue-with-logging-in-to-mautic-6-0-after-upgrade-from-5-2-5/35610)._