<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 26/03/17 12:18, Daryl McDonald
wrote:<br>
</div>
<blockquote
cite="mid:CAMwtTBBxQ_nOw3NTnByY=uODOF_z1M_3TxC4GRBto+WK25-b3A@mail.gmail.com"
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
moz-do-not-send="true"
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="gmail-HOEnZb">
<div class="gmail-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 moz-do-not-send="true"
href="http://optimize_mythdb.pl">optimize_mythdb.pl</a>":</div>
<div>
<div>DBD::mysql::db do failed: Invalid default value for
'starttime' at /usr/local/bin/<a moz-do-not-send="true"
href="http://optimize_mythdb.pl">optimize_mythdb.pl</a>
line 38.</div>
<div>DBD::mysql::db do failed: Invalid default value for
'starttime' at /usr/local/bin/<a moz-do-not-send="true"
href="http://optimize_mythdb.pl">optimize_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>
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").<br>
<br>
Mike<br>
</body>
</html>