638298 - several mobile categories throw http 500 on staging/preview

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

[Vishal Kamdar [:vish_moz]]

http 500 for several mobile categories on preview:
https://addons.allizom.org/en-US/mobile/extensions/photos-media/
https://addons.allizom.org/en-US/mobile/extensions/security-privacy/
https://addons.allizom.org/en-US/mobile/extensions/shopping/
https://addons.allizom.org/en-US/mobile/extensions/social-networking/

Comment 1

[krupa raj[:krupa]]

File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/core/handlers/base.py", line 111, in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-mobility/mobility/decorators.py", line 23, in wrapper
   return f(request, *args, **kw)

 File "/data/amo_python/www/preview/zamboni/apps/browse/views.py", line 167, in extensions
   'search_cat': '%s,0' % TYPE})

 File "/data/amo_python/www/preview/zamboni/vendor/src/jingo/jingo/__init__.py", line 78, in render
   rendered = render_to_string(request, template, context)

 File "/data/amo_python/www/preview/zamboni/vendor/src/jingo/jingo/__init__.py", line 96, in render_to_string
   return template.render(**get_context())

 File "/usr/lib/python2.6/site-packages/jinja2/environment.py", line 891, in render
   return self.environment.handle_exception(exc_info, True)

 File "/data/amo_python/www/preview/zamboni/apps/browse/templates/browse/extensions.html", line 1, in top-level template code
   {% extends "browse/base_listing.html" %}

 File "/data/amo_python/www/preview/zamboni/apps/browse/templates/browse/base_listing.html", line 1, in top-level template code
   {% extends "base_side_categories.html" %}

 File "/data/amo_python/www/preview/zamboni/templates/base_side_categories.html", line 1, in top-level template code
   {% extends "base.html" %}

 File "/data/amo_python/www/preview/zamboni/templates/base.html", line 99, in top-level template code
   {% block main_content %}

 File "/data/amo_python/www/preview/zamboni/templates/base_side_categories.html", line 9, in block "main_content"
   {% block content %}{% endblock %}

 File "/data/amo_python/www/preview/zamboni/apps/browse/templates/browse/extensions.html", line 28, in block "content"
   {{ addon_listing_items(addons.object_list, src='category',

 File "/data/amo_python/www/preview/zamboni/vendor/src/jingo/jingo/__init__.py", line 146, in wrapper
   t = env.get_template(template).render(context)

 File "/usr/lib/python2.6/site-packages/jinja2/environment.py", line 891, in render
   return self.environment.handle_exception(exc_info, True)

 File "/data/amo_python/www/preview/zamboni/apps/addons/templates/addons/listing/items.html", line 4, in top-level template code
   {% cache addons, extra=[collection, username] %}

 File "/data/amo_python/www/preview/zamboni/apps/amo/ext.py", line 22, in _cache_support
   return sup(key, obj, timeout, extra, caller)

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-cache-machine/caching/ext.py", line 74, in _cache_support
   return caching.base.cached_with(obj, caller, key, timeout)

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-cache-machine/caching/base.py", line 285, in cached_with
   return cached(f, key, timeout)

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-cache-machine/caching/base.py", line 265, in cached
   val = function()

 File "/data/amo_python/www/preview/zamboni/apps/addons/templates/addons/listing/items.html", line 5, in template
   {% for addon in addons %}

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/models/query.py", line 107, in _result_iter
   self._fill_cache()

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/models/query.py", line 772, in _fill_cache
   self._result_cache.append(self._iter.next())

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-cache-machine/caching/base.py", line 103, in __iter__
   obj = iterator.next()

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-cache-machine/caching/base.py", line 169, in fetch_by_id
   new = dict((byid(o), o) for o in others)

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/models/query.py", line 89, in __iter__
   self._iter = self.iterator()

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-cache-machine/caching/base.py", line 136, in iterator
   return iter(iterator())

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-queryset-transform/queryset_transform/__init__.py", line 22, in iterator
   fn(results)

 File "/data/amo_python/www/preview/zamboni/apps/amo/decorators.py", line 67, in wrapper
   return f(*args, **kw)

 File "/data/amo_python/www/preview/zamboni/apps/addons/models.py", line 502, in transformer
   .transform(Version.transformer))

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/models/query.py", line 89, in __iter__
   self._iter = self.iterator()

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-cache-machine/caching/base.py", line 136, in iterator
   return iter(iterator())

 File "/data/amo_python/www/preview/zamboni/vendor/src/django-queryset-transform/queryset_transform/__init__.py", line 20, in iterator
   results = list(result_iter)

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/models/query.py", line 273, in iterator
   for row in compiler.results_iter():

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/models/sql/compiler.py", line 680, in results_iter
   for rows in self.execute_sql(MULTI):

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/models/sql/compiler.py", line 735, in execute_sql
   cursor.execute(sql, params)

 File "/data/amo_python/www/preview/zamboni/vendor/src/django/django/db/backends/mysql/base.py", line 86, in execute
   return self.cursor.execute(query, args)

 File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
   self.errorhandler(self, exc, value)

 File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
   raise errorclass, errorvalue

OperationalError: (1054, "Unknown column 'versions.reviewed' in 'field list'")

Comment 2

[Vishal Kamdar [:vish_moz]]

Verified, FIXED.