Hi,
I am getting below error on eucalyptus.2 tag, when trying to add a
certificate html configurations in LMS admin.
Enter code here...2016-11-02 10:34:22,494 ERROR 19290 [django.request] base.
py:256 - Internal Server Error: /admin/certificates/
certificatehtmlviewconfiguration/
Traceback (most recent call last):
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/handlers/base.py",
line 164, in get_response
response = response.render()
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/response.py",
line 158, in render
self.content = self.rendered_content
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/response.py",
line 135, in rendered_content
content = template.render(context, self._request)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/backends/django.py",
line 74, in render
return self.template.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 210, in render
return self._render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 202, in _render
return self.nodelist.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 905, in render
bit = self.render_node(node, context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 919, in render_node
return node.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py",
line 135, in render
return compiled_parent._render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 202, in _render
return self.nodelist.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 905, in render
bit = self.render_node(node, context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 919, in render_node
return node.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py",
line 135, in render
return compiled_parent._render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 202, in _render
return self.nodelist.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 905, in render
bit = self.render_node(node, context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 919, in render_node
return node.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py",
line 65, in render
result = block.nodelist.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 905, in render
bit = self.render_node(node, context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 919, in render_node
return node.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py",
line 65, in render
result = block.nodelist.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 905, in render
bit = self.render_node(node, context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 919, in render_node
return node.render(context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py",
line 1273, in render
_dict = func(*resolved_args, **resolved_kwargs)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/contrib/admin/templatetags/admin_list.py",
line 388, in date_hierarchy
} for month in months]
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py",
line 162, in __iter__
self._fetch_all()
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py",
line 965, in _fetch_all
self._result_cache = list(self.iterator())
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py",
line 1217, in iterator
for row in compiler.results_iter():
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 800, in results_iter
row = self.apply_converters(row, converters)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 784, in apply_converters
value = converter(value, expression, self.connection,
self.query.context)
File
"/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/expressions.py",
line 927, in convert_value
"Database returned an invalid value in QuerySet.datetimes(). "
ValueError: Database returned an invalid value in QuerySet.datetimes(). Are
time zone definitions for your database and pytz installed?
pytz is installed in edxapp environment.
I have tried below:
mysql_tzinfo_to_sql /usr/share/zoneinfo/GMT GMT | mysql -u root -p mysql
mysql_tzinfo_to_sql /usr/share/zoneinfo/UTC UTC | mysql -u root -p mysql
mysql -u root -p -e "flush tables;" mysql
sudo service mysql restart
Thanks
Avadhut
--
You received this message because you are subscribed to the Google Groups
"General Open edX discussion" group.
To view this discussion on the web visit
https://groups.google.com/d/msgid/edx-code/f3a23d19-0b12-4bc9-b0d1-11c2e38e9869%40googlegroups.com.
