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.78k stars 276 forks source link

[APP SUBMITTED]: sqlite3.OperationalError: duplicate column name: pubdate #11698

Open artificial-chaos opened 5 months ago

artificial-chaos commented 5 months ago

INFO

Python Version: 3.10.8 (main, Oct 13 2022, 23:33:11) [GCC 10.3.1 20211027] Operating System: Linux-4.4.302+-x86_64-with Locale: UTF-8 Branch: master Database: 44.19 Commit: pymedusa/Medusa@c5a1e37bbaaebd49dd57ce5adf4e92c308fa6de3 Link to Log: No Log available

ERROR

2024-04-11 20:01:21 ERROR    TORNADO :: [c5a1e37] Uncaught exception in APIv2: OperationalError('duplicate column name: pubdate')
Request: GET /api/v2/providers/therarbg/results?limit=1000&showslug=tvmaze329&season=15&episode=19&page=1 (172.17.0.1)
Traceback (most recent call last):
  File "/app/medusa/ext/tornado/web.py", line 1704, in _execute
    result = await result
  File "/app/medusa/ext/tornado/gen.py", line 769, in run
    yielded = self.gen.throw(*exc_info)  # type: ignore
  File "/app/medusa/medusa/server/api/v2/base.py", line 64, in async_call
    content = yield IOLoop.current().run_in_executor(executor, prepared)
  File "/app/medusa/ext/tornado/gen.py", line 762, in run
    value = future.result()
  File "/usr/local/lib/python3.10/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/app/medusa/medusa/server/api/v2/providers.py", line 70, in get
    provider_results = provider.cache.get_results(show_slug=show_slug, season=season, episode=episode)
  File "/app/medusa/medusa/tv/cache.py", line 637, in get_results
    cache_db_con = self._get_db()
  File "/app/medusa/medusa/tv/cache.py", line 141, in _get_db
    self.provider_db = CacheDBConnection(self.provider_id)
  File "/app/medusa/medusa/tv/cache.py", line 103, in __init__
    self.addColumn(provider_id, column, data_type, default)
  File "/app/medusa/medusa/db.py", line 425, in addColumn
    self.action('ALTER TABLE [%s] ADD %s %s' % (table, column, column_type))
  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: duplicate column name: pubdate

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators