search

learnscripture / learnscripture.net

Source code for https://learnscripture.net
Other
5 stars 2 forks source link

Crasher for some search queries #183

Closed spookylukey closed 1 year ago

spookylukey commented 3 years ago

See https://sentry.io/organizations/learnscripturenet/issues/2091913862/?project=6894

Query:

          SELECT id, version_id, localized_reference, text_saved,
                 ts_headline(text_saved, query, 'StartSel = **, StopSel = **, HighlightAll=TRUE') as highlighted_text,
                 book_number, chapter_number, first_verse_number, last_verse_number,
                 bible_verse_number, gapless_bible_verse_number, ts_rank(text_tsv, query) as rank
          FROM bibleverses_verse, to_tsquery(%s, %s || %s || %s || %s || %s) query
          WHERE
             query @@ text_tsv

Exception:

    SyntaxError: no operand in tsquery: "joshua & 1 & ("