pytz and Centos and mysql - django

1.3k views Asked by At

The admin view of blog objects lists blog objects sorted by date. When the page is open (on development server), this error is returned:

Database returned an invalid value in QuerySet.dates(). Are time zone definitions and pytz installed?

The error message also includes: Server time: Tue, 3 Dec 2013 16:58:33 -0500

pip install pytz returns: Requirement already satisfied (use --upgrade to upgrade): pytz in /usr/lib/python2.6/site-packages/pytz-2013.8-py2.6.egg

In settings.py: TIME_ZONE = 'America/Detroit'

On the CentOS machine in /etc/sysconfig/clock: ZONE='America/Detroit'

When I start the development server, it shows: December 03, 2013 - 17:01:23

MySQL field datatype is DATETIME and includes data like 2013-12-03 20:48:09

In admin.py I added

import pytz
from pytz import *

but it doesn't change anything.

Not sure what else to check--all the above looks correct. Why would django complain about pytz?

thanks!

1

There are 1 answers

0
nnmware On BEST ANSWER

Need add timezones in MySQL.
Documentation - dev.mysql.com/doc/refman/5.5/en/mysql-tzinfo-to-sql.html