-
-
Notifications
You must be signed in to change notification settings - Fork 1.1k
[Postgres] Optimise database issue #1360
Copy link
Copy link
Closed
Milestone
Description
Hi,
When I click on "Optimise database" I have this error in Postgres logs :
2016-11-06 11:04:02 CET [2784]: [6-1] user=freshrss,db=freshrss,client=[local],application=[unknown],state=42601 ERROR: syntax error at or near "INNER" at character 33
2016-11-06 11:04:02 CET [2784]: [7-1] user=freshrss,db=freshrss,client=[local],application=[unknown],state=42601 STATEMENT: UPDATE "freshrss_adrien_feed" f INNER JOIN (SELECT e.id_feed, COUNT(CASE WHEN e.is_read = 0 THEN 1 END) AS nbUnr
eads, COUNT(e.id) AS nbEntries FROM "freshrss_adrien_entry" e GROUP BY e.id_feed) x ON x.id_feed=f.id SET f."cache_nbEntries"=x.nbEntries, f."cache_nbUnreads"=x.nbUnreads
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels