I just checked it in 10.8.5 and got the same error.
On Wed, Jan 1, 2014 at 6:14 PM, Josh Cartmell <[email protected]> wrote: > I get the same thing: > > > >>> from django.conf import settings > >>> settings.USE_TZ > True > >>> settings.TIME_ZONE > >>> settings.TIME_ZONE is None > True > >>> from django.utils.timezone import get_default_timezone > >>> get_default_timezone() > <LocalTimezone> > > I'll try both this, and seeing if the blog works on a laptop I have with > OS X 10.8 a bit later > > > On Wed, Jan 1, 2014 at 5:41 PM, Stephen McDonald <[email protected]> wrote: > >> It'd be worth trying the following and comparing the output, you'll see >> on my setup with USE_TZ True and no TIME_ZONE set, I get LocalTimezone, is >> this different for anyone experiencing the issue? >> >> $ ./manage.py shell >> >>> from django.conf import settings >> >>> settings.USE_TZ >> True >> >>> settings.TIME_ZONE is None >> True >> >>> from django.utils.timezone import get_default_timezone >> >>> get_default_timezone() >> <LocalTimezone> >> >>> >> >> >> On Thu, Jan 2, 2014 at 12:35 PM, Sergei G <[email protected]>wrote: >> >>> I have a record of how I installed the system. Here is an abbreviated >>> form. >>> >>> I installed official Python3 and it does not come with PIP or setup >>> tools. >>> >>> pyvenv --system-site-packages ~/Sites/mezzanine >>> source bin/activate >>> python3 ~/Downloads/ez_setup.py >>> python3 ~/Downloads/ez_setup.py >>> python3 ~/Downloads/get-pip.py >>> pip-3.3 install Django==1.6.1 >>> pip-3.3 install mezzanine >>> >>> mezzanine-project rslp >>> python manage.py createdb --nodata >>> python manage.py runserver >>> >>> >>> On Wednesday, January 1, 2014 5:27:22 PM UTC-8, Sergei G wrote: >>>> >>>> I have current OS X 10.9.1. It is my development machine. >>>> >>>> On Wednesday, January 1, 2014 10:23:21 AM UTC-8, Josh Cartmell wrote: >>>>> >>>>> Hey Sergei, I had the same problem and setting a TIME_ZONE fixed it. >>>>> This error hasn't been reproducible by everyone so if you get any ideas >>>>> about what caused it please post back here. >>>>> >>>>> In my case I was running Django 1.6.1 with Mezzanine 3 on Python 2.7.5 >>>>> using sqlite and my computer was running OS X 10.9. It looks like you >>>>> have >>>>> Django 1.6.1 (so I will assume Mezzanine 3), Python 3.3.3 and sqlite. >>>>> What >>>>> operating system are you using? >>>>> >>>>> >>>>> On Wed, Jan 1, 2014 at 12:49 AM, Sergei G <[email protected]>wrote: >>>>> >>>>>> It turns out a very similar post was made recently. >>>>>> >>>>>> I added >>>>>> >>>>>> TIME_ZONE = "US/Pacific" >>>>>> >>>>>> and it started to work. >>>>>> >>>>>> On Wednesday, January 1, 2014 12:37:37 AM UTC-8, Sergei G wrote: >>>>>>> >>>>>>> Clean installation without demo data. I go to admin interface, >>>>>>> blogs, add test blog entry, click save and get the following: >>>>>>> >>>>>>> OperationalError at /admin/blog/blogpost/ >>>>>>> >>>>>>> user-defined function raised exception >>>>>>> >>>>>>> Request Method:GETRequest URL: http://127.0.0.1:8000/admin/bl >>>>>>> og/blogpost/ Django Version:1.6.1Exception Type: >>>>>>> OperationalErrorException >>>>>>> Value: >>>>>>> >>>>>>> >>>>>>> >>>>>>> user-defined function raised exception >>>>>>> >>>>>>> Exception Location: /Users/sergei/Sites/mezzanine/ >>>>>>> lib/python3.3/site-packages/django/db/backends/sqlite3/base.py in >>>>>>> execute, line 450 Python Executable:/Users/sergei/Sites/mezzanine/ >>>>>>> bin/python3 Python Version:3.3.3Python Path: >>>>>>> >>>>>>> ['/Users/sergei/Sites/mezzanine', >>>>>>> '/Users/sergei/Sites/mezzanine/rslp', >>>>>>> >>>>>>> '/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/setuptools-2.0.2-py3.3.egg', >>>>>>> '/Library/Frameworks/Python.framework/Versions/3.3/lib/python33.zip', >>>>>>> '/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3', >>>>>>> >>>>>>> '/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/plat-darwin', >>>>>>> >>>>>>> '/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/lib-dynload', >>>>>>> '/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages', >>>>>>> >>>>>>> '/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages'] >>>>>>> >>>>>>> Server time:Wed, 1 Jan 2014 00:21:05 -0800 >>>>>>> >>>>>>> >>>>>>> Error during template rendering >>>>>>> >>>>>>> In template /Users/sergei/Sites/mezzanine/lib/python3.3/site-pa >>>>>>> ckages/grappelli_safe/templates/admin/change_list.html, error at >>>>>>> line *140* >>>>>>> user-defined function raised exception 130 <p>{% blocktrans with >>>>>>> cl.result_count as counter %}{{ counter }} found{% endblocktrans %}</p> >>>>>>> 131 <a href="?{% if cl.is_popup %}pop=1{% endif %}">{% blocktrans >>>>>>> with cl.full_result_count as full_result_count %}{{ full_result_count }} >>>>>>> total{% endblocktrans %}</a> 132 </div> 133 </div> 134 {% >>>>>>> endifnotequal %} 135 136 <!-- Search --> 137 {% block search %}{% >>>>>>> search_form cl %}{% endblock %} 138 139 <!-- Date Hierarchy --> 140{% >>>>>>> block date_hierarchy %}{% >>>>>>> date_hierarchy cl %}{% endblock %} 141 142 {% if cl.has_filters %} >>>>>>> 143 <!-- Filter --> 144 <div class="module filter"> 145 <h2>{% >>>>>>> trans 'Filter' %}</h2> 146 {% for spec in cl.filter_specs %}{% >>>>>>> admin_list_filter cl spec %}{% endfor %} 147 </div> 148 {% endif %} >>>>>>> 149 150 </div> Parts of the variables: >>>>>>> >>>>>>> 1. >>>>>>> >>>>>>> return Database.Cursor.execute(self, query, params) >>>>>>> >>>>>>> ... >>>>>>> >>>>>>> ▼ Local vars <http://127.0.0.1:8000/admin/blog/blogpost/#> >>>>>>> Variable Valueparams >>>>>>> >>>>>>> >>>>>>> >>>>>>> ('PST', >>>>>>> 1, >>>>>>> datetime.datetime(2014, 1, 1, 0, 0, tzinfo=<LocalTimezone>), >>>>>>> datetime.datetime(2014, 12, 31, 23, 59, 59, 999999, >>>>>>> tzinfo=<LocalTimezone>), >>>>>>> 'PST', >>>>>>> 1) >>>>>>> >>>>>>> query >>>>>>> >>>>>>> >>>>>>> >>>>>>> 'SELECT DISTINCT django_datetime_trunc(\'day\', >>>>>>> "blog_blogpost"."publish_date", ?) FROM "blog_blogpost" WHERE >>>>>>> ("blog_blogpost"."site_id" = ? AND "blog_blogpost"."publish_date" >>>>>>> BETWEEN ? and ? AND django_datetime_extract(\'month\', >>>>>>> "blog_blogpost"."publish_date", ?) = ? AND >>>>>>> "blog_blogpost"."publish_date" IS NOT NULL) ORDER BY 1 ASC' >>>>>>> >>>>>>> self >>>>>>> >>>>>>> >>>>>>> >>>>>>> <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at >>>>>>> 0x104e08f28> >>>>>>> >>>>>>> I tried executing select statement from PyCharm. I had to comment >>>>>>> the function as it does not exist (not sure if it is ok): SELECT >>>>>>> DISTINCT >>>>>>> "blog_blogpost"."publish_date", typeof(publish_date), * -- >>>>>>> django_datetime_trunc('year', "blog_blogpost"."publish_date", >>>>>>> 'PST') FROM "blog_blogpost" WHERE ("blog_blogpost"."site_id" = 1 AND >>>>>>> "blog_blogpost"."publish_date" IS NOT NULL) ORDER BY 1 ASC Output: >>>>>>> "2014-01-01 08:20:50.282686",text,1,0,,0,0,0,1,"test >>>>>>> post",test-post,"test post","Here goes my test post.",1,"2014-01-01 >>>>>>> 08:20:50.284286","2014-01-01 08:20:50.284286",2,"2014-01-01 >>>>>>> 08:20:50.282686",NULL,NULL,1," >>>>>>> >>>>>>> Here goes my test post. >>>>>>> ",1,1,NULL Environment: Request Method: GET Request URL: >>>>>>> http://127.0.0.1:8000/admin/blog/blogpost/ Django Version: 1.6.1 >>>>>>> Python Version: 3.3.3 Installed Applications: ('mezzanine.boot', >>>>>>> 'django.contrib.auth', 'django.contrib.contenttypes', >>>>>>> 'django.contrib.redirects', 'django.contrib.sessions', >>>>>>> 'django.contrib.sites', 'django.contrib.sitemaps', >>>>>>> 'django.contrib.staticfiles', 'mezzanine.conf', 'mezzanine.core', >>>>>>> 'mezzanine.generic', 'mezzanine.blog', 'mezzanine.forms', >>>>>>> 'mezzanine.pages', 'mezzanine.galleries', 'mezzanine.twitter', >>>>>>> 'filebrowser_safe', 'grappelli_safe', 'django.contrib.admin', >>>>>>> 'django.contrib.comments') Installed Middleware: >>>>>>> ('django.contrib.sessions. >>>>>>> middleware.SessionMiddleware', >>>>>>> 'django.middleware.locale.LocaleMiddleware', >>>>>>> 'django.contrib.auth.middleware.AuthenticationMiddleware', >>>>>>> 'django.middleware.common.CommonMiddleware', >>>>>>> 'django.middleware.csrf.CsrfViewMiddleware', >>>>>>> 'django.contrib.messages.middleware.MessageMiddleware', >>>>>>> 'mezzanine.core.request.CurrentRequestMiddleware', >>>>>>> 'mezzanine.core.middleware.RedirectFallbackMiddleware', >>>>>>> 'mezzanine.core.middleware.TemplateForDeviceMiddleware', >>>>>>> 'mezzanine.core.middleware.TemplateForHostMiddleware', >>>>>>> 'mezzanine.core.middleware.AdminLoginInterfaceSelectorMiddleware', >>>>>>> 'mezzanine.core.middleware.SitePermissionMiddleware', >>>>>>> 'mezzanine.pages.middleware.PageMiddleware') Template error: In >>>>>>> template /Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> grappelli_safe/templates/admin/change_list.html, error at line 140 >>>>>>> user-defined function raised exception 130 : <p>{% blocktrans with >>>>>>> cl.result_count as counter %}{{ counter }} found{% endblocktrans %}</p> >>>>>>> 131 >>>>>>> : <a href="?{% if cl.is_popup %}pop=1{% endif %}">{% blocktrans with >>>>>>> cl.full_result_count as full_result_count %}{{ full_result_count }} >>>>>>> total{% >>>>>>> endblocktrans %}</a> 132 : </div> 133 : </div> 134 : {% endifnotequal %} >>>>>>> 135 : 136 : <!-- Search --> 137 : {% block search %}{% search_form cl >>>>>>> %}{% >>>>>>> endblock %} 138 : 139 : <!-- Date Hierarchy --> 140 : {% block >>>>>>> date_hierarchy %} {% date_hierarchy cl %} {% endblock %} 141 : 142 : {% >>>>>>> if >>>>>>> cl.has_filters %} 143 : <!-- Filter --> 144 : <div class="module >>>>>>> filter"> >>>>>>> 145 : <h2>{% trans 'Filter' %}</h2> 146 : {% for spec in cl.filter_specs >>>>>>> %}{% admin_list_filter cl spec %}{% endfor %} 147 : </div> 148 : {% >>>>>>> endif >>>>>>> %} 149 : 150 : </div> Traceback: File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/core/handlers/base.py" in >>>>>>> get_response 139. response = response.render() File >>>>>>> "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/response.py" >>>>>>> in render 105. self.content = self.rendered_content File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/template/response.py" in rendered_content 82. content = >>>>>>> template.render(context) File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/template/base.py" in render >>>>>>> 140. return self._render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/base.py" in >>>>>>> _render 134. return self.nodelist.render(context) File >>>>>>> "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/base.py" in >>>>>>> render 840. bit = self.render_node(node, context) File >>>>>>> "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/debug.py" in >>>>>>> render_node 78. return node.render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/loader_tags.py" >>>>>>> in render 123. return compiled_parent._render(context) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/template/base.py" in _render 134. return >>>>>>> self.nodelist.render(context) File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/template/base.py" in render >>>>>>> 840. bit = self.render_node(node, context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/debug.py" in >>>>>>> render_node 78. return node.render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/loader_tags.py" >>>>>>> in render 123. return compiled_parent._render(context) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/template/base.py" in _render 134. return >>>>>>> self.nodelist.render(context) File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/template/base.py" in render >>>>>>> 840. bit = self.render_node(node, context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/debug.py" in >>>>>>> render_node 78. return node.render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/loader_tags.py" >>>>>>> in render 62. result = block.nodelist.render(context) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/template/base.py" in render 840. bit = >>>>>>> self.render_node(node, context) File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/template/debug.py" in >>>>>>> render_node 78. return node.render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/loader_tags.py" >>>>>>> in render 62. result = block.nodelist.render(context) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/template/base.py" in render 840. bit = >>>>>>> self.render_node(node, context) File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/template/debug.py" in >>>>>>> render_node 78. return node.render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/defaulttags.py" >>>>>>> in render 305. return nodelist.render(context) File >>>>>>> "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/base.py" in >>>>>>> render 840. bit = self.render_node(node, context) File >>>>>>> "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/debug.py" in >>>>>>> render_node 78. return node.render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/loader_tags.py" >>>>>>> in render 62. result = block.nodelist.render(context) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/template/base.py" in render 840. bit = >>>>>>> self.render_node(node, context) File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/template/debug.py" in >>>>>>> render_node 78. return node.render(context) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/template/base.py" in >>>>>>> render 1196. _dict = func(*resolved_args, **resolved_kwargs) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/contrib/admin/templatetags/admin_list.py" in date_hierarchy >>>>>>> 341. } for day in days] File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/db/models/query.py" in __iter__ >>>>>>> 96. self._fetch_all() File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/db/models/query.py" in >>>>>>> _fetch_all 854. self._result_cache = list(self.iterator()) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/db/models/sql/compiler.py" in results_iter 1096. for rows in >>>>>>> self.execute_sql(MULTI): File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/db/models/sql/compiler.py" in >>>>>>> execute_sql 781. cursor.execute(sql, params) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/db/backends/util.py" >>>>>>> in execute 69. return super(CursorDebugWrapper, self).execute(sql, >>>>>>> params) >>>>>>> File "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/db/backends/util.py" in execute 53. return >>>>>>> self.cursor.execute(sql, params) File "/Users/sergei/Sites/mezzanine >>>>>>> /lib/python3.3/site-packages/django/db/utils.py" in __exit__ 99. >>>>>>> six.reraise(dj_exc_type, dj_exc_value, traceback) File >>>>>>> "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/utils/six.py" in >>>>>>> reraise 490. raise value.with_traceback(tb) File "/Users/sergei/Sites/ >>>>>>> mezzanine/lib/python3.3/site-packages/django/db/backends/util.py" >>>>>>> in execute 53. return self.cursor.execute(sql, params) File >>>>>>> "/Users/sergei/Sites/mezzanine/lib/python3.3/site-packages/ >>>>>>> django/db/backends/sqlite3/base.py" in execute 450. return >>>>>>> Database.Cursor.execute(self, query, params) Exception Type: >>>>>>> OperationalError at /admin/blog/blogpost/ Exception Value: user-defined >>>>>>> function raised exception >>>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Mezzanine Users" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>> >>>>> >>>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Mezzanine Users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> >> >> -- >> Stephen McDonald >> http://jupo.org >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Mezzanine Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
