search

pymedusa / Medusa

Automatic Video Library Manager for TV Shows. It watches for new episodes of your favorite shows, and when they are posted it does its magic.
https://pymedusa.com
GNU General Public License v3.0
1.76k stars 274 forks source link

[APP SUBMITTED]: sqlite3.OperationalError: no such table: scene_exceptions #7977

Closed hergonoway closed 4 years ago

hergonoway commented 4 years ago

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0] Operating System: Linux-4.4.59+-x86_64-with Locale: UTF-8 Branch: master Database: 44.15 Commit: pymedusa/Medusa@918cfe7ce01808499585ffe6c1356fd5ed369f76 Link to Log: https://gist.github.com/e685a2fb84efd29c39d358306ad79009

ERROR

2020-04-15 23:03:52 ERROR    FORCEDSEARCHQUEUE-BACKLOG-376729 :: [918cfe7] DB error: no such table: scene_exceptions
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

reemplazable commented 4 years ago

I have the same issue! 2020-04-17 01:36:20 ERROR SEARCHQUEUE-BACKLOG-293088 :: [8f6b666] DB error: OperationalError('no such table: scene_exceptions') Traceback (most recent call last): sqlite3.OperationalError: no such table: scene_exceptions 2020-04-17 01:36:20 ERROR SEARCHQUEUE-BACKLOG-293088 :: [8f6b666] DB error: no such table: scene_exceptions Traceback (most recent call last): sqlite3.OperationalError: no such table: scene_exceptions

gennit commented 4 years ago

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0] Operating System: Linux-4.15.0-96-generic-x86_64-with Locale: UTF-8 Branch: master Database: 44.15 Commit: pymedusa/Medusa@94fae847b6e7e443d74c59cb11bdbd37c464b363 Link to Log: https://gist.github.com/ee331ef95966c069dcf14077d30794a0

ERROR

2020-04-21 10:10:24 ERROR    FORCEDSEARCHQUEUE-MANUAL-80725 :: [94fae84] DB error: OperationalError('no such table: scene_exceptions')
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

p0psicles commented 4 years ago

You can fix it your self. Follow instructions. https://github.com/pymedusa/Medusa/issues/7983#issuecomment-615194766

ozhound commented 4 years ago

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0] Operating System: Linux-3.10.105-x86_64-with Locale: UTF-8 Branch: master Database: 44.15 Commit: pymedusa/Medusa@94fae847b6e7e443d74c59cb11bdbd37c464b363 Link to Log: https://gist.github.com/333aee894d56d031dd8603b532ef1806

ERROR

2020-05-10 22:20:01 ERROR    FORCEDSEARCHQUEUE-BACKLOG-298566 :: [94fae84] DB error: OperationalError('no such table: scene_exceptions')
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

ozhound commented 4 years ago

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0] Operating System: Linux-3.10.105-x86_64-with Locale: UTF-8 Branch: master Database: 44.15 Commit: pymedusa/Medusa@94fae847b6e7e443d74c59cb11bdbd37c464b363 Link to Log: https://gist.github.com/f290297e9154558fdb533a7250ac53ae

ERROR

2020-05-10 22:20:01 ERROR    FORCEDSEARCHQUEUE-BACKLOG-298566 :: [94fae84] DB error: no such table: scene_exceptions
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

ozhound commented 4 years ago

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0] Operating System: Linux-3.10.105-x86_64-with Locale: UTF-8 Branch: master Database: 44.15 Commit: pymedusa/Medusa@94fae847b6e7e443d74c59cb11bdbd37c464b363 Link to Log: No Log available

ERROR

2020-05-06 03:36:00 ERROR    SHOWUPDATER :: [94fae84] Exception generated: no such table: scene_exceptions
Traceback (most recent call last):
  File "/app/medusa/medusa/scheduler.py", line 78, in run
    self.action.run(self.force)
  File "/app/medusa/medusa/show_updater.py", line 39, in run
    refresh_exceptions_cache()
  File "/app/medusa/medusa/scene_exceptions.py", line 55, in refresh_exceptions_cache
    exceptions = main_db_con.select(query, where) or []
  File "/app/medusa/medusa/db.py", line 315, in select
    sql_results = self.action(query, args, fetchall=True)
  File "/app/medusa/medusa/db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

ozhound commented 4 years ago

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0] Operating System: Linux-3.10.105-x86_64-with Locale: UTF-8 Branch: master Database: 44.15 Commit: pymedusa/Medusa@94fae847b6e7e443d74c59cb11bdbd37c464b363 Link to Log: No Log available

ERROR

2020-05-05 22:27:56 ERROR    TORNADO :: [94fae84] Uncaught exception in APIv2: OperationalError('no such table: scene_exceptions')
Request: PATCH /api/v2/series/tvdb296762 (172.17.0.1)
With body:
{"config":{"aliases":[{"title":"Westworld.","season":-1,"custom":true}],"defaultEpisodeStatus":"Wanted","dvdOrder":false,"seasonFolders":true,"anime":false,"scene":false,"sports":false,"paused":false,"location":"/mnt/tvshows/Westworld","airByDate":false,"subtitlesEnabled":false,"release":{"requiredWords":[],"ignoredWords":[],"requiredWordsExclude":false,"ignoredWordsExclude":false},"qualities":{"preferred":[],"allowed":[2,4]},"airdateOffset":0},"language":"en"}
Traceback (most recent call last):
  File "/app/medusa/ext/tornado/web.py", line 1592, in _execute
    result = yield result
  File "/app/medusa/ext/tornado/gen.py", line 1133, in run
    value = future.result()
  File "/app/medusa/ext/tornado/gen.py", line 1141, in run
    yielded = self.gen.throw(*exc_info)
  File "/app/medusa/medusa/server/api/v2/base.py", line 83, in async_call
    content = yield IOLoop.current().run_in_executor(executor, prepared)
  File "/app/medusa/ext/tornado/gen.py", line 1133, in run
    value = future.result()
  File "/usr/lib/python3.8/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/app/medusa/medusa/server/api/v2/series.py", line 152, in patch
    if patch_field and patch_field.patch(series, value):
  File "/app/medusa/medusa/server/api/v2/base.py", line 535, in patch
    setattr(target, self.attr, self.converter(value))
  File "/app/medusa/medusa/tv/base.py", line 57, in __setattr__
    super(TV, self).__setattr__(key, value)
  File "/app/medusa/medusa/tv/series.py", line 610, in aliases
    update_scene_exceptions(self, exceptions)
  File "/app/medusa/medusa/scene_exceptions.py", line 209, in update_scene_exceptions
    main_db_con.action(
  File "/app/medusa/medusa/db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
  File "/app/medusa/medusa/db.py", line 115, in _execute
    sql_results = cursor.execute(query, args)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

uncyspam commented 3 years ago

INFO

Python Version: 3.8.5 (default, Jul 20 2020, 23:11:29) [GCC 9.3.0] Operating System: Linux-4.4.59+-x86_64-with Locale: UTF-8 Branch: master Database: 44.16 Commit: pymedusa/Medusa@918cfe7ce01808499585ffe6c1356fd5ed369f76 Link to Log: https://gist.github.com/5c6e929bbe2bb0de6652ef1b75424c19

ERROR

2020-11-03 20:08:08 ERROR    MAIN :: [918cfe7] DB error: OperationalError('no such table: scene_exceptions')
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

uncyspam commented 3 years ago

INFO

Python Version: 3.8.5 (default, Jul 20 2020, 23:11:29) [GCC 9.3.0] Operating System: Linux-4.4.59+-x86_64-with Locale: UTF-8 Branch: master Database: 44.16 Commit: pymedusa/Medusa@918cfe7ce01808499585ffe6c1356fd5ed369f76 Link to Log: https://gist.github.com/4361b94768fa7f1a3d4ee0238c307b7e

ERROR

2020-11-03 20:08:08 ERROR    MAIN :: [918cfe7] DB error: no such table: scene_exceptions
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators