[mythtv] Database schema checker
i.dobson at planet-ian.com
Tue Sep 2 17:38:43 UTC 2008
> 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
> Also, what does this message mean?:
> File [filename] exits in the database but it's in storage group
> 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."
More information about the mythtv-dev