Which versions of mysql.connector.django are compatible with django-allauth?

[H4ngryH4ngryH1ppos]

I'm currently working on a website using mysql.connector.django as the DB engine to connect to a MySQL database.

I'd recently tried setting up Django-Allauth for my project, since it worked on my local dev build which has an SQLite database.
When I try to perform a python manage.py migrate, the migration fails with the following error:

/[venv]/3.11/bin/python /[django-project]/manage.py migrate
Traceback (most recent call last):
  File "/[django-project]/manage.py", line 22, in <module>
    main()
  File "/[django-project]/manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/management/base.py", line 413, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/management/base.py", line 459, in execute
    output = self.handle(*args, **options)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/management/base.py", line 107, in wrapper
    res = handle_func(*args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/management/commands/migrate.py", line 101, in handle
    self.check(databases=[database])
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/management/base.py", line 486, in check
    all_issues = checks.run_checks(
                 ^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/checks/registry.py", line 88, in run_checks
    new_errors = check(app_configs=app_configs, databases=databases)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/core/checks/model_checks.py", line 36, in check_all_models
    errors.extend(model.check(**kwargs))
                  ^^^^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/db/models/base.py", line 1710, in check
    *cls._check_constraints(databases),
     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/db/models/base.py", line 2428, in _check_constraints
    errors.extend(constraint._check(cls, connection))
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/db/models/constraints.py", line 380, in _check
    f"{connection.display_name} does not support unique constraints "
       ^^^^^^^^^^^^^^^^^^^^^^^
  File "/[venv]/3.11/lib/python3.11/site-packages/django/utils/functional.py", line 47, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
                                         ^^^^^^^^^^^^^^^^^^^
TypeError: DatabaseWrapper.display_name() takes 0 positional arguments but 1 was given

One solution I'm seeing is to switch from "mysql.connector.django" to "django.db.backends.mysql", which requires installing mysqlclient with Pip, which in turn requires installing the appropriate building packages beforehand.
Unfortunately the hosting platform I'm using has no way to install packages of any sort.

For now I want to see if I can make it work with "mysql.connector.django".

I currently have "django-allauth==65.0.2" and "mysql-connector-python==8.4.0" in my list of Python packages for the website.

I'd like to know if anyone else has made "mysql-connector-python" work with "django-allauth", and how they were able to set it up.

[pennersr]

It is not allauth that is putting limitations on what mysql packages/versions you can use, Django is. So, the question you have is an overall Django one, for which I do not have the answer.

[H4ngryH4ngryH1ppos]

As a sort of side question, what versions of Django would you consider Django-Allauth to be safely compatible with?
To see if carefully downgrading Django down from version 5.1.2 will work to solve my issue.

[iamunadike]

@pennersr can you be kind enough to help on the discussion I raised here
#4140 (comment)
as per the discussion
Remeber this project is created by you and i could not find a fix from the docs
Please help on this as I am trying to ship fast
thanks

[pennersr]

@H4ngryH4ngryH1ppos For the minimal Django version, see: https://codeberg.org/allauth/django-allauth/src/branch/main/setup.cfg#L48