[mythtv-users] Trouble Deleting Orphaned Database Entry
Michael T. Dean
mtdean at thirdcontact.com
Tue Mar 5 02:30:20 UTC 2013
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
More information about the mythtv-users
mailing list