[mythtv-users] Mythfilldatabase errors

Michael T. Dean mtdean at thirdcontact.com
Thu Oct 6 23:11:21 UTC 2011


On 10/06/2011 02:25 PM, Aaron wrote:
> On both of my sources, when running mythfilldatabase via CLI, I get
> the following error. Is this anything I should be worried about?
> Everything seems to be working ok. I am running Mythbuntu 10.10 |
> 0.24+fixes
>
>
>
> 2011-10-06 14:17:22.289 DB Error (Inserting into credits table):
> Query was:
> INSERT IGNORE INTO program   ( chanid,        starttime,   endtime,
...
> Driver error was [2/1267]:
> QMYSQL: Unable to execute query
> Database error was:
> Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
> (latin1_general_ci,IMPLICIT) for operation '='

It looks like your database schema is messed up.  MythTV 0.22+ use utf8, 
not latin1 charset.  Did you do anything "creative" when upgrading to 
0.22 or higher?

Mike


More information about the mythtv-users mailing list