id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33490	Potential bug: mysql-connector-python Django 3.2.11 and third-party packages that populate the Admin Site	Richard Mayebo	nobody	"Platform: Observed on Ubuntu 20.04, RHEL8

1. Install MySQL (Either 5.7 and 8.0)
2. Create a Virtual environment using venv, and activate it.
3. Install Django 3.2.11
4. Install mysql-connector-python (Either 8.0.26 and 8.0.28)
5. Install django-easy-audit and/or django-axes (both these third party packages populate the Django Admin Site, where the apparent bug manifests).
6. Create a superuser (python manage.py createsuperuser)
7. Start Django (python manage.py runserver)
8. Launch the Django Admin Site and log in with the superuser.
9. The pane on the left hand side will have links to objects created by django-easy-audit and/or django-axes, depending on what was installed.
10. Click on the ""Request event"" link under ""Easy Audit Application"" or ""Access logs"" under ""Axes""
RESULT: 
Template error: In template /home/......../.venv/lib/python3.8/site-packages/django/contrib/admin/templates/admin/base.html, error at line 44
   'NoneType' object has no attribute 'day' [OR  'NoneType' object has no attribute 'month'] 

This behaviour is observed on MySQL 5.7.37 and 8.0.26 using mysql-connector 8.0.26 and 8.0.28.

Replacing MySQL with SQLite or PostgreSQL 12 solves the issue. 

Replacing mysql-connector with mysqlclient-2.1.0 solves the issue. 

The problem does not manifest when using mysql-connector-python 8.0.26 with Django 3.1.14 and these third-party packages.

This implies there is a bug in the interaction between some third-party packages that populate the Django Admin Site like django-easy-audit and django-axes, Django 3.2.11 and mysql-connector 8.0.26 and 8.0.28.

settings.py and the full traceback are attached."	Uncategorized	closed	Uncategorized	3.2	Normal	invalid	mysql-connector 8.0.26, Django 3.2.11		Unreviewed	0	0	0	0	0	0