[mythtv-users] Trouble Deleting Orphaned Database Entry

[Michael T. Dean]

On 02/28/2013 09:35 AM, Junk Moody wrote:
> I'm having trouble deleting an orphaned entry from my database, I 
> suspect because the title ends in a dash or perhaps a blank.  The 
> subtitle is also blank.  I tried find_orphans.py and it detected the 
> missing recording file correctly, but isn't able to actually remove 
> the entry.  Suggestions?  Perhaps there are sql commands I can entire 
> directly to delete it or rename it to permit deletion.  I'm running 
> MythTV v0.25.3
>
>
> jerry at DigitalDVR:~$ ./find_orphans.py
> Recordings with missing files
>   DigitalDVR: Movies 
> -                                                       
> 4221_20130118113000.mpg
>                                                                                   
> Count:           1
> Database backups
>   DigitalDVR: 
> /var/lib/mythtv/db_backups/mythconverg-1264-install.sql.gz                      
> 27.0KB
>   DigitalDVR: 
> /var/lib/mythtv/db_backups/mythconverg-1299-20130203044709.sql.gz              
> 102.6MB
>   DigitalDVR: 
> /var/lib/mythtv/db_backups/mythconverg-1299-20130210044709.sql.gz              
> 103.0MB
>   DigitalDVR: 
> /var/lib/mythtv/db_backups/mythconverg-1299-20130217044708.sql.gz              
> 102.4MB
>   DigitalDVR: 
> /var/lib/mythtv/db_backups/mythconverg-1299-20130224044709.sql.gz              
> 105.0MB
>                                                                                   
> Total:     413.0MB
> Please select from the following
>  1. Delete orphaned recording entries

Did you wait a while after trying the delete to see if it disappeared?  
If you just re-run find_orphans.py right after a previous run, it may 
find the same issues--even though the backend is working on cleaning 
them up after the previous run's request.

Also, if you think the name is bad, did you go into Watch Recordings and 
find the recording and edit the metadata?  It's in the MENU under 
Recording Options.

Mike