I get this error on my Ubuntu 12.04 machine with mysql 5.5 after I imported some Wordpress content to Mezzanine&#39;s blog_blogpost.

    ValueError at /admin/blog/blogpost/
    Database returned an invalid value in QuerySet.dates(). Are time zone definitions and pytz installed?
    
    Request Method:	GET
    Request URL:	http://127.0.0.1:8000/admin/blog/blogpost/
    Django Version:	1.6.1
    Exception Type:	ValueError
    Exception Value:	
    Database returned an invalid value in QuerySet.dates(). Are time zone definitions and pytz installed?
    Exception Location:	/home/me/.mezenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py in results_iter, line 1107
    Python Executable:	/home/me/.mezenv/bin/python
    Python Version:	2.7.3
    Python Path:	
    [u&#39;/home/me&#39;,
     &#39;/home/me/sai&#39;,
     &#39;/home/me/.mezenv/local/lib/python2.7/site-packages/distribute-0.6.24-py2.7.egg&#39;,
     &#39;/home/me/.mezenv/local/lib/python2.7/site-packages/pip-1.1-py2.7.egg&#39;,
     &#39;/home/me/.mezenv/lib/python2.7&#39;,
     &#39;/home/me/.mezenv/lib/python2.7/plat-linux2&#39;,
     &#39;/home/me/.mezenv/lib/python2.7/lib-tk&#39;,
     &#39;/home/me/.mezenv/lib/python2.7/lib-old&#39;,
     &#39;/home/me/.mezenv/lib/python2.7/lib-dynload&#39;,
     &#39;/usr/lib/python2.7&#39;,
     &#39;/usr/lib/python2.7/plat-linux2&#39;,
     &#39;/usr/lib/python2.7/lib-tk&#39;,
     &#39;/home/me/.mezenv/local/lib/python2.7/site-packages&#39;]
    Server time:	Sat, 25 Jan 2014 13:44:11 +0100


    Error during template rendering
    
    In template /home/me/.mezenv/local/lib/python2.7/site-packages/grappelli_safe/templates/admin/change_list.html, error at line 140




I added to my local_settings.py 

    import pytz
    from pytz import *

and also defined timezone in my.cnf [mysqld]

    default-time-zone = &quot;+01:00&quot;

but I still get the error unitl I get the line in template:


the tag is:

&gt; 140	 {% block date_hierarchy %}{% date_hierarchy cl %}{% endblock %}


Appreciate your help to resolve it. 



All Mezzanine Solutions on Gang of Coders

Total of 1 Mezzanine Solutions

Database returned an invalid value in QuerySet.dates()