[mythtv-users] DB Error (Insert Keybinding) in mythfrontend.log duplicate entry for key1

Bemer christian.bemervik at spray.se
Fri Jul 7 13:29:55 UTC 2006


After my upgrade to mythtv 0.19 and mysql version 4 I get alot of errors in my mythfrontend.log. The errors occour after every reboot and I've tried to drop and import mythconverg without any success. I get an error for every entry in my table keybindings see example:

DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES 
( 'TV Playback', 'SPEEDDEC', 'Decrease the playback speed', 'J', 'HTPC' );
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'TV Playbac-SPEEDDEC-HTPC' for key 1


I notice that the duplicate entry misses a character it says Tv Playbac instead of TV Playback. Does this have something to do with characterset? what are the default? is it utf8 or should I use latin1 and what collation should I use? I live in sweden.
What has gone wrong? and how do I correct this? What information will I loose if I recreate my mythconverg database and how do I do that (or is it enough to run mc.sql and then do I mythsetup)?

Gratis Bredbandsabonnemang från Spray. Beställ på www.spray.se/bredband eller 020-266 000


More information about the mythtv-users mailing list