<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>