[mythtv-users] Keybindings errors and schema problems during setup

[dpaking at charter.net]

I am having the same issue when I run mythtv-setup. Example:

Terminal output:
mythtv-setup
2006-05-16 21:48:22.750 New DB connection, total: 1
Total desktop width=1600, height=1200, numscreens=1
2006-05-16 21:48:22.756 Using screen 0, 1600x1200 at 0,0
2006-05-16 21:48:22.757 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.
2006-05-16 21:48:22.758 New DB connection, total: 2
2006-05-16 21:48:22.759 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.

2006-05-16 21:48:22.759 Database Schema upgrade FAILED, unlocking.
2006-05-16 21:48:22.764 Switching to square mode (blue)
DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'UP', 'Up Arrow', 'Up', 'raider1' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist


As I continue to work through the setup GUI, more of the keybindings errors are generated.

SHOW TABLES in mysql yields:

+----------------------------+
| Tables_in_mythconverg      |
+----------------------------+
| callsignnetworkmap         |
| capturecard                |
| cardinput                  |
| channel                    |
| codecparams                |
| conflictresolutionany      |
| conflictresolutionoverride |
| conflictresolutionsingle   |
| credits                    |
| dvb_channel                |
| dvb_pids                   |
| dvb_sat                    |
| dvb_signal_quality         |
| favorites                  |
| housekeeping               |
| jobqueue                   |
| schemalock                 |
+----------------------------+


It seems the schema is not being created correctly. I have dropped mythconverg twice and started over, and also emerged the Gentoo mythtv package twice, but still get the same issue. I am running the frontend and backend on the same machine.

It seems that the database schema is created and updated by the application. Is there a standalone sql script that can be run? I've poked around in mythtv svn and looked at the documentation at http://www.cuymedia.net/doxygen-dev-docs/html/group__db__schema.html, but to no avail.

Thanks in advance.