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<br>
<br><br>jerry@DigitalDVR:~$ ./find_orphans.py <br>Recordings with missing files<br> DigitalDVR: Movies - 4221_20130118113000.mpg<br> Count: 1<br>
Database backups<br> DigitalDVR: /var/lib/mythtv/db_backups/mythconverg-1264-install.sql.gz 27.0KB<br> DigitalDVR: /var/lib/mythtv/db_backups/mythconverg-1299-20130203044709.sql.gz 102.6MB<br>
DigitalDVR: /var/lib/mythtv/db_backups/mythconverg-1299-20130210044709.sql.gz 103.0MB<br> DigitalDVR: /var/lib/mythtv/db_backups/mythconverg-1299-20130217044708.sql.gz 102.4MB<br> DigitalDVR: /var/lib/mythtv/db_backups/mythconverg-1299-20130224044709.sql.gz 105.0MB<br>
Total: 413.0MB<br>Please select from the following<br> 1. Delete orphaned recording entries<br> <br>