Scott Fones wrote:
I can't seem to start mythbackend. I have mysql version 4.1.15 and
the mc.sql database inserted. I have qt version 3.3.4 and mythtv
version .18.1. Heres what I get when I try to run mythbackend
mythbackend
2005-12-01 19:25:38.261 New DB connection, total: 1
2005-12-01 19:25:38.267 Setting Lock for Database Schema upgrade. If
you see a long pause here it means the Schema is already locked and is
being upgraded by another Myth process.
2005-12-01 19:25:38.268 New DB connection, total: 2
2005-12-01 19:25:38.269 Told to create a NEW database schema, but the database
already has 16 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.
2005-12-01 19:25:38.269 Database Schema upgrade FAILED, unlocking.
2005-12-01 19:25:38.269 Couldn't upgrade database to new schema
Well, it can't find a database schema version number which it
writes at the end of any update including the initial update.
There should be about 40 tables but you only have 16. Without
a DBSchemaVer it thinks it should install a fresh database but
you already have about 1/3 of the stuff there. There's the rub.
Whether or not you remember (or would admit to it ;-) the process
died or was killed the first time you ran a myth process.
$ mysql -u mythtv -pmythtv mythconverg
mysql> drop database mythconverg;
mysql> create database mythconverg;
mysql> quit
This will give you a clean, empty DB. Start mythtv-setup by itself
before running any other myth programs. Wait for it to finish
loading the database, uninterrupted, even if this takes a minute
or two.
-- bjm
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
