Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • pleroma pleroma
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 655
    • Issues 655
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 99
    • Merge requests 99
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Artifacts
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • PleromaPleroma
  • pleromapleroma
  • Issues
  • #360
Closed
Open
Issue created Nov 03, 2018 by Ilja@iljaContributor

Notification 'Read!' doesn't set value true in "seen"-column in database

  1. Have a user with unread notifications and run (1). You'll notice column "seen"=false => Ok
  2. When click Read! the notifications are marked as read on the FE => Ok
  3. When closing and reopening the tab, the notifications are still marked as read on the FE => Ok
  4. However, when you run (1) again, you'll see it's still "seen"=false => Not Ok
  5. When you clear website data in the browser and you reload the page (or use private window or use another browser...), it's unread again => Not Ok

When I set the flags in the database to seen=true (you can run (2) for this) the notifications are shown as read even after clearing browserdata, so it seems that reading from the database works, just not storing to the database.

The reason why I noticed it is 'cause I've got my browser set to clear cookies and browserdata by default when closing my browser.

(1) Change <username> to relevant Username

select * from notifications
where user_id=(select id from users where "nickname"='<username>')
order by id desc

(2) Change <username> to relevant Username

-- set notifications to read
update notifications set seen=true
where user_id in (
select id from users
where local = true
and seen=false
and nickname in ('<username>'));
Assignee
Assign to
Time tracking