If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

Task Activity page shows an error

VERIFIED FIXED

Status

Mozilla QA
One and Done
P1
normal
VERIFIED FIXED
2 years ago
2 years ago

People

(Reporter: rbillings, Assigned: bsilverberg)

Tracking

Details

(Reporter)

Description

2 years ago
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)

Updated

2 years ago
Assignee: nobody → bob.silverberg
Priority: -- → P1
(Assignee)

Comment 1

2 years ago
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
Last Resolved: 2 years ago
Resolution: --- → FIXED
(Reporter)

Comment 2

2 years ago
Verified fix
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.