775869 - [traceback] OperationalError: (1054, "Unknown column 'reviews.client_data_id' in 'field list'") on detail page

Status: VERIFIED FIXED

(Marketplace Graveyard :: Consumer Pages, defect)

Description

[Aditya Jalgaonkar [:Adi_J]]

User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:16.0) Gecko/16.0 Firefox/16.0
Build ID: 20120625030537

Steps to reproduce:

1. Go to the Marketplace home page 

2. Try to click on any of the apps for the detailed page.


Actual results:

* There is the following :
Oops! We had an error.

We'll get to fixing that soon.

Screen Cast: http://screencast.com/t/GklwVPYhFY1


Expected results:

* it should load the app details page

Comment 1

[Christopher Van Wiemeersch [:cvan]]

http://sentry.dmz.phx1.mozilla.com/marketplace-dev/group/1638/



OperationalError: (1054, "Unknown column 'reviews.client_data_id' in 'field list'")

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/detail/views.py", line 34, in detail
    return jingo.render(request, 'detail/app.html', ctx)

  File "jingo/__init__.py", line 80, in render
    rendered = render_to_string(request, template, context)

  File "jingo/__init__.py", line 98, in render_to_string
    return template.render(**get_context())

  File "jinja2/environment.py", line 891, in render
    return self.environment.handle_exception(exc_info, True)

  File "/data/www/addons-dev.allizom.org/zamboni/mkt/detail/templates/detail/app.html", line 22, in top-level template code
    {% set first_cat = cats[0] if cats else None %}

  File "/data/www/addons-dev.allizom.org/zamboni/mkt/detail/templates/detail/protected_app.html", line 86, in top-level template code
    target="_blank">{{ _('Learn more') }}</a>

  File "/data/www/addons-dev.allizom.org/zamboni/mkt/templates/mkt/base.html", line 195, in top-level template code
    {% block js %}{% endblock %}

  File "/data/www/addons-dev.allizom.org/zamboni/mkt/templates/mkt/fragment.html", line 8, in top-level template code
    {% block content %}

  File "/data/www/addons-dev.allizom.org/zamboni/mkt/detail/templates/detail/app.html", line 231, in block "content"
    {% if reviews %}

  File "django/db/models/query.py", line 113, in __nonzero__
    iter(self).next()

  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 "caching/base.py", line 103, in __iter__
    obj = iterator.next()

  File "caching/base.py", line 169, in fetch_by_id
    new = dict((byid(o), o) for o in others)

  File "django/db/models/query.py", line 89, in __iter__
    self._iter = self.iterator()

  File "caching/base.py", line 136, in iterator
    return iter(iterator())

  File "queryset_transform/__init__.py", line 20, in iterator
    results = list(result_iter)

  File "django/db/models/query.py", line 273, in iterator
    for row in compiler.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

Comment 2

[Christopher Van Wiemeersch [:cvan]]

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

Comment 4

[Aditya Jalgaonkar [:Adi_J]]

Verified Fixed :) thanks