[mythtv-users] Tilde Character in Show Title

Joe Ripley vitaminjoe at gmail.com
Fri Aug 17 03:31:48 UTC 2007

On 8/16/07, James Kaufman <jmk at kaufman.eden-prairie.mn.us> wrote:
> I recorded the recent Eureka episode (on SF) and it had a tilde in the title. I
> could see the recorded mpg file on disk (with the tilde). When I went to view
> recordings, I could see the show listed. But, when I told Myth to play the
> show, I got an error message saying it couldn't find the file.
> I ended up renaming the file exactly the same, but without the tilde and then
> using myth.rebuilddatabase.pl to import the file.  That allowed me to watch the
> show.
> I am guessing it is a MySQL issue, rather than a Myth one, but what settings
> control this? How can I avoid this problem in the future?

I doubt that it's a MySQL issue... it might be an issue with Myth not
properly escaping the tilde character when it's inserting the data to
the database.  Did you check the database to see what the entry looked
like in the recorded table?

Also, doesn't Myth save it's mpeg files using the channel id and the
timestamp as a filename?  (i.e. 1035_20070816201050.mpg).

Joe Ripley
vitaminjoe at gmail.com

More information about the mythtv-users mailing list