Bug #90541 Django with Mysql 8.0 datatime incompatible

Submitted: 20 Apr 2018 21:04 Modified: 25 Jun 2018 21:25
Reporter: Marcelo Wanderley Delta Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / Python Severity:S2 (Serious)
Version:8.0.11 OS:Linux
Assigned to: CPU Architecture:Any

[20 Apr 2018 21:04] Marcelo Wanderley Delta
Description:
Django with Mysql 8.0 datatime incompatible.

I'm trying to run tests with mysql 8.0, however I'm encountering some inconsistencies.

thank you

How to repeat:
Install django using 

DATABASES = {
    'default': {
        'ENGINE': 'mysql.connector.django',
        'NAME' : 'dev',
        'USER' : 'root',
        'PASSWORD' : 'root',
        'HOST' : 'DEV',
        'OPTIONS': {
            'autocommit': True,
        }
    }
}

Suggested fix:
Work.
[20 Apr 2018 21:04] Marcelo Wanderley Delta
AttributeError at /admin/login/ 
>
>'datetime.datetime' object has no
> attribute 'split' 
>
>Request Method:    
>
>POST Request
> URL:  http://localhost:8000/admin/login/?next=/admin/ 
>
Django
> Version:  2.0.4 
>
>Exception Type:    AttributeError Exception Value: 
> 'datetime.datetime' object has no attribute 'split' 
>
>Exception
> Location: /usr/local/lib/python3.6/site-packages/mysql/connector/conversion.py
> in _DATETIME_to_python, line 506 Python
> 
>
>Executable:    /usr/local/bin/python Python Version:   3.6.5
[23 Apr 2018 13:30] Chiranjeevi Battula
Hello Marcelo,

Thank you for the bug report.
I could not repeat the issue at our end using with Connector / Python 8.0.11 with MySQL 8.0.11 version.
Could you please provide repeatable steps (exact steps/sample code, stack trace etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[24 Apr 2018 8:26] Oli Jo
traceback error

Attachment: mysql_bug_report-24042018.txt (text/plain), 7.88 KiB.

[24 Apr 2018 8:29] Oli Jo
Hello,
I encounter the same issue, here is my config, traceback error detailled above.

virtualenvwrapper->python3.5

mysql version 14.14 Distrib 5.7.21, for Linux (x86_64)

Installing local env Connector/Python from Source
mysql-connector-python-8.0.11

Cordialement Olivier J.
[1 May 2018 9:51] Daniel Thorell
Simple test case to trigger the error, tested on Ubuntu 16.04:

python3.5 -m venv venv
source venv/bin/activate

pip install django==1.11.12 mysql-connector-python==8.0.11

django-admin startproject mysql_test
cd mysql_test

vi mysql_test/settings.py

Change:
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    }
}

TO:
DATABASES = {
    'default': {
        'ENGINE': 'mysql.connector.django',
        'NAME': 'dev',
        'USER': 'dev',
        'PASSWORD': 'dev',
        'HOST': '127.0.0.1',
        'OPTIONS': {
            'autocommit': True,
            'raise_on_warnings': False
        }
    }
}

Migrate the Database:
python manage.py migrate

Create superuser:
python manage.py createsuperuser

Run dev server:
python manage.py runserver

In webbrowser enter url: http://127.0.0.1:8000/admin

Login with superuser just created, 

Will not work due to:
'datetime.datetime' object has no attribute 'split'
Exception Location: mysql/connector/conversion.py in _DATETIME_to_python, line 506

Installed versions:
Django==1.11.12
mysql-connector-python==8.0.11
pkg-resources==0.0.0
protobuf==3.5.2.post1
pytz==2018.4
six==1.11.0

Using MySQL-community 8.0.11
[3 May 2018 11:43] Chiranjeevi Battula
Hello Marcelo,

Thank you for feedback.
Verified this behavior on MySQL Connector/Python 8.0.11 with the help of dev's.

Thanks,
Chiranjeevi.
[3 May 2018 14:01] Nuno Mariz
This happens when using the C extension, which is enabled by default. It will work by setting `use_pure=True` in DATABASES['default']['OPTIONS'].
[11 Jun 2018 10:52] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=91197 marked as duplicate of this one.
[25 Jun 2018 21:25] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Connector/Python 8.0.12 release, and here's the changelog entry:

Fixed datetime conversion compatibility between Django 2.0 and MySQL 8.0.

A workaround is to use the connector's pure Python implementation 
instead the C extension by setting "use_pure=True" in Django's 
database options.

Thank you for the bug report.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.