Skip to content

Parentheses are not escaped properly in SQL query when searching for lists #1471

@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