763734 - [traceback] DatabaseError: (1146, "Table 'addons_dev_allizom_org.ratings' doesn't exist")

Status: VERIFIED FIXED

(Marketplace Graveyard :: Consumer Pages, defect)

Description

[krupa raj[:krupa]]

steps to reproduce:
1. Load https://marketplace-dev.allizom.org/en-US/app/the-times-crossword/reviews/27/

Stacktrace (most recent call last):

  File "django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)

  File "addons/decorators.py", line 32, in wrapper
    return f(request, addon, *args, **kw)

  File "mkt/ratings/views.py", line 45, in review_list
    review = get_object_or_404(Rating, pk=review_id)

  File "django/shortcuts/__init__.py", line 113, in get_object_or_404
    return queryset.get(*args, **kwargs)

  File "django/db/models/query.py", line 344, in get
    num = len(clone)

  File "django/db/models/query.py", line 82, in __len__
    self._result_cache = list(self.iterator())

  File "caching/base.py", line 103, in __iter__
    obj = iterator.next()

  File "caching/base.py", line 159, in fetch_by_id
    pks = [val[0] for val in vals]

  File "django/db/models/query.py", line 107, in _result_iter
    self._fill_cache()

  File "django/db/models/query.py", line 784, in _fill_cache
    self._result_cache.append(self._iter.next())

  File "django/db/models/query.py", line 971, in iterator
    for row in self.query.get_compiler(self.db).results_iter():

  File "django/db/models/sql/compiler.py", line 695, in results_iter
    for rows in self.execute_sql(MULTI):

  File "django/db/models/sql/compiler.py", line 750, in execute_sql
    cursor.execute(sql, params)

  File "django/db/backends/mysql/base.py", line 86, in execute
    return self.cursor.execute(query, args)

  File "MySQLdb/cursors.py", line 173, in execute
    self.errorhandler(self, exc, value)

  File "MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue

DatabaseError: (1146, "Table 'addons_dev_allizom_org.ratings' doesn't exist")

Comment 1

[Christopher Van Wiemeersch [:cvan]]

This will get fixed with the new review detail pages (bug 755956).

Comment 2

[Christopher Van Wiemeersch [:cvan]]

https://github.com/mozilla/zamboni/commit/c9329b7

Comment 3

[krupa raj[:krupa]]

https://marketplace-dev.allizom.org/en-US/app/the-times-crossword/reviews/27/ gives a 404 which is way better than a traceback