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.