[mythtv] [PATCH] mythfilldatabase errors
ijr at po.cwru.edu
Tue Apr 22 13:06:58 EDT 2003
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.
More information about the mythtv-dev