Skip to content

PostgreSQL issue with API to fetch entries #1412

@tcitworld

Description

@tcitworld

I'm trying to set up FeedReader with FreshRSS, the connexion and the feeds are properly fetched but the entries fail to be fetched.

The postgresql (yes) logs show up this :

2017-01-22 15:52:38 UTC [31138-1] freshrss@freshrss ERROR:  argument of WHERE must be type boolean, not type integer at character 191
2017-01-22 15:52:38 UTC [31138-2] freshrss@freshrss STATEMENT:  SELECT e0.id, e0.guid, e0.title, e0.author, content, e0.link, e0.date, e0.is_read, e0.is_favorite, e0.id_feed, e0.tags FROM "tcit_entry" e0 INNER JOIN (SELECT e.id FROM "tcit_entry" e WHERE 1  ORDER BY e.id DESC LIMIT 400) e2 ON e2.id=e0.id ORDER BY e0.id DESC

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions