[mythtv-users] Tilde Character in Show Title

[James Kaufman]

On Fri, Aug 17, 2007 at 07:25:13AM +0100, Robert Longbottom wrote:
> 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.
> 
> 

I DID run mythrename.pl. If it happens again, I'll check the database before I
change anything.

-- 
Jim Kaufman
Linux Evangelist
public key 0x6D802619
CCNA, CISSP# 65668