我有一个 Django 应用程序。我正在使用在 docker 容器中运行的 MySql 服务器作为数据库。在刚刚移动到自定义用户模型之后。现在我收到这些错误: 环境:

Request Method: GET
Request URL: http://127.0.0.1:8000/dashboard/

Django Version: 1.10.3
Python Version: 3.5.2
Installed Applications:
['grappelli',
 'django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.messages',
 'django.contrib.sessions',
 'django.contrib.staticfiles',
 'django.contrib.sites',
 'corsheaders',
 'rest_framework',
 'rest_framework.authtoken',
 'oauth2_provider',
 'social.apps.django_app.default',
 'rest_framework_social_oauth2',
 'rest_framework_swagger',
 'accounts',
 'dashboard',
 'items',
 'storages',
 'userprofile',
 'common',
 'registration',
 'debug_toolbar',
 'django_extensions']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'corsheaders.middleware.CorsMiddleware',
 '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',
 'debug_toolbar.middleware.DebugToolbarMiddleware']



Traceback:

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/core/handlers/exception.py" in inner
  39.             response = get_response(request)

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/core/handlers/base.py" in _legacy_get_response
  249.             response = self._get_response(request)

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  187.                 response = self.process_exception_by_middleware(e, request)

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  185.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
  23.                 return view_func(request, *args, **kwargs)

File "/home/kuba/code/VeeU/Server/dashboard/views.py" in index
  66.                         Bookmark.objects.datetimes('date_bookmarked', 'day')]

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/db/models/query.py" in __iter__
  256.         self._fetch_all()

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/db/models/query.py" in _fetch_all
  1087.             self._result_cache = list(self.iterator())

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/db/models/query.py" in __iter__
  155.         for row in compiler.results_iter():

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/db/models/sql/compiler.py" in results_iter
  795.                     row = self.apply_converters(row, converters)

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/db/models/sql/compiler.py" in apply_converters
  779.                 value = converter(value, expression, self.connection, self.query.context)

File "/home/kuba/.virtualenvs/VeeU/lib/python3.5/site-packages/django/db/models/functions/datetime.py" in convert_value
  181.                         "Database returned an invalid datetime value. "

Exception Type: ValueError at /dashboard/
Exception Value: Database returned an invalid datetime value. Are time zone definitions for your database and pytz installed?

我尝试运行 mysql_tzinfo_to_sql/usr/share/zoneinfo | mysql -u root -p mysql 但它不起作用。我还尝试在容器中的 /etc/mysql/my.cnf 中设置 default-time-zone = 'UTC' 。

编辑:

我还安装了pytz

pip freeze | grep pytz
pytz==2016.7

最佳答案

我在 Debian Linux 上遇到了与 django 和 mysql 相同的问题，并且能够通过运行此命令来解决它，该命令填充名为 mysql< 的(配置)数据库中的="">time_zone 表/strong>:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

关于mysql - Django Mysql 数据库返回无效的日期时间值，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/40792628/