[mythtv-users] [Warning] './mythconverg/settings' had no or invalid character set

[Warren]

Bemer wrote:

>After my upgrade to mythtv version 19 I get alot of errors in my /var/log/mysql/mysqld.err like the one below:
>
>060622 18:54:52 [Warning] './mythconverg/settings' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
>
>In my mythfrontend.log it looks like this:
>2006-06-21 17:14:28.339 DB Error (Insert Keybinding):
>Query was:
>INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'TV Playback', 'SPEEDDEC', 'Decrease the p
>layback 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
>
>What has gone wrong? and how do I  correct this?
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>
You are trying to create an entry for which there is already a
keymapping.  Try this:
update keybindings set keylist='J' where context='TV Playback' and
action='SPEEDDEC' and hostname='HTPC';

W
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060623/c05030b3/attachment.htm