[mythtv-users] Mythfilldatabase errors

Aaron aaron at rb303.net
Fri Oct 7 01:37:22 UTC 2011


Nope, I started on .22, never had anything prior.

What can i do to fix it?

On Thu, Oct 6, 2011 at 7:11 PM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>


More information about the mythtv-users mailing list