My backend is postgresql and I would like to log in as the database user and run an update query so that all my starred articles also become unread. Is this information stored in the same table or in different tables?
Which table(s) should I check?
ttrss_user_entries is the table you’re looking for.
e: marked and unread are the columns you want.
e2: Editting the database directly is not expressly necessary though. Just view the starred feed, scroll down so all the articles load, select all, and toggle unread.