Recordings not showing on front-end, but showing elsewhere.

[dantengwen]

My wife was using myth and was doing a cleanup, namely adding a whole bunch of recordings to a playlist and deleting the recordings in the playlist. This is something both of us have done many many times without issue, until the other night.

The other night I'm not totally sure what happened, but at best guess she hit the "/" key while "All Programs" was selected instead of a specific show and chose delete.


Anyway I undeleted all 1500+ and then something glitched on the front end necessitating the front end program be restarted. Ever since then I cannot see more than 30 of the already-recorded programs, no matter how I change the view filters. What makes it even more unusual is I can locate and play them perfectly fine via mythweb and via mythling (an android frontend) on my tablet..

I have reinstalled the front end with "apt-get --purge mythfrontend" as well as reset the front-end settings via "mythfrontend --reset" while te front end program was shut down, but still I only see 30 of over 1500 shows. New programs are being recorded and showing up on all front ends and mythweb, but for some reason I just cannot get the frontend on the mythtv box to do it. I tried and couldn't get it to work on a secondary frontend either.

I've google-fu'd a fair bit, but every suggestion I've come up with doesn't seem to help here.

[MikeB2013]

Not sure which "view" filter you are changing.

If you go to "Watch Recordings" and then press the Menu key (m on a keyboard) you should see a "Group List Menu" , if you then select "Change Group Filter" does that show any lines resembling your "lost" recordings ? It is possible that they are in the Deleted section under -----Groups-----

Mike

[pgbennett]

There is a delete pending flag in the database, and if it remains set the recordings are in a limbo state. This can happen if the backend crashes while performing deletes. To check this. run a sql command
select deletepending, recgroup, count(*) from recorded group by deletepending, recgroup;
This will tell how many delete pending records there are. To fix it if there are some, shut down the backend and run this sql
UPDATE recorded SET deletepending = 0 where recgroup = 'Deleted';
In the recgroup use the recgroup where the deletepending records were found.

[AnalogBill]

Thanks. Worked great! I was on the wrong track and you saved me a lot of angst.
Bill