SOLVED: Cannot clear activity log entries from 2030

[SirBarbara]

Basically as the title says. My activity log has 144 entries from 2030 at the top. If i want to see anything current i have to go past a few pages, its not something i need to do almost ever, its just annoying to see. Its been there for years too, i try messing with it once in a while when i go in. So I want to clear the activity log to start over. I couldnt find settings for this in the dashboard so i went looking around in the server files. I am running a windows server and was able to find an entry in a system xml file for activity log retention days, set to 30 by default, i set it to 0 and restarted the server. Everything was still there. I ran the clean activity log task in maintenance and it cleared everything except entries from 2030. Is it stored somewhere where i can just delete the log because i cant find it

[Efficient_Good_5784]

They're not getting deleted because they are not yet older than the date the "clean activity log" ran on. Most likely, they'll get deleted once (from the screenshot) April 4, 2030 comes and passes.

Did you mess up a time zone variable when running Jellyfin? I don't see how else your server logged that activity date.

[theguymadmax]

1. Download and install https://sqlitebrowser.org/
2. Shutdown the server
3. Open up /Jellyfin/data/jellyfin.db (backup first!)
4. Choose the “Browse Data” tab, right under that is the option to choose table type, select “ActivityLogs”
5. Select the records you want to get rid of. Right-click on the number and select delete record.
6. Click the “Write Changes” button, then close the database and restart the server.

[SirBarbara]

They're not getting deleted because they are not yet older than the date the "clean activity log" ran on. Most likely, they'll get deleted once (from the screenshot) April 4, 2030 comes and passes.

Did you mess up a time zone variable when running Jellyfin? I don't see how else your server logged that activity date.

I figured it had something to do with the system date and time but couldn't find anything wrong when i first noticed. It may have been wrong when i first installed jellyfin, it was a clean install of windows so it could have been before the time got updated. 

1. Download and install https://sqlitebrowser.org/
2. Shutdown the server
3. Open up /Jellyfin/data/jellyfin.db (backup first!)
4. Choose the “Browse Data” tab, right under that is the option to choose table type, select “ActivityLogs”
5. Select the records you want to get rid of. Right-click on the number and select delete record.
6. Click the “Write Changes” button, then close the database and restart the server.

Thank you, this cleared it.