[GH-ISSUE #470] Search error: failed to fetch count: pq: syntax error at or near "AGAINST" (500) #288

New issue

Closed

opened 2026-02-25 23:33:52 +03:00 by kerem · 3 comments

kerem commented

2026-02-25 23:33:52 +03:00

Owner

Originally created by @ginuerzh on GitHub (Aug 17, 2022).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/470

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)
			)

Originally created by @ginuerzh on GitHub (Aug 17, 2022). Original GitHub issue: https://github.com/go-shiori/shiori/issues/470 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) ) ```

kerem

2026-02-25 23:33:52 +03:00

closed this issue
added the
type:bug

component:backend

database:postgres
labels

kerem commented

2026-02-25 23:33:52 +03:00

Author

Owner

@stale[bot] commented on GitHub (Sep 16, 2022):

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.

@stale[bot] commented on GitHub (Sep 16, 2022): 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.

kerem commented

2026-02-25 23:33:52 +03:00

Author

Owner

@javierfuentesm commented on GitHub (Sep 19, 2022):

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

@javierfuentesm commented on GitHub (Sep 19, 2022): I have the same issue @ginuerzh did you find a way to fix it ?

kerem commented

2026-02-25 23:33:53 +03:00

Author

Owner

@Polarolouis commented on GitHub (Sep 21, 2022):

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  |                      )

@Polarolouis commented on GitHub (Sep 21, 2022): 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 | ) ```