open-semantic-search icon indicating copy to clipboard operation
open-semantic-search copied to clipboard

Thesaurus on Docker

Open danielrosero opened this issue 2 years ago • 0 comments

Hello. I have been using the docker version of opensemanticsearch, and today found out that Thesaurus is not working properly.

When I try to create a new entry through the path /search-apps/thesaurus/create I receive this error:

**OperationalError at /thesaurus/create

no such table: main.thesaurus_facet__old**

Environment:


Request Method: POST
Request URL: http://*.*.*.*:8080/search-apps/thesaurus/create

Django Version: 2.0
Python Version: 3.9.2
Installed Applications:
('django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'setup',
 'thesaurus',
 'crawler',
 'files',
 'datasources',
 'annotate',
 'search_list',
 'csv_manager',
 'rss_manager',
 'ontologies',
 'querytagger',
 'morphology',
 'hypothesis',
 'twitter',
 'search_entity',
 'visual_graph_explorer',
 'entity_rest_api',
 'import_export')
Installed Middleware:
('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',
 'django.middleware.security.SecurityMiddleware')



Traceback:

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/sqlite3/base.py" in execute
  303.         return Database.Cursor.execute(self, query, params)

The above exception (no such table: main.thesaurus_facet__old) was the direct cause of the following exception:

File "/usr/local/lib/python3.9/dist-packages/django/core/handlers/exception.py" in inner
  35.             response = get_response(request)

File "/usr/local/lib/python3.9/dist-packages/django/core/handlers/base.py" in _get_response
  128.                 response = self.process_exception_by_middleware(e, request)

File "/usr/local/lib/python3.9/dist-packages/django/core/handlers/base.py" in _get_response
  126.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/var/lib/opensemanticsearch/thesaurus/views.py" in create_concept
  122. 			concept = form.save()

File "/usr/local/lib/python3.9/dist-packages/django/forms/models.py" in save
  456.             self.instance.save()

File "/usr/local/lib/python3.9/dist-packages/django/db/models/base.py" in save
  728.         self.save_base(using=using, force_insert=force_insert,

File "/usr/local/lib/python3.9/dist-packages/django/db/models/base.py" in save_base
  759.             updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)

File "/usr/local/lib/python3.9/dist-packages/django/db/models/base.py" in _save_table
  842.             result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)

File "/usr/local/lib/python3.9/dist-packages/django/db/models/base.py" in _do_insert
  879.         return manager._insert([self], fields=fields, return_id=update_pk,

File "/usr/local/lib/python3.9/dist-packages/django/db/models/manager.py" in manager_method
  82.                 return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/usr/local/lib/python3.9/dist-packages/django/db/models/query.py" in _insert
  1125.         return query.get_compiler(using=using).execute_sql(return_id)

File "/usr/local/lib/python3.9/dist-packages/django/db/models/sql/compiler.py" in execute_sql
  1280.                 cursor.execute(sql, params)

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/utils.py" in execute
  100.             return super().execute(sql, params)

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/utils.py" in execute
  68.         return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/utils.py" in _execute_with_wrappers
  77.         return executor(sql, params, many, context)

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

File "/usr/local/lib/python3.9/dist-packages/django/db/utils.py" in __exit__
  89.                 raise dj_exc_value.with_traceback(traceback) from exc_value

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

File "/usr/local/lib/python3.9/dist-packages/django/db/backends/sqlite3/base.py" in execute
  303.         return Database.Cursor.execute(self, query, params)

Exception Type: OperationalError at /thesaurus/create
Exception Value: no such table: main.thesaurus_facet__old

Any one else having this problem?

Regards.

danielrosero avatar Jun 30 '22 09:06 danielrosero