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

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:

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.