Django: 'unicode' object has no attribute 'tzinfo' error using django-pyodbc-azure

Question

I have been asked to create a simple web front-end for an internal MSSQL database. I'm using django-pyodbc-azure .

I finally got everything configured and running but now when I try to log in to the admin page I get a 'unicode' object has no attribute 'tzinfo' error. I tried the suggestion here but it didn't seem to help. Any suggestions are very welcome!

http://stackoverflow.com/questions/16492031/how-to-fix-this-error-unicode-object-has-no-attribute-tzinfo?rq=1 — miyamoto, Jul 06 '16 at 19:21
Miyamaoto - thanks for the link. I had added the line " 'use_legacy_datetime' : True" but I hadn't gone and manually changed all of my datetime2s over to datetime. As soon as I did that the issue went away. — Paul Greene, Jul 06 '16 at 23:19

score 0 · Answer 1 · edited May 23 '17 at 12:08

The solution was posted by miyamoto. I had to add the line 'use_legacy_datetime': True to my database connection options in Django, and then I had to manually change all of the Datetime2 columns in my database over to Datetime.

More info on the solution can be found here.

Here is the stacktrace for future reference:

Environment:


Request Method: POST
Request URL: http://****:7777/admin/login/?next=/admin/

Django Version: 1.9.7
Python Version: 2.7.3
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware']



Traceback:

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
  149.                     response = self.process_exception_by_middleware(e, request)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
  147.                     response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
  57.         response = view_func(request, *args, **kwargs)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/contrib/admin/sites.py" in login
  414.         return login(request, **defaults)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/contrib/auth/views.py" in inner
  49.         return func(*args, **kwargs)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/views/decorators/debug.py" in sensitive_post_parameters_wrapper
  76.             return view(request, *args, **kwargs)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapped_view
  149.                     response = view_func(request, *args, **kwargs)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
  57.         response = view_func(request, *args, **kwargs)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/contrib/auth/views.py" in login
  76.             auth_login(request, form.get_user())

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/contrib/auth/__init__.py" in login
  110.         request.session.cycle_key()

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/contrib/sessions/backends/base.py" in cycle_key
  307.         self.delete(key)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/contrib/sessions/backends/db.py" in delete
  98.             self.model.objects.get(session_key=session_key).delete()

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/db/models/manager.py" in manager_method
  122.                 return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/db/models/query.py" in get
  381.         num = len(clone)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/db/models/query.py" in __len__
  240.         self._fetch_all()

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all
  1074.             self._result_cache = list(self.iterator())

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/db/models/query.py" in __iter__
  68.         for row in compiler.results_iter(results):

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in results_iter
  808.                     row = self.apply_converters(row, converters)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in apply_converters
  792.                 value = converter(value, expression, self.connection, self.query.context)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/sql_server/pyodbc/operations.py" in convert_datetimefield_value
  106.                 value = timezone.make_aware(value, timezone.utc)

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/utils/timezone.py" in make_aware
  367.         if is_aware(value):

File "/sites/flashlog/venv/local/lib/python2.7/site-packages/django/utils/timezone.py" in is_aware
  340.     return value.utcoffset() is not None

Exception Type: AttributeError at /admin/login/
Exception Value: 'unicode' object has no attribute 'utcoffset'

Django: 'unicode' object has no attribute 'tzinfo' error using django-pyodbc-azure

1 Answers1