[mythtv-users] No recordings

[Mike Bibbings]

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 <mailto: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 <http://optimize_mythdb.pl>":
> DBD::mysql::db do failed: Invalid default value for 'starttime' at 
> /usr/local/bin/optimize_mythdb.pl <http://optimize_mythdb.pl> line 38.
> DBD::mysql::db do failed: Invalid default value for 'starttime' at 
> /usr/local/bin/optimize_mythdb.pl <http://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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170326/7cc4f4f2/attachment.html>