[mythtvnz] Backend failed ...

[Jim Cheetham]

On Sat, Nov 14, 2009 at 3:26 PM, Hadley Rich <hads at nice.net.nz> wrote:
> On Sat, 2009-11-14 at 14:17 +1300, Steve Hodge wrote:
>> I agree that having frontends do db schema upgrades seems like a bad
>> idea. The docs do say not to use different versions on the front and
>> back ends though.
>
> I think these days you need to pass a flag to mythfrontend to allow it
> to upgrade the schema. The backend and mythtv-setup will upgrade it
> automatically.

I now suspect something like installing mythtv-frontend on my Ubuntu
9.10 desktop has done this, I removed it a few days ago and noticed
that it seemed to have installed -backend and mysql on here ..
although it was pointed at the server. Possibly a stupid default in
the Ubuntu packaging or a stupid user not reading the messages?

mysql> select * from settings where value='DBSchemaVer';
+-------------+------+----------+
| value       | data | hostname |
+-------------+------+----------+
| DBSchemaVer | 1244 | NULL     |
+-------------+------+----------+

Well, it sounds like I've broken things one way or another, and
there's no way back. I suspect my best way forward is to dist-upgrade
the machine a couple of times from 8.10 to 9.10 ... see what else
breaks on the way!

-jim