[mythtv] Help: Upgraded Mythtv - now database out of sync

Steve Daniels steve.p.daniels at googlemail.com
Mon May 5 13:45:58 UTC 2008

2008/5/5 Dave Phillips <family_of_phillips at yahoo.com>:
> Sorry I sent this without a subject.
> Dave Phillips <family_of_phillips at yahoo.com> wrote:
>  Hello all,
> I just upgraded to 0.21 from a knoppmyth install.
> I then noticed some problems:
> I couldn't insert records into the Channel table because its missing a
> column called "default_authority"
> The insert statement is trying to put something into that column.
> Also in the diseqc_tree table there was a column called "address" that was
> missing.
> It would seem my structure is not correct somehow.
> So somehow my tables have gotten out of sync.
> It seemed to complete all of the updates okay so I am not sure where things
> went wrong.
> I am also not sure if it is my tables are bad or the queries are out of sync
> as I can't see the default_authority column in the current schema.
> Can anyone help fix things? I added the columns but I would like to do it
> right.
> Thanks
> Dave

Dave please send this to the mythtv-users list, you'll get help there.

Steve Daniels

More information about the mythtv-dev mailing list