[mythtv-users] Trouble Deleting Orphaned Database Entry

[Michael T. Dean]

On 03/04/2013 09:16 PM, Michael T. Dean wrote:
> 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.

Or, really, why not just try deleting it from mythfrontend Watch 
Recordings while you're there.

Mike