[mythtv-users] 0.28 and MARK_UTIL_LASTPLAYPOS filemarkup entries

[Stephen Worthington]

On Thu, 3 Nov 2016 08:50:51 -0400, you wrote:

>For video playback I've always used strictly file browse mode with no
>video metadata etc. I rarely keep videos long term.
>
>Prior to 0.28 the only entries I ever got in the filemarkup table were
>type 2 (bookmarks) if/when I expressly bookmark a video. As if 0.28
>everything I play leaves an entry in filemarkup with a type 41, which
>from the code is apparently MARK_UTIL_LASTPLAYPOS. Is there some way
>to disable that? If I delete files manually those will just tend to
>build up in there unless I manually delete them.
>
>Thanks!
>Tom

It is not a particularly difficult job to write a script that does
cleanup on the filemarkup table by checking for any entries that do
not match an existing file and deleting them.  It is something I have
thought about doing as I use Videos in MythTV the same way you do.
What would have to be done is connect to the database, get the
VideoStartupDir setting from the settings table to find the video
directories, then go through all the rows in the filemarkup table and
check if filename field matches a file under any of the video
directories.  If not, delete that table row.  I already have Python
code to do parts of that job.  What I do not know is exactly what all
the uses of filemarkup table are and whether it would be a safe thing
to do that sort of cleanup.