[mythtv-users] Images missing on Videos

[James]

> On 27 Apr 2022, at 12:45 am, Roland Ernst <rcrernst at gmail.com> wrote:
> 
> 
> 
> On Tue, Apr 26, 2022 at 4:58 PM Ken Mandelberg <km at mathcs.emory.edu <mailto:km at mathcs.emory.edu>> wrote:
> My Video Gallery used to have images displayed for almost all of the 
> videos. After a recent scan for changes, almost all of the images 
> disappeared, with just the "?" image. The videos still play fine.
> 
> Any ideas on what I should look for? I'm running the most recent trunk 
> build.
> 
>  
> Please check the mythtv logs for errors and abnormalities.
> 
> How did you setup mythvideo, with storage-groups on the backend or
> via the frontend in 'Setup' -> 'Media-Settings' -> Video Settings' ? 
> 
> Did you scan for changes by using 'mythutil'? If yes, post the 
> command line you used.
> 
> Otherwise, if you run in the video gallery 'M' -> 'Scan for changes',
> there should be some log entries.
> 
> Is a mysql table corrupted?

A quick check (you do make a daily backup dont you?) is to restore a day when all was good, then spelunk as above, then try scan again.

If you have made recordings or rules since the loss then take the backup that still works use vim (nano won't work on a large dump) strip out all but non empty 'video_*' tables, restore those and voila.

Many (most) modern DB install, if you have not explicitly fiddled

$ sudo mysql mythconverg < videofix.sql
or
# mysql mythconverg < videofix.sql

James

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220427/fc330619/attachment.htm>