[mythtv-users] No recordings

[Mark Perkins]

On 26 March 2017 10:44:37 PM John Pilkington <J.Pilk at tesco.net> 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 <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"
>>
>>
> The 'invalid default value' has been around for some time, and IIUC
> master has just been patched for it.  No idea about any further action,
> though.
>
> [mythtv-commits] mythtv branch master updated by dekarl.
> v29-pre-380-g83c67a0
>
> John P
>
Thanks John, I wasn't aware of that. So my assumption of corrupt database 
was wrong.