Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[APP SUBMITTED]: sqlite3.OperationalError: no such column: "||" - should this be a string literal in single-quotes? #11817

Open
DoogyR3V opened this issue Sep 4, 2024 · 0 comments

Comments

@DoogyR3V
Copy link

DoogyR3V commented Sep 4, 2024

INFO

Python Version: 3.11.9 (main, Aug 8 2024, 01:20:36) [Clang 17.0.6 (https://github.com/llvm/llvm-project.git llvmorg-17.0.6-0-g600970
Operating System: FreeBSD-13.3-RELEASE-p4-amd64-64bit-ELF
Locale: UTF-8
Branch: master
Database: 44.19
Commit: 34a67cf
Link to Log: https://gist.github.com/DoogyR3V/b42726b4f933a25e0b1631362cbf39b8

ERROR

2024-09-04 21:30:49 ERROR    SEARCHQUEUE-DAILY-SEARCH :: [] :: [34a67cf] DailySearchQueueItem Exception, error: OperationalError('no such column: "||" - should this be a string literal in single-quotes?')
Traceback (most recent call last):
  File "/usr/local/medusa/medusa/search/queue.py", line 295, in run
    found_results = search_for_needed_episodes(self.scheduler_start_time, force=self.force)
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/medusa/medusa/search/core.py", line 550, in search_for_needed_episodes
    found_results = cur_provider.cache.find_needed_episodes(episodes)
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/medusa/medusa/tv/cache.py", line 500, in find_needed_episodes
    cache_results = self.find_episodes(episodes)
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/medusa/medusa/tv/cache.py", line 594, in find_episodes
    sql_results = cache_db_con.mass_action(results, fetchall=True)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/medusa/medusa/db.py", line 222, in mass_action
    sql_results.append(self._execute(qu[0], qu[1], fetchall=fetchall))
                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/medusa/medusa/db.py", line 115, in _execute
    sql_results = cursor.execute(query, args)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: no such column: "||" - should this be a string literal in single-quotes?

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

@DoogyR3V DoogyR3V reopened this Sep 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant