[mythtv-users] Keybindings errors and schema problems during setup
knowledgejunkie at gmail.com
Wed May 17 05:23:40 UTC 2006
On 17/05/06, dpaking at charter.net <dpaking at charter.net> wrote:
> I am having the same issue when I run mythtv-setup. Example:
> Terminal output:
> 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
> 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.
Check out the official docs here:
You should be able to drop the mythconverg database, then recreate it
using the supplied mc.sql script. There are instructions for Gentoo,
Fedora and Debian.
MythTV Official wiki:
MythTV users list archive:
More information about the mythtv-users