Search error: failed to fetch count: pq: syntax error at or near "AGAINST" (500)

[ginuerzh]

Version: ghcr.io/go-shiori/shiori:v1.5.3-6-g3deeda7 postgres:14.5-alpine3.16

log:

time="2022-08-17T05:14:11Z" level=warning msg="GET /api/bookmarks?keyword=ndt&tags=&exclude=&page=1" proto=HTTP/1.1 remote="10.42.1.25:45580" reqlen=0 size=61 status=500

2022-08-17 05:14:11.273 UTC [7045] ERROR:  syntax error at or near "AGAINST" at character 101
2022-08-17 05:14:11.273 UTC [7045] STATEMENT:  SELECT COUNT(id) FROM bookmark WHERE TRUE AND (
				url LIKE $1 OR
				MATCH(title, excerpt, content) AGAINST ($2 IN BOOLEAN MODE)
			)

[stale[bot]]

This issue has been automatically marked as stale because it has not had any activity for quite some time. It will be closed if no further activity occurs. Thank you for your contributions.

[javierfuentesm]

I have the same issue @ginuerzh did you find a way to fix it ?

[Polarolouis]

Same issue here

Postgres docker logs :

shiori-postgres  | 2022-09-21 12:14:51.752 CEST [528] STATEMENT:  SELECT COUNT(id) FROM bookmark WHERE TRUE AND (
shiori-postgres  |                              url LIKE $1 OR
shiori-postgres  |                              MATCH(title, excerpt, content) AGAINST ($2 IN BOOLEAN MODE)
shiori-postgres  |                      )