<div dir="auto"><br><div class="gmail_extra" dir="auto"><br><div class="gmail_quote">On Mar 26, 2017 7:57 AM, "Mike Bibbings" <<a href="mailto:mike.bibbings@gmail.com">mike.bibbings@gmail.com</a>> wrote:<br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><div class="elided-text">
<div class="m_-1539853961366355060moz-cite-prefix">On 26/03/17 12:18, Daryl McDonald
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sun, Mar 26, 2017 at 1:12 AM,
Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="m_-1539853961366355060gmail-HOEnZb">
<div class="m_-1539853961366355060gmail-h5">On Sat, 25 Mar 2017 23:41:01
-0400, you wrote:<br>
<br>
>Earlier this evening I mistkenly deleted a movie,
so I went to deleted<br>
>recordings and undeleted it and when I went to
esc from there mythtv froze<br>
>up with thin images of two different screens.
Being on my way out I<br>
>switched inputs so the family could watch live TV,
and I would wait<br>
>patiently for Myth, three hours later it's still
frozen so I did the ctl +<br>
>alt + screen shot + R E I S U B 9 (individually)
and then the box rebooted,<br>
>but now Myth sees videos but no recordings, I can
see that they are still<br>
>on my drives, do I need to use a database backup
so Myth can find these<br>
>again? or is there a better idea? I'm using Myth
0.28 fixes on n Ubuntu<br>
>16.04 combined FE/BE desktop. TIA Daryl<br>
<br>
</div>
</div>
Run optimize_mythdb - you probably have some crashed
database tables<br>
that need to be repaired.<br>
______________________________<wbr>_____<br>
</blockquote>
<div><br>
</div>
<div>Thanks for the suggestion, here are the last three line
from running "<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a>":</div>
<div>
<div>DBD::mysql::db do failed: Invalid default value for
'starttime' at /usr/local/bin/<a href="http://optimize_mythdb.pl" target="_blank">optimize_<wbr>mythdb.pl</a>
line 38.</div>
<div>DBD::mysql::db do failed: Invalid default value for
'starttime' at /usr/local/bin/<a href="http://optimize_mythdb.pl" target="_blank">optimize_<wbr>mythdb.pl</a>
line 42.</div>
<div>Defragmented: filemarkup</div>
</div>
<div><br>
</div>
<div>Is there further action I should take? Still no
recordings show, although it does show "78% used and
387.52 GB free" </div>
</div>
<br>
</div>
</div>
<br>
</blockquote></div>
As you are seeing something in the Recordings screen "78%
used.......".<br>
<br>
It might be worth checking in the Recording screen the "Change Group
Filter" and "Change Group View settings". These are accessed via the
Menu key (default key "m").<font color="#888888"><br>
<br>
Mike<br>
</font></div>
<br>______________________________<wbr>_______________<br></blockquote></div></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Not only worth checking into, but exactly right, but do I ever feel stupid now. Thanks Mike, all is well again.</div><div class="gmail_extra" dir="auto"><div class="gmail_quote"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"></blockquote></div></div></div>