[mythtv-users] Still stumped on mythmusic

Ryan Steffes rbsteffes at gmail.com
Tue Oct 19 21:03:44 UTC 2004

On Tue, 19 Oct 2004 16:38:46 -0400, thor <mythtv at lamedomainname.com> wrote:
> On Tuesday 19 October 2004 03:46 pm, Ryan Steffes wrote:
> >
> > Where do those tables come from?  I'm looking for an file containing
> > sql to add them and not finding it anywhere.
> >
>         They are created by mythmusic (the SQL is in the C++) when it runs. It checks
> the version of your tables and constructs/updates them as required. That's
> why it's odd that you say mythmusic is running but the tables aren't there.
> That's also why it would be useful to see what the console output is.
> - thor

Ok, after looking in dbcheck I can answer the question of why it
didn't create the tables, but not the question of why the tables
weren't there to begin with.  The tables are only created if the
MusicDBSchemaVer is set to NULL (or doesn't exist) in the settings
table.  However, I've got  | MusicDBSchemaVer | 1002 | NULL     | in
there.  Why, I don't know.  I guess it's one of the potential hazards
of using a not-completely clean database when transferring from one
host to another, but I'm not sure how the other tables got lost.
Hopefully when I get home tonight it'll magically work after using the
old metadata.sql scripts.

More information about the mythtv-users mailing list