I wrote a post about migration problems, I think if you stick with the process described there you should be able to resolve the issues:
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Another failed upgrade (4.3.1) on stuck database migration, SQL syntax error | 8 | 1370 | January 7, 2025 | |
| MySQL error upgrading to 4.2 | 24 | 6066 | May 23, 2022 | |
| Error when update to 4.1.0 | 0 | 363 | December 1, 2021 | |
| RENAME INDEX IDX_SEARCH | 0 | 414 | August 25, 2022 | |
| DB error when upgrading from 4.1.2 to 4.4.2 | 6 | 822 | October 17, 2022 |