[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 |
> 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?
More information about the mythtv-users