Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Sign in
  • S sickrage
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 42
    • Issues 42
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • Deployments
    • Deployments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • Repository
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • SiCKRAGE
  • sickrage
  • Issues
  • #583

Closed
Open
Created Sep 24, 2021 by mos@mos

sickrage doesn't load , sqlite3.OperationalError: no such column: search_providers_newznab.key

after reboot sickrage wont load : 09:42:47 INFO::CORE::Performing disk space checks 09:42:47 INFO::CORE::Performing integrity check on main database 09:42:51 INFO::CORE::Performing upgrades on main database 09:42:51 INFO::CORE::Performing cleanup on main database 09:42:52 INFO::CORE::Performing vacuum on main database 09:42:53 INFO::CORE::Performing integrity check on config database 09:42:53 INFO::CORE::Performing upgrades on config database 09:42:53 INFO::CORE::Performing cleanup on config database 09:42:53 INFO::CORE::Performing vacuum on config database 09:42:53 INFO::CORE::Performing integrity check on cache database 09:42:53 INFO::CORE::Performing upgrades on cache database 09:42:53 INFO::CORE::Performing cleanup on cache database 09:42:53 INFO::CORE::Performing vacuum on cache database Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: search_providers_newznab.key

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sickrage/init.py", line 402, in main app.start() File "/usr/local/lib/python3.9/site-packages/sickrage/core/init.py", line 319, in start self.config.load() File "/usr/local/lib/python3.9/site-packages/sickrage/core/config/init.py", line 403, in load for search_providers in self.db.session().query(self.db.SearchProvidersTorrentRss, self.db.SearchProvidersNewznab): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3503, in iter return self._execute_and_instances(context) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3528, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1014, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1127, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context self.handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1511, in handle_dbapi_exception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 178, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: search_providers_newznab.key [SQL: SELECT search_providers_torrent_rss.id AS search_providers_torrent_rss_id, search_providers_torrent_rss.provider_id AS search_providers_torrent_rss_provider_id, search_providers_torrent_rss.sort_order AS search_providers_torrent_rss_sort_order, search_providers_torrent_rss.search_mode AS search_providers_torrent_rss_search_mode, search_providers_torrent_rss.search_separator AS search_providers_torrent_rss_search_separator, search_providers_torrent_rss.cookies AS search_providers_torrent_rss_cookies, search_providers_torrent_rss.proper_strings AS search_providers_torrent_rss_proper_strings, search_providers_torrent_rss.private AS search_providers_torrent_rss_private, search_providers_torrent_rss.supports_backlog AS search_providers_torrent_rss_supports_backlog, search_providers_torrent_rss.supports_absolute_numbering AS search_providers_torrent_rss_supports_absolute_numbering, search_providers_torrent_rss.anime_only AS search_providers_torrent_rss_anime_only, search_providers_torrent_rss.search_fallback AS search_providers_torrent_rss_search_fallback, search_providers_torrent_rss.enable_daily AS search_providers_torrent_rss_enable_daily, search_providers_torrent_rss.enable_backlog AS search_providers_torrent_rss_enable_backlog, search_providers_torrent_rss.enable_cookies AS search_providers_torrent_rss_enable_cookies, search_providers_torrent_rss.custom_settings AS search_providers_torrent_rss_custom_settings, search_providers_torrent_rss.enable AS search_providers_torrent_rss_enable, search_providers_torrent_rss.provider_type AS search_providers_torrent_rss_provider_type, search_providers_torrent_rss.name AS search_providers_torrent_rss_name, search_providers_torrent_rss.url AS search_providers_torrent_rss_url, search_providers_torrent_rss.title_tag AS search_providers_torrent_rss_title_tag, search_providers_torrent_rss.ratio AS search_providers_torrent_rss_ratio, search_providers_newznab.id AS search_providers_newznab_id, search_providers_newznab.provider_id AS search_providers_newznab_provider_id, search_providers_newznab.sort_order AS search_providers_newznab_sort_order, search_providers_newznab.search_mode AS search_providers_newznab_search_mode, search_providers_newznab.search_separator AS search_providers_newznab_search_separator, search_providers_newznab.cookies AS search_providers_newznab_cookies, search_providers_newznab.proper_strings AS search_providers_newznab_proper_strings, search_providers_newznab.private AS search_providers_newznab_private, search_providers_newznab.supports_backlog AS search_providers_newznab_supports_backlog, search_providers_newznab.supports_absolute_numbering AS search_providers_newznab_supports_absolute_numbering, search_providers_newznab.anime_only AS search_providers_newznab_anime_only, search_providers_newznab.search_fallback AS search_providers_newznab_search_fallback, search_providers_newznab.enable_daily AS search_providers_newznab_enable_daily, search_providers_newznab.enable_backlog AS search_providers_newznab_enable_backlog, search_providers_newznab.enable_cookies AS search_providers_newznab_enable_cookies, search_providers_newznab.custom_settings AS search_providers_newznab_custom_settings, search_providers_newznab.enable AS search_providers_newznab_enable, search_providers_newznab.provider_type AS search_providers_newznab_provider_type, search_providers_newznab.name AS search_providers_newznab_name, search_providers_newznab.url AS search_providers_newznab_url, search_providers_newznab."key" AS search_providers_newznab_key, search_providers_newznab.cat_ids AS search_providers_newznab_cat_ids, search_providers_newznab.api_key AS search_providers_newznab_api_key, search_providers_newznab.username AS search_providers_newznab_username FROM search_providers_torrent_rss, search_providers_newznab] (Background on this error at: http://sqlalche.me/e/13/e3q8) Sentry is attempting to send 0 pending error messages Waiting up to 2 seconds

Assignee
Assign to
Time tracking