IBM / page-lab

PageLab enables web performance, accessibility, SEO, etc testing at scale.
Apache License 2.0
19 stars 10 forks source link

Programming error in admin UI #35

Closed daviddahl closed 5 years ago

daviddahl commented 5 years ago

I think this has something to do with my current database - maybe needs that migration script @ecumike wrote?

seeing this when editing some urls:

Environment:

Request Method: GET
Request URL: http://127.0.0.1:8000/admin/report/url/217/change/

Django Version: 2.0.8
Python Version: 3.5.2
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.flatpages',
 'django.contrib.sites',
 'report',
 'inline_static',
 'django_extensions',
 'dbbackup',
 'debug_toolbar']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'debug_toolbar.middleware.DebugToolbarMiddleware']

Template error:
In template /home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/contrib/admin/templates/admin/includes/fieldset.html, error at line 17
   column report_lighthouserun.seo_score does not exist
LINE 1: ...ps", "report_lighthouserun"."redirect_wasted_ms", "report_li...
                                                             ^

   7 :         <div class="form-row{% if line.fields|length_is:'1' and line.errors %} errors{% endif %}{% if not line.has_visible_field %} hidden{% endif %}{% for field in line %}{% if field.field.name %} field-{{ field.field.name }}{% endif %}{% endfor %}">
   8 :             {% if line.fields|length_is:'1' %}{{ line.errors }}{% endif %}
   9 :             {% for field in line %}
   10 :                 <div{% if not line.fields|length_is:'1' %} class="field-box{% if field.field.name %} field-{{ field.field.name }}{% endif %}{% if not field.is_readonly and field.errors %} errors{% endif %}{% if field.field.is_hidden %} hidden{% endif %}"{% elif field.is_checkbox %} class="checkbox-row"{% endif %}>
   11 :                     {% if not line.fields|length_is:'1' and not field.is_readonly %}{{ field.errors }}{% endif %}
   12 :                     {% if field.is_checkbox %}
   13 :                         {{ field.field }}{{ field.label_tag }}
   14 :                     {% else %}
   15 :                         {{ field.label_tag }}
   16 :                         {% if field.is_readonly %}
   17 :                             <div class="readonly"> {{ field.contents }} </div>
   18 :                         {% else %}
   19 :                             {{ field.field }}
   20 :                         {% endif %}
   21 :                     {% endif %}
   22 :                     {% if field.field.help_text %}
   23 :                         <div class="help">{{ field.field.help_text|safe }}</div>
   24 :                     {% endif %}
   25 :                 </div>
   26 :             {% endfor %}
   27 :         </div>

Traceback:

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/fields/related_descriptors.py" in __get__
  158.             rel_obj = self.field.get_cached_value(instance)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/fields/mixins.py" in get_cached_value
  13.             return instance._state.fields_cache[cache_name]

During handling of the above exception ('lighthouse_run'), another exception occurred:

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

The above exception (column report_lighthouserun.seo_score does not exist
LINE 1: ...ps", "report_lighthouserun"."redirect_wasted_ms", "report_li...
                                                             ^
) was the direct cause of the following exception:

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/core/handlers/exception.py" in inner
  35.             response = get_response(request)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  158.                 response = self.process_exception_by_middleware(e, request)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  156.                 response = response.render()

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/response.py" in render
  106.             self.content = self.rendered_content

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/response.py" in rendered_content
  83.         content = template.render(context, self._request)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/backends/django.py" in render
  61.             return self.template.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  175.                     return self._render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/test/utils.py" in instrumented_test_render
  98.     return self.nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/loader_tags.py" in render
  155.             return compiled_parent._render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/test/utils.py" in instrumented_test_render
  98.     return self.nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/loader_tags.py" in render
  155.             return compiled_parent._render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/test/utils.py" in instrumented_test_render
  98.     return self.nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/loader_tags.py" in render
  67.                 result = block.nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/loader_tags.py" in render
  67.                 result = block.nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/defaulttags.py" in render
  211.                     nodelist.append(node.render_annotated(context))

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/loader_tags.py" in render
  194.                 return template.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  177.                 return self._render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/test/utils.py" in instrumented_test_render
  98.     return self.nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/defaulttags.py" in render
  211.                     nodelist.append(node.render_annotated(context))

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/defaulttags.py" in render
  211.                     nodelist.append(node.render_annotated(context))

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/defaulttags.py" in render
  314.                 return nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/defaulttags.py" in render
  314.                 return nodelist.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  943.                 bit = node.render_annotated(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render_annotated
  910.             return self.render(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in render
  993.             output = self.filter_expression.resolve(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in resolve
  676.                 obj = self.var.resolve(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in resolve
  802.             value = self._resolve_lookup(context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/template/base.py" in _resolve_lookup
  864.                             current = current()

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/contrib/admin/helpers.py" in contents
  201.             f, attr, value = lookup_field(field, obj, model_admin)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/contrib/admin/utils.py" in lookup_field
  295.         value = getattr(obj, name)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/fields/related_descriptors.py" in __get__
  164.                 rel_obj = self.get_object(instance)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/fields/related_descriptors.py" in get_object
  139.         return qs.get(self.field.get_reverse_related_filter(instance))

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/query.py" in get
  397.         num = len(clone)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/query.py" in __len__
  254.         self._fetch_all()

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/query.py" in _fetch_all
  1179.             self._result_cache = list(self._iterable_class(self))

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/query.py" in __iter__
  53.         results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/models/sql/compiler.py" in execute_sql
  1068.             cursor.execute(sql, params)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/debug_toolbar/panels/sql/tracking.py" in execute
  164.         return self._record(self.cursor.execute, sql, params)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/debug_toolbar/panels/sql/tracking.py" in _record
  106.             return method(sql, params)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
  100.             return super().execute(sql, params)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
  68.         return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
  77.         return executor(sql, params, many, context)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/utils.py" in __exit__
  89.                 raise dj_exc_value.with_traceback(traceback) from exc_value

File "/home/ddahl/github.com/env-page-lab/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

Exception Type: ProgrammingError at /admin/report/url/217/change/
Exception Value: column report_lighthouserun.seo_score does not exist
LINE 1: ...ps", "report_lighthouserun"."redirect_wasted_ms", "report_li...
                                                             ^
ecumike commented 5 years ago

You still getting this error? Or did you determine just something up with your local?

daviddahl commented 5 years ago

nope. it was a migration thing methinks