scanner-research / esper-tv

Esper instance for TV news analysis
Apache License 2.0
39 stars 10 forks source link

ProgrammingError: column query_default_video.has_captions does not exist #70

Closed pkdog closed 6 years ago

pkdog commented 6 years ago

Hello.I setup the environment following the readme file.After importing example-dataset, I search on the web UI,it showed errors.

Traceback (most recent call last):
  File "/app/query/search.py", line 35, in search
    result = FN()
  File "<string>", line 2, in all_videos
  File "/app/query/datasets/stdlib.py", line 162, in qs_to_result
    'video': frame.video.id,
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/related_descriptors.py", line 184, in __get__
    rel_obj = self.get_object(instance)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/related_descriptors.py", line 159, in get_object
    return qs.get(self.field.get_reverse_related_filter(instance))
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 373, in get
    num = len(clone)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 232, in __len__
    self._fetch_all()
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 1102, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 53, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 876, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 80, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
ProgrammingError: column query_default_video.has_captions does not exist
LINE 1: ...t_video"."width", "query_default_video"."height", "query_def... 
willcrichton commented 6 years ago

I think the example db was out of date. I just updated it. Try running through the install from scratch and let me know if that works.