[Bug] Can't mark entry as read from API with 1.28.0 (regression) #8345
Description
Describe the bug
When I updated to 1.28.0 from 1.27.1, i couldn't mark entries as read on the API anymore.
The following was logged:
FreshRSS[36]: [gb] [Wed, 24 Dec 2025 15:18:14 -0500] [error] --- SQL error FreshRSS_EntryDAOSQLite::markRead A ["HY000",1,"no such column: lastUserModified"]
FreshRSS[36]: [gb] [Wed, 24 Dec 2025 15:18:14 -0500] [error] --- SQL error FreshRSS_EntryDAOSQLite::markRead A ["HY000",1,"no such column: lastUserModified"]
FreshRSS[36]: [gb] [Wed, 24 Dec 2025 15:18:14 -0500] [error] --- SQL error FreshRSS_EntryDAOSQLite::markRead A ["HY000",1,"no such column: lastUserModified"]
192.168.156.44 - - [24/Dec/2025:15:18:14 -0500] "POST /api/greader.php/reader/api/0/edit-tag HTTP/1.1" 200 2 "-" "ReadKit/462 CFNetwork/3860.200.71 Darwin/25.1.0"
192.168.156.44 - - [24/Dec/2025:15:18:14 -0500] "GET /api/greader.php/reader/api/0/tag/list?output=json HTTP/1.1" 200 182 "-" "ReadKit/462 CFNetwork/3860.200.71 Darwin/25.1.0"
192.168.156.44 - - [24/Dec/2025:15:18:14 -0500] "GET /api/greader.php/reader/api/0/subscription/list?output=json HTTP/1.1" 200 1509 "-" "ReadKit/462 CFNetwork/3860.200.71 Darwin/25.1.0"
192.168.156.44 - - [24/Dec/2025:15:18:14 -0500] "GET /api/greader.php/reader/api/0/stream/items/ids?n=1000&output=json&s=user/-/state/com.google/reading-list&xt=user/-/state/com.google/read HTTP/1.1" 200 71 "-" "ReadKit/462 CFNetwork/3860.200.71 Darwin/25.1.0"
192.168.156.44 - - [24/Dec/2025:15:18:14 -0500] "GET /api/greader.php/reader/api/0/stream/items/ids?n=1000&output=json&s=user/-/state/com.google/starred HTTP/1.1" 200 16 "-" "ReadKit/462 CFNetwork/3860.200.71 Darwin/25.1.0"
192.168.156.44 - - [24/Dec/2025:15:18:14 -0500] "GET /api/greader.php/reader/api/0/stream/items/ids?n=500&ot=1766607438&output=json&s=user/-/state/com.google/read HTTP/1.1" 200 16 "-" "ReadKit/462 CFNetwork/3860.200.71 Darwin/25.1.0"
To Reproduce
- Use a RSS reader that uses the API, eg. ReadKit
- Read 1+ entries
- Trigger a refresh, so that read status is sent to FreshRSS
- See error above
Expected behavior
Reverting to 1.27.1 fixes this problem.
FreshRSS version
1.28.0
System information
- Installation type: Docker
- Client: ReadKit on Mac
Additional context
No response