# Database error when updating

**URL:** <https://forum.mautic.org/t/database-error-when-updating/32145>\
**Category:** Product Support\
**Created:** [May 24, 2024, 4:13am UTC](https://forum.mautic.org/t/database-error-when-updating/32145 "2024-05-24T04:13:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![psnabe](https://avatars.discourse-cdn.com/v4/letter/p/cdc98d/32.png) [@psnabe](https://forum.mautic.org/u/psnabe)\
**Post date:** [May 24, 2024, 4:13am UTC](https://forum.mautic.org/t/database-error-when-updating/32145/1 "2024-05-24T04:13:27Z")

</div>

Hi

I have been trying to update to the latest version of Mautic for some time- but ran into some problems. Today I gave it a new try - and after trying different things - I see this error message in the logs:

```auto
console.CRITICAL: Error thrown while running command "'doctrine:migration:migrate'". Message: "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `sms_message_stats.details` failed for `xxxx_mautic`.`sms_message_stats`" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 4025): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `sms_message_stats.details` failed for `xxxx_mautic`.`sms_message_stats` at /var/www/vhosts/xxxxxx/xxxxx/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 `sms_message_stats.details` failed for `xxxxxx_mautic`.`sms_message_stats` at /var/www/vhosts/xxxxxxx/xxxxxx/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `sms_message_stats.details` failed for `xxxxx_mautic`.`sms_message_stats` at /var/www/vhosts/xxxxx/xxxxxx/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"'doctrine:migration:migrate'","message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT `sms_message_stats.details` failed for `xxx_mautic`.`sms_message_stats`"}

```

Any one who knows how to fix it? It was an upgrade from version 4x to 5