Thanks Wade.Ialways figured it was this easy but was too embarrassed to ask... this worked a treat. I now have just 9 days data :-( and a desire to learn a bit more about what else I can play with in mythconverg... <br><br>
- D<br><br><div class="gmail_quote">On Thu, May 29, 2008 at 10:45 AM, Wade Maxfield <<a href="mailto:mythtvnz@hotblack.co.nz">mythtvnz@hotblack.co.nz</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">David Lowe wrote:<br>
> MythTv Main Menu -> System Info or something like that tells you. Mine<br>
> always says I have data for the next 25 years (which is wrong), but it<br>
> also tells me whether the last run succeeded....<br>
><br>
<br>
</div>You've got some bad data in your program table. If you jump into mysql<br>
and delete any programs that are going to show next year or further out...<br>
<br>
At a command prompt (or use phpMyAdmin or whatever mysql tool you have<br>
access to)<br>
<br>
mysql -u [youruser] -h [yourhost] -p -e "DELETE FROM program WHERE<br>
starttime > '2009-01-01';" mythconverg<br>
<br>
then run<br>
<br>
mythbackend --resched<br>
<br>
That should sort out your 25 year issue.<br>
<font color="#888888"><br>
- Wade<br>
</font><div><div></div><div class="Wj3C7c"><br>
_______________________________________________<br>
mythtvnz mailing list<br>
<a href="mailto:mythtvnz@lists.linuxnut.co.nz">mythtvnz@lists.linuxnut.co.nz</a><br>
<a href="http://lists.ourshack.com/mailman/listinfo/mythtvnz" target="_blank">http://lists.ourshack.com/mailman/listinfo/mythtvnz</a><br>
Archives <a href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/" target="_blank">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/</a><br>
</div></div></blockquote></div><br>