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.81k stars 278 forks source link

[APP SUBMITTED]: sqlite3.OperationalError: duplicate column name: size #8794

Closed Rouzax closed 4 years ago

Rouzax commented 4 years ago

INFO

Python Version: 3.8.6 (tags/v3.8.6:db45529, Sep 23 2020, 15:52:53) [MSC v.1927 64 bit (AMD64)] Operating System: Windows-10-10.0.17763-SP0 Locale: cp1252 Branch: master Database: 44.17 Commit: pymedusa/Medusa@e6025de42a034b5887e5806fda210e30f5a1e150 Link to Log: No Log available

ERROR

2020-11-30 17:14:54 ERROR    TORNADO :: [e6025de] Uncaught exception in APIv2: OperationalError('duplicate column name: size')
Request: GET /api/v2/providers/torrenting/results?limit=1000&showslug=tvdb371940&season=1&page=1 (192.168.2.16)
Traceback (most recent call last):
  File "C:\GitHub\Medusa\ext\tornado\web.py", line 1592, in _execute
    result = yield result
  File "C:\GitHub\Medusa\ext\tornado\gen.py", line 1133, in run
    value = future.result()
  File "C:\GitHub\Medusa\ext\tornado\gen.py", line 1141, in run
    yielded = self.gen.throw(*exc_info)
  File "C:\GitHub\Medusa\medusa\server\api\v2\base.py", line 83, in async_call
    content = yield IOLoop.current().run_in_executor(executor, prepared)
  File "C:\GitHub\Medusa\ext\tornado\gen.py", line 1133, in run
    value = future.result()
  File "C:\Python38\lib\concurrent\futures\thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "C:\GitHub\Medusa\medusa\server\api\v2\providers.py", line 58, in get
    provider_results = provider.cache.get_results(show_slug=show_slug, season=season, episode=episode)
  File "C:\GitHub\Medusa\medusa\tv\cache.py", line 637, in get_results
    cache_db_con = self._get_db()
  File "C:\GitHub\Medusa\medusa\tv\cache.py", line 141, in _get_db
    self.provider_db = CacheDBConnection(self.provider_id)
  File "C:\GitHub\Medusa\medusa\tv\cache.py", line 103, in __init__
    self.addColumn(provider_id, column, data_type, default)
  File "C:\GitHub\Medusa\medusa\db.py", line 425, in addColumn
    self.action('ALTER TABLE [%s] ADD %s %s' % (table, column, column_type))
  File "C:\GitHub\Medusa\medusa\db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
  File "C:\GitHub\Medusa\medusa\db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: duplicate column name: size

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

Rouzax commented 4 years ago

Sorry, this was after adding the provider through Jackett with the same name as the native provider