Closed Bug 1201501 Opened 9 years ago Closed 9 years ago

Task Activity page shows an error

Categories

(Mozilla QA Graveyard :: One and Done, defect, P1)

defect

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: rbillings, Assigned: bsilverberg)

Details

The task activity page is down on the new dev and heroku prod sites:
https://oneanddone-prod.herokuapp.com/en-US/tasks/activity/

Stack trace:
Internal Server Error: /en-US/tasks/activity/
Traceback (most recent call last):
  File "/app/.heroku/python/lib/python2.7/site-packages/django/core/handlers/base.py", line 137, in get_response
    response = response.render()
  File "/app/.heroku/python/lib/python2.7/site-packages/django/template/response.py", line 103, in render
    self.content = self.rendered_content
  File "/app/.heroku/python/lib/python2.7/site-packages/django/template/response.py", line 80, in rendered_content
    content = template.render(context)
  File "/app/.heroku/python/lib/python2.7/site-packages/jingo/__init__.py", line 195, in render
    return super(Template, self).render(context_dict)
  File "/app/.heroku/python/lib/python2.7/site-packages/jinja2/environment.py", line 969, in render
    return self.environment.handle_exception(exc_info, True)
  File "/app/.heroku/python/lib/python2.7/site-packages/jinja2/environment.py", line 742, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "./oneanddone/tasks/templates/tasks/activity.html", line 6, in top-level template code
    {% set title = _('Task Activity') %}
  File "./oneanddone/base/templates/base/base.html", line 105, in top-level template code
    {% block content %}{% endblock %}
  File "./oneanddone/tasks/templates/tasks/activity.html", line 13, in block "content"
    {% include 'tasks/activity_listing.html' %}
  File "./oneanddone/tasks/templates/tasks/activity_listing.html", line 12, in top-level template code
    {% for attempt in attempts %}
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py", line 141, in __iter__
    self._fetch_all()
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py", line 966, in _fetch_all
    self._result_cache = list(self.iterator())
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py", line 265, in iterator
    for row in compiler.results_iter():
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 701, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 787, in execute_sql
    cursor.execute(sql, params)
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/app/.heroku/python/lib/python2.7/site-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
ProgrammingError: column "second" does not exist
LINE 1: SELECT (TIMESTAMPDIFF(SECOND, tasks_taskattempt.created, tas...
                              ^
Assignee: nobody → bob.silverberg
Priority: -- → P1
This has been fixed in my heroku branch [1] and has been deployed to the heroku prod site [2].

[1] https://github.com/bobsilverberg/oneanddone/commit/6812e2704593040b5a517ef918ede57951246de1
[2] https://oneanddone-prod.herokuapp.com/en-US/tasks/activity/
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
Verified fix
Status: RESOLVED → VERIFIED
Product: Mozilla QA → Mozilla QA Graveyard
You need to log in before you can comment on or make changes to this bug.