<div class="gmail_quote">On Sun, May 1, 2011 at 9:15 PM, Nick Rout <span dir="ltr"><<a href="mailto:nick.rout@gmail.com">nick.rout@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Tue, Apr 26, 2011 at 12:05 AM, Ryan Patterson <<a href="mailto:ryan.goat@gmail.com">ryan.goat@gmail.com</a>> wrote:<br>
> On Sat, Apr 23, 2011 at 7:20 AM, Tom Flair <<a href="mailto:lists@graniteskies.net">lists@graniteskies.net</a>> wrote:<br>
>> As above. I have several movies (and TV episodes) that are have the "Next<br>
>> File" field populated, sometimes in error. This gets a little annoying if<br>
>> one expects a movie to just end but suddenly the next movie (or episode)<br>
>> starts playing.<br>
>><br>
>> . . .<br>
>><br>
>> Also, is there an option that I have overlooked so this field isn't<br>
>> automatically populated again in a future scan?<br>
><br>
> Agreed. Auto populating this field is a horrible "feature". I'm sure<br>
> the functionality was added with good intentions. But it is hugely<br>
> annoying to have Rambo 3 start playing after I stop watching Rambo 2.<br>
><br>
> To compound the above, the user interface for setting/disabling the<br>
> "next file" requires the user to scroll through the entire list of<br>
> video files currently indexed by mythvideo. If you have multiple<br>
> seasons of long running TV shows in mythvideo, this list of files can<br>
> be quite long (mine is >9000 files).<br>
<br>
</div>I believe the field is videometadata.childid. If set to -1 there is no<br>
next file, if set to an integer the next file is the one pointed to by<br>
that integer.<br>
<br>
Should be easy to fix within mysql.<br>
<div><div></div><div class="h5">_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>I'm not an expert at mysql. I know enough to run daily backups and perform checks, but that's about it.<br><br>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.<br>