# Console doctrine:schema:update --no-interaction --force

**URL:** <https://forum.mautic.org/t/console-doctrineupdate-no-interaction-force/35433>\
**Category:** Mautic 6 Install/Upgrade Support\
**Created:** [April 1, 2025, 11:00pm UTC](https://forum.mautic.org/t/console-doctrineupdate-no-interaction-force/35433 "2025-04-01T23:00:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\
**Post date:** [April 1, 2025, 11:00pm UTC](https://forum.mautic.org/t/console-doctrineupdate-no-interaction-force/35433/1 "2025-04-01T23:00:03Z")

</div>

**Your software**  
My Mautic version is: 6.0  
My PHP version is: 8.3.19  
My Database type and version is: MySQL 8.0.41

**Your problem**  
I’m trying to upgrade v5.2.2 to v6. My problem is that `console doctrine:schema:update --no-interaction --force` step fails.

These errors are showing in the log:

```auto
In ExceptionConverter.php line 117:

  An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'IDX_1AE3441319EB6921'; check that column/key exists

In Exception.php line 28:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'IDX_1AE3441319EB6921'; check that column/key exists

In Connection.php line 33:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'IDX_1AE3441319EB6921'; check that column/key exists

doctrine:schema:update [--em EM] [--complete] [--dump-sql] [-f|--force]

```

What am I supposed to do if I get this kind of error?

Updating mautic hasn’t always been a pleasant experience. I wish the updating is more robust and easy and there is a better documentation for troubleshooting.

---

<div class="post-metadata">

**Author:** ![fkrafft](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/fkrafft/32/2220_2.png) [@fkrafft](https://forum.mautic.org/u/fkrafft)\
**Post date:** [May 16, 2025, 10:59am UTC](https://forum.mautic.org/t/console-doctrineupdate-no-interaction-force/35433/2 "2025-05-16T10:59:00Z")

</div>

I will try to upgrade to 6.0 soon too, and I have this error from my 5.2 installation and therefore expect that I will have it in version 6 too.

Did you resolve this issue?

---

<div class="post-metadata">

**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\
**Post date:** [May 16, 2025, 11:28am UTC](https://forum.mautic.org/t/console-doctrineupdate-no-interaction-force/35433/3 "2025-05-16T11:28:37Z")

</div>

No, I haven’t. I’m postponing my upgrade. I’ve experienced similar problems in my previous upgrades and don’t want to repeat what I had to go through. I did my best finding a solution in this forum, GitHub, and googling, but I haven’t found one yet. Hope you can figure out and provide one!

---

<div class="post-metadata">

**Author:** ![fkrafft](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/fkrafft/32/2220_2.png) [@fkrafft](https://forum.mautic.org/u/fkrafft)\
**Post date:** [June 2, 2025, 5:46am UTC](https://forum.mautic.org/t/console-doctrineupdate-no-interaction-force/35433/4 "2025-06-02T05:46:20Z")

</div>

@jm1 I ended up upgrading version 5.2 and i see that this issue is still there but it seams to work fine still.