If I go to the play history section I can see permanetly 3 play records in the future. How could I delete them?
Still happening same problem as this Date Added in the Future
I attached an image with the problem
Thank you
If I go to the play history section I can see permanetly 3 play records in the future. How could I delete them?
Still happening same problem as this Date Added in the Future
I attached an image with the problem
Thank you
Fixed. It is necesary to modify some rows of the tables metadata_item_settings, and metadata_item_views of the sql Database in Plex.
I attached some samples:
sqlite3 /volume1/Plex/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Datab
ases/com.plexapp.plugins.library.db
select id,guid,viewed_at from metadata_item_settings order by last_viewed_at desc;
6839|com.plexapp.agents.thetvdb://328724/3/16?lang=es|2034-03-12 14:27:45
6840|com.plexapp.agents.thetvdb://95011/11/14?lang=es|2034-03-27 16:32:59
6841|com.plexapp.agents.thetvdb://95011/11/14?lang=es|2034-03-27 15:51:59
update metadata_item_settings set last_viewed_at = DATETIME('now') where id in(6839,6840, 6841);
select id,guid,viewed_at from metadata_item_views where guid in(
select guid from metadata_item_settings where id in(6839,6840, 6841));
8901|com.plexapp.agents.thetvdb://279121/6/12?lang=es|2020-02-24 23:33:25
8898|com.plexapp.agents.thetvdb://328724/3/16?lang=es|2034-03-12 14:27:45
8899|com.plexapp.agents.thetvdb://95011/11/14?lang=es|2034-03-27 16:32:59
8900|com.plexapp.agents.thetvdb://95011/11/14?lang=es|2034-03-27 15:51:59
update metadata_item_views set viewed_at = DATETIME('now') where id in(8898,8899,8900);
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.