[BUG] Unable to migrate mysql database for postorius to latest release

[makinbacon21]

Tag/version of Container Images
0.5

For context, 0.4.x worked perfectly fine.

mailman-web   | System check identified some issues:
mailman-web   | 
mailman-web   | WARNINGS:
mailman-web   | account.EmailAddress: (models.W036) MySQL does not support unique constraints with conditions.
mailman-web   |         HINT: A constraint won't be created. Silence this warning if you don't care about it.
mailman-web   | Operations to perform:
mailman-web   |   Apply all migrations: account, admin, auth, contenttypes, django_mailman3, postorius, sessions, sites, socialaccount
mailman-web   | Running migrations:
mailman-web   | Traceback (most recent call last):
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/utils.py", line 89, in _execute
mailman-web   |     return self.cursor.execute(sql, params)
mailman-web   |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/mysql/base.py", line 75, in execute
mailman-web   |     return self.cursor.execute(query, args)
mailman-web   |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/MySQLdb/cursors.py", line 179, in execute
mailman-web   |     res = self._query(mogrified_query)
mailman-web   |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/MySQLdb/cursors.py", line 330, in _query
mailman-web   |     db.query(q)
mailman-web   |   File "/usr/lib/python3.12/site-packages/MySQLdb/connections.py", line 257, in query
mailman-web   |     _mysql.connection.query(self, query)
mailman-web   | MySQLdb.OperationalError: (1091, "Can't DROP 'account_emailaddress_upper'; check that column/key exists")
mailman-web   | 
mailman-web   | The above exception was the direct cause of the following exception:
mailman-web   | 
mailman-web   | Traceback (most recent call last):
mailman-web   |   File "/opt/mailman-web/manage.py", line 10, in <module>
mailman-web   |     execute_from_command_line(sys.argv)
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
mailman-web   |     utility.execute()
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/core/management/__init__.py", line 436, in execute
mailman-web   |     self.fetch_command(subcommand).run_from_argv(self.argv)
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/core/management/base.py", line 412, in run_from_argv
mailman-web   |     self.execute(*args, **cmd_options)
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/core/management/base.py", line 458, in execute
mailman-web   |     output = self.handle(*args, **options)
mailman-web   |              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/core/management/base.py", line 106, in wrapper
mailman-web   |     res = handle_func(*args, **kwargs)
mailman-web   |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/core/management/commands/migrate.py", line 356, in handle
mailman-web   |     post_migrate_state = executor.migrate(
mailman-web   |                          ^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/migrations/executor.py", line 135, in migrate
mailman-web   |     state = self._migrate_all_forwards(
mailman-web   |             ^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
mailman-web   |     state = self.apply_migration(
mailman-web   |             ^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/migrations/executor.py", line 252, in apply_migration
mailman-web   |     state = migration.apply(state, schema_editor)
mailman-web   |             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/migrations/migration.py", line 132, in apply
mailman-web   |     operation.database_forwards(
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/migrations/operations/models.py", line 945, in database_forwards
mailman-web   |     schema_editor.remove_index(model, index)
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/mysql/schema.py", line 140, in remove_index
mailman-web   |     super().remove_index(model, index)
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/base/schema.py", line 518, in remove_index
mailman-web   |     self.execute(index.remove_sql(model, self))
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/base/schema.py", line 201, in execute
mailman-web   |     cursor.execute(sql, params)
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/utils.py", line 67, in execute
mailman-web   |     return self._execute_with_wrappers(
mailman-web   |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
mailman-web   |     return executor(sql, params, many, context)
mailman-web   |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/utils.py", line 84, in _execute
mailman-web   |     with self.db.wrap_database_errors:
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/utils.py", line 91, in __exit__
mailman-web   |     raise dj_exc_value.with_traceback(traceback) from exc_value
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/utils.py", line 89, in _execute
mailman-web   |     return self.cursor.execute(sql, params)
mailman-web   |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/django/db/backends/mysql/base.py", line 75, in execute
mailman-web   |     return self.cursor.execute(query, args)
mailman-web   |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/MySQLdb/cursors.py", line 179, in execute
mailman-web   |     res = self._query(mogrified_query)
mailman-web   |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
mailman-web   |   File "/usr/lib/python3.12/site-packages/MySQLdb/cursors.py", line 330, in _query
mailman-web   |     db.query(q)
mailman-web   |   File "/usr/lib/python3.12/site-packages/MySQLdb/connections.py", line 257, in query
mailman-web   |     _mysql.connection.query(self, query)
mailman-web   | django.db.utils.OperationalError: (1091, "Can't DROP 'account_emailaddress_upper'; check that column/key exists")
mailman-web   |   Applying account.0007_emailaddress_idx_email...