[mythtv] Database schema checker

ian dobson i.dobson at planet-ian.com
Tue Sep 2 17:38:43 UTC 2008


Hi Dan,

> Hi Ian,
>
> It seems your script has an escaping problem with single-quotes. I have 
> previously used mythrename.pl to include program/episode names in my 
> files, so I now have a couple of episodes of "Blue's Clues", for which 
> CheckMythDB causes a SQL error:
>
> DBD::mysql::st execute failed: You have an error in your SQL syntax; check 
> the manual that corresponds to your MySQL server version for the right 
> syntax to use near 's Clues - 2008-05-06, 12-59 AM - Adventure!.nuv' and 
> storagegroup = 'LiveTV'' at line 1 at CheckMythDB.txt line 460.

I thought that might happen some time. I plan to go through the SQL code 
sometime cleaning it up, but at the moment my paid job is really hitting me 
hard.

>
> Also, what does this message mean?:
>
>   File [filename] exits in the database but it's in storage group 
> 'Default'
>
> It's not clear to me what you're trying to indicate here.

On of the tests I do is the file system against the database, reading each 
file from the FS and checking that it exists in the recorded database and is 
in the correct storage group (The script knows which directory the file is 
in). What I've see is that if the LiveTV storage group doesn't exist MythTV 
stores are recordings in the Default storage group.

Maybe I need to sit down with a real English speaking person and go through 
all the messages that the script creates and improve/change them.

> -- 
> Dan Wilga                                                        "Ook."

Regards
Ian Dobson



More information about the mythtv-dev mailing list