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

dpaking at charter.net dpaking at charter.net
Wed May 17 17:05:07 UTC 2006


---- Nick <knowledgejunkie at gmail.com> wrote: 
> 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:
> > 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
> 
> <snip>
> 
> > 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:
> 
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html
> 
> 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.
> 
> Nick
> -- 
> MythTV Official wiki:
> http://mythtv.org/wiki/
> MythTV users list archive:
> http://www.gossamer-threads.com/lists/mythtv/users
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

This is now solved. After hearing from a couple of other users, I upgraded to 0.19, which is still masked in Gentoo. Those users had also experienced the same problems with 0.18.1-r1 on Gentoo AM64.

Thanks for all the help.


More information about the mythtv-users mailing list