[mythtv] [PATCH] mythfilldatabase errors

[Isaac Richards]

On Tuesday 22 April 2003 11:01 am, Ben Bucksch wrote:
> I got SQL errors when running mythfilldatabase from CVS.
>
> I get 1000s of lines from these on stdout. IIRC, I previously had
> similar problems with the indexes on title.
> I removed the primary keys / indexes from the program and record tables
> and that problem is gone. Not sure what the right fix would be, but a
> unique chan/starttime seems to conflict with the fact that there are
> conflicting programmes (not sure why), which some special Myth code
> explicitly checks for and removes ("removing conflicting program"), and
> I get lots of those.

You've either got duplicate programs in the data (in which case the error 
message is innocuous), or you've got multiple channels with the same chanid.

> 2. It's nice to see that you added credits data to the DB. But the names
> can include quotes:
>
> You have an error in your SQL syntax near 'M")")' at line 1
> SELECT person FROM people WHERE name = "Bernard Lee ("M")";
>
> A patch for that is attached. It also changes an .ascii() to
> utf8().data(), which sounds better to me (or was there a reason that you
> used ascii()?).

The role can only be certain values to be a valid xmltv file, and none of them 
contain utf-8 or " or anything of that sort, so it doesn't need to convert to 
utf8 to dump into the db.

Isaac