[mythtv-users] Is it possible to clear the "Next File" field in MythVideo for all videos?

[Tom Flair]

On Sun, May 1, 2011 at 9:15 PM, Nick Rout <nick.rout at gmail.com> wrote:

> On Tue, Apr 26, 2011 at 12:05 AM, Ryan Patterson <ryan.goat at gmail.com>
> wrote:
> > On Sat, Apr 23, 2011 at 7:20 AM, Tom Flair <lists at graniteskies.net>
> wrote:
> >> As above.  I have several movies (and TV episodes) that are have the
> "Next
> >> File" field populated, sometimes in error.  This gets a little annoying
> if
> >> one expects a movie to just end but suddenly the next movie (or episode)
> >> starts playing.
> >>
> >> . . .
> >>
> >> Also, is there an option that I have overlooked so this field isn't
> >> automatically populated again in a future scan?
> >
> > Agreed.  Auto populating this field is a horrible "feature".  I'm sure
> > the functionality was added with good intentions.  But it is hugely
> > annoying to have Rambo 3 start playing after I stop watching Rambo 2.
> >
> > To compound the above, the user interface for setting/disabling the
> > "next file" requires the user to scroll through the entire list of
> > video files currently indexed by mythvideo.  If you have multiple
> > seasons of long running TV shows in mythvideo, this list of files can
> > be quite long (mine is >9000 files).
>
> I believe the field is videometadata.childid. If set to -1 there is no
> next file, if set to an integer the next file is the one pointed to by
> that integer.
>
> Should be easy to fix within mysql.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>

I'm not an expert at mysql.    I know enough to run daily backups and
perform checks, but that's about it.

I've just now found the field you've referenced using phpmyadmin.   How do I
go about changing this field to -1 as a mass effort?  I'd rather not have to
go through each one and change it manually.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110527/afd9aacb/attachment.html