[mythtv-users] Still stumped on mythmusic

[Ryan Steffes]

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.