<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Mon, Sep 14, 2015 at 3:49 PM, Hika van den Hoven <span dir="ltr"><<a href="mailto:hikavdh@gmail.com" target="_blank">hikavdh@gmail.com</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">Hoi Paul,<br>
<br>
Tuesday, September 15, 2015, 12:24:22 AM, you wrote:<br>
<br>
<br>
>> On Sep 14, 2015, at 2:28 PM, Roger Siddons <<a href="mailto:dizygotheca@ntlworld.com">dizygotheca@ntlworld.com</a>> wrote:<br>
>><br>
>> On Mon, 14 Sep 2015 22:14:46 +0100, Paul Stillwell <<a href="mailto:bigboi@wackywombats.com">bigboi@wackywombats.com</a> <mailto:<a href="mailto:bigboi@wackywombats.com">bigboi@wackywombats.com</a>>> wrote:<br>
>><br>
>> ><br>
>> > I don’t believe it a browser cache issue. I cleared the cache and<br>
>> > reloaded the page and still see all the recordings. I even tried loading<br>
>> > the page on a completely different machine that has never gone to that<br>
>> > page before and still see all the programs like they are there.<br>
>> ><br>
>><br>
>> The previews disappearing does suggest the recordings don't exist. Can you still play them ? Do the files still exist on disk ?<br>
>><br>
>> The front end reads directly from the database, and so is reliable. MythWeb requests it from the backend but, with browser caching, it's difficult to trust it.<br>
>><br>
>> I didn't see anything unusual in your logs.<br>
>><br>
>> The definitive answer will be shown by:<br>
>><br>
>> mysql> SELECT starttime,title,season,episode,filesize,deletepending,storagegroup FROM recorded;<br>
>><br>
>> If your recordings don't show up then they've been cleaned up and can't be re-inserted. into the database.<br>
>><br>
>> You can always put whatever files you have retrieved into the Video library and try to identify which is which.<br>
>> This may help with that:<br>
>><br>
>> mysql> SELECT chanid,starttime,title,subtitle,season,episode FROM oldrecorded;<br>
>><br>
>> _______________________________________________<br>
>> mythtv-users mailing list<br>
>> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a> <mailto:<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>><br>
>> <a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a> <<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>><br>
>> <a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a> <<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a>><br>
>> MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a> <<a href="https://forum.mythtv.org/" rel="noreferrer" target="_blank">https://forum.mythtv.org/</a>><br>
> Roger,<br>
<br>
> I ran the command and here are the first 3 recordings (from a long list of recordings) that show up:<br>
<br>
> MariaDB [mythconverg]> SELECT<br>
> starttime,title,season,episode,filesize,deletepending,storagegroup FROM recorded;<br>
> +---------------------+-------------------------------------+--------+---------+-------------+---------------+--------------+<br>
> | starttime | title |<br>
> season | episode | filesize | deletepending | storagegroup |<br>
> +---------------------+-------------------------------------+--------+---------+-------------+---------------+--------------+<br>
> | 2015-03-23 04:00:00 | The Last Man on Earth |<br>
> 0 | 0 | 7428612824 | 1 | Default |<br>
> | 2015-07-04 03:30:00 | Whose Line Is It Anyway? |<br>
> 11 | 9 | 3167717280 | 1 | Default |<br>
> | 2015-07-31 02:00:00 | Beat Bobby Flay |<br>
> 5 | 9 | 2379217644 | 1 | Default |<br>
<br>
> As you can see from the dates they were all recorded before 9/11<br>
> when I messed something up. I’m unclear what ‘deletepending’ means<br>
> though. I am suspecting that it is the problem because recordings<br>
> made after I messed things up have ‘deletepending’ set to 0 (and all<br>
> the recordings that were made after I messed things up are showing<br>
> up fine in the front end). Maybe there is some other fields that are<br>
> messed up also? Is there some way to set ‘deletepending’ to 0 and<br>
> see if everything shows up again or should I check some other fields too?<br>
<br>
> Paul<br>
<br></blockquote><div>Well, there's hope. The database still seems to know about them. Now try this to show the recording group:<br>mysql> SELECT starttime,title,season,episode,filesize,deletepending,recgroup FROM recorded WHERE deletepending=1 LIMIT 10;<br><br></div><div>(the LIMIT 10 is optional but just gives you a way to get a sense of what's there without filling your terminal).<br><br></div><div>Karl<br></div></div></div></div>