8000 Parentheses are not escaped properly in SQL query when searching for lists · Issue #1471 · knadh/listmonk · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
Parentheses are not escaped properly in SQL query when searching for lists #1471
Closed
@tosie

Description

@tosie

Version:

  • listmonk: v2.5.1
  • OS: Debian 6.1.27-1 (2023-05-08) x86_64

Description of the bug and steps to reproduce:
When searching for a list with a string that contains parentheses, an error is returned by "pq".

Searching for "My list (something)" shows this error message:

error fetching lists: pq: syntax error in tsquery: "%My&list&(something)%"

Escaping the parentheses manually ("My list \(something\)") works (see second screenshot).

Screenshots:
image

image

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0