Skip to content

[Postgres] Optimise database issue #1360

@anayrat

Description

@anayrat

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions