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/blog/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 450Python Executable: > /Users/sergei/Sites/mezzanine/bin/python3Python 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-packages/grappelli_safe/templates/admin/change_list.html, > > error at line *140* > user-defined function raised exception130 <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/#> > VariableValueparams > > ('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.
