[mythtv-users] No recordings

[Daryl McDonald]

On Mar 26, 2017 7:57 AM, "Mike Bibbings" <mike.bibbings at gmail.com> wrote:

On 26/03/17 12:18, Daryl McDonald wrote:



On Sun, Mar 26, 2017 at 1:12 AM, Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:

> On Sat, 25 Mar 2017 23:41:01 -0400, you wrote:
>
> >Earlier this evening I mistkenly deleted a movie, so I went to deleted
> >recordings and undeleted it and when I went to esc  from there mythtv
> froze
> >up with thin images of two different screens. Being on my way out I
> >switched inputs so the family could watch live TV, and I would wait
> >patiently for Myth, three hours later it's still frozen so I did the ctl +
> >alt + screen shot + R E I S U B 9 (individually) and then the box
> rebooted,
> >but now Myth sees videos but no recordings, I can see that they are still
> >on my drives, do I need to use a database backup so Myth can find these
> >again? or is there a better idea? I'm using Myth 0.28  fixes on n Ubuntu
> >16.04 combined FE/BE desktop.  TIA  Daryl
>
> Run optimize_mythdb - you probably have some crashed database tables
> that need to be repaired.
> ___________________________________
>

Thanks for the suggestion, here are the last three line from running "
optimize_mythdb.pl":
DBD::mysql::db do failed: Invalid default value for 'starttime' at
/usr/local/bin/optimize_mythdb.pl line 38.
DBD::mysql::db do failed: Invalid default value for 'starttime' at
/usr/local/bin/optimize_mythdb.pl line 42.
Defragmented: filemarkup

Is there further action I should take? Still no recordings show, although
it does show "78% used and 387.52 GB free"


As you are seeing something in the Recordings screen "78% used.......".

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").

Mike

_____________________________________________



Not only worth checking into, but exactly right, but do I ever feel stupid
now. Thanks Mike, all is well again.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170326/9b225b22/attachment.html>