Songs showing up as played - in the FUTURE?

[andygradel]

Has anyone else run into this problem?

There’s a group of songs, which aren’t on my server anymore, showing as having been played years in the future?

Would love to delete them from the log, but not sure where I can do that. Any suggestions?

More of an annoyance than anything else. I know I can just wait until 2031 and they’ll fall off the list, but… hah… thanks!

[OttoKerner]

Possible causes could be

• a wrong date set on the mobile device to where these may have been downloaded and played offline.
• a wrong date set on the server during the time when these were played

This history is only on your server. Except from editing the primary Plex database file directly, there is no way to correct or delete these log entries.

[anon5074910]

@OttoKerner

there is no way to correct or delete these log entries.

There is a little known feature of dash which allows you to delete dashboard entries but they have to be one by one.

Just swipe left on the entry you want to delete/remove.

[andygradel]

Thanks for pointing that out. Great suggestion, but odd bug with these tracks as they’re not swipeable. Odd… very odd…

[anon5074910]

That’s odd indeed. Any database corruption ? Search for database disk image is malformed in your logs.

If your db is okay and not corrupt then how open would you be to run a couple of sql commands on your db ? Something like this SHOULD do the trick …

This command will select any records which have a viewed_at date great than “1 January 2025 01:01:01”. This should match the list you included in the screenshot above and can be used to validate before you actually remove them.
SELECT * FROM metadata_item_views WHERE viewed_at > 1735693261;

This command will then delete them.
DELETE FROM metadata_item_views WHERE viewed_at > 1735693261;

Save your changes and you should be good.

NOTE OF CAUTION: If your not familiar with sql then maybe stay clear but if you have a backup of your db then even if it goes wrong you can restore.