[mythtv-users] Tilde Character in Show Title

[Robert Longbottom]

On Fri, August 17, 2007 4:31 am, Joe Ripley wrote:
> 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).

Maybe he is running mythrename.pl - that script that renames files to the
showname - so it's probably a "bug" in that.  (Or just something that was
never thought of)  Why on earth would anyone put a ~ in a TV program
title!

My guess would be that the reason it couldn't find the file is that the ~
got expanded by the shell to the users homedir.

Robert.