Actually what you're seeing is the title being repeated. MythTV does this when it doesn't have a subtitle (blast Cartoon Network!
), the episode ID is in the DB as programid and you can copy that across to the subtitle if you want with a simple mysql update command. As you can see below the last two-three digits are where the unique part is:
Code:
root@black2:/etc/X11# mysql mythconverg -e "select programid, subtitle from recorded where title = 'Bleach' order by programid"
+----------------+-----------------------------------------------------------+
| programid | subtitle |
+----------------+-----------------------------------------------------------+
| EP008588670001 | 1. A Shinigami is Born! |
| EP008588670002 | 2. Pay or Play |
| EP008588670003 | 3. Sibling Rivalry |
| EP008588670004 | 4. And Your Bird Can Speak |
| EP008588670005 | 5. Beat the invisible enemy! |
| EP008588670006 | 6. Fight to the death! Ichigo vs. Ichigo |
| EP008588670007 | 7. Greetings from a stuffed toy |
| EP008588670008 | 8. June 17, a memory of rain |
| EP008588670009 | 9. Unbeatable enemy |
| EP008588670010 | 10. Assault on trip at sacred ground! |
| EP008588670011 | 11. The legendary Quincy |
| EP008588670012 | 12. A gentle right arm |
| EP008588670013 | 13. Flower and Hollow |
| EP008588670014 | 14. Back to back, a fight to the death! |
| EP008588670015 | 15. Kon's great plan |
| EP008588670016 | 16. Encounter: Abarai Renji! |
| EP008588670017 | 17. Ichigo dies! |
| EP008588670018 | 18. Reclaim! The Power of the Shinigami |
| EP008588670019 | 19. Ichigo becomes a Hollow! |
| EP008588670020 | 20. Ichimaru the Silver Shadow |
| EP008588670021 | 21. Enter! The World of the Shinigami |
| EP008588670022 | 22. The Man Who Hates Shinigamis |
| EP008588670023 | 23. The Sentence of Rukia, Before the 14th Day |
| EP008588670024 | 24. Assemble! The 13 Divisions |
| EP008588670025 | 25. Penetrate the centre with an enormous bombshell? |
| EP008588670026 | 26. Formation! The Worst Tag |
| EP008588670027 | 27. Release the death blow! |
| EP008588670028 | 28. Orihime is Being Targeted |
| EP008588670029 | 29. Breakthrough! The Death Gods' Encompassing Net |
| EP008588670030 | 30. Renji's Confrontation |
| EP008588670031 | 31. The Resolution to Kill |
| EP008588670032 | 32. Stars and the Stray |
| EP008588670033 | 33. Miracle! The mysterious new hero |
| EP008588670034 | 34. Tragedy of Dawn |
| EP008588670035 | 35. Assassination of Aizen! The darkness which approaches |
| EP008588670036 | 36. Kenpachi Zaraki Approaches! |
| EP008588670037 | 37. Reason of the Fist |
| EP008588670038 | 38. Desperation! The Broken Zangetsu |
| EP008588670039 | 39. The Man of Immortality |
| EP008588670040 | 40. The Shinigami whom Ganju Met |
| EP008588670041 | 41. Reunion, Ichigo and Rukia |
| EP008588670042 | 42. Yoruichi, the God of Flash, dances! |
| EP008588670043 | 43. The Despicable Shinigami |
| EP008588670044 | 44. Ishida, Power of Limits! |
| EP008588670045 | 45. Overcome the Limits! |
| EP008588670046 | 46. Authentic Records! School of Shinigami |
+----------------+-----------------------------------------------------------+
The update statement would look like something like this:
Code:
mysql -u root mythconverg <<EOF
update recorded set subtitle = programid
where title = 'Bleach'
and ( subtitle is null or subtitle = '' );
commit;
EOF
Of course ideally you could chop off the last two characters of the programid and paste that up against something like "Episode ", but that's just getting fancy.
View unanswered posts
View active topics
KnoppMyth 
Print view
Previous topic Next topic 
LinHES Home
Board index
FAQ
Search
Login 
Register
