search

opensemanticsearch / open-semantic-search-apps

Python/Django based webapps and web user interfaces for search, structure (meta data management like thesaurus, ontologies, annotations and named entities) and data import (ETL like text extraction, OCR and crawling filesystems or websites)
https://opensemanticsearch.org/
GNU General Public License v3.0
95 stars 36 forks source link

OperationalError at /setup/ #53

Open swagat123 opened 5 years ago

swagat123 commented 5 years ago

Hi All

I am facing the setup error while click on config tab. Below is the trace back details.

Environment:

Request Method: GET
Request URL: http://localhost/search-apps/setup/

Django Version: 1.10.7
Python Version: 3.5.3
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',
 '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.auth.middleware.SessionAuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'django.middleware.security.SecurityMiddleware')

Traceback:

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

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

The above exception (no such column: setup_setup.segmentation_sentences) was the direct cause of the following exception:

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

File "/usr/lib/python3/dist-packages/django/core/handlers/base.py" in _legacy_get_response
  249.             response = self._get_response(request)

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

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

File "/var/lib/opensemanticsearch/setup/views.py" in update_setup
  473.  setup = Setup.objects.get(pk=pk)

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

File "/usr/lib/python3/dist-packages/django/db/models/query.py" in get
  379.         num = len(clone)

File "/usr/lib/python3/dist-packages/django/db/models/query.py" in __len__
  238.         self._fetch_all()

File "/usr/lib/python3/dist-packages/django/db/models/query.py" in _fetch_all
  1087.             self._result_cache = list(self.iterator())

File "/usr/lib/python3/dist-packages/django/db/models/query.py" in __iter__
  54.         results = compiler.execute_sql()

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

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

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

File "/usr/lib/python3/dist-packages/django/db/utils.py" in __exit__
  94.                 six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/usr/lib/python3/dist-packages/django/utils/six.py" in reraise
  685.             raise value.with_traceback(tb)

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

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

Exception Type: OperationalError at /setup/
Exception Value: no such column: setup_setup.segmentation_sentences

Request Method: | GET
-- | --
http://localhost/search-apps/setup/
1.10.7
OperationalError
no such column: setup_setup.segmentation_sentences
/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py in execute, line 337
/usr/local/bin/python3
3.5.3
['/var/lib/opensemanticsearch',  '/usr/lib/python35.zip',  '/usr/lib/python3.5',  '/usr/lib/python3.5/plat-x86_64-linux-gnu',  '/usr/lib/python3.5/lib-dynload',  '/usr/local/lib/python3.5/dist-packages',  '/usr/lib/python3/dist-packages',  '/usr/lib/python3/dist-packages',  '/usr/lib/python3/dist-packages/opensemanticetl',  '/usr/local/lib/python3.5/dist-packages/odf',  '/usr/local/lib/python3.5/dist-packages/odf',  '/usr/local/lib/python3.5/dist-packages/odf',  '/usr/local/lib/python3.5/dist-packages/odf',  '/usr/local/lib/python3.5/dist-packages/odf',  '/usr/local/lib/python3.5/dist-packages/odf',  '/usr/local/lib/python3.5/dist-packages/odf',

Why i am facing this issue.Do i have to change any settings. I appreciate your suggestions. Regards Swagat

Mandalka commented 5 years ago

How did you install it?

Form Source?

Your Django DB seems not to include a new field which is created from the model by python3 manage.py migrate which is called by installation of deb packages.