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

[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:

[FournyP]

Hi, I try to fetch lists with the API using this query : 'alerts' = ANY(lists.tags)
So I got a query like this : http://localhost:9000/api/lists?query=%27alerts%27%3DANY%28lists.tags%29

But it doesn't work because of this issue. I've added \ as you said to fix the problem and I get a 200 response but with empty data

The query is : http://localhost:9000/api/lists?query=%27alerts%27%3DANY%5C%28lists.tags%5C%29 and as you can see, I don't get the same result between the API and the database

Do you know why the API don't return the value ?

Have a good day