[mythtv-users] No recordings
John Pilkington
J.Pilk at tesco.net
Sun Mar 26 12:14:14 UTC 2017
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
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
More information about the mythtv-users
mailing list