[mythtv-users] mythfilldatabase hang on schedulesdirect since update

[Michael T. Dean]

  On 08/24/2010 10:40 PM, Philippe Demartin wrote:
> Since my update to OpenSuse 11.3, the schedulesdirect  sourceid don't update
> corectly my programs :(
> Mysql Server version: 5.1.46-log SUSE MySQL RPM
>
> I've tryed to compile mythtv and get the same exact result :( It's look like
> it's a mysql problem.
> I'm now using xmltv directtv_la grabber for now, but the quality of the
> information is poor in comparison with schedulesdirect
>
> Here is my log for the first day, after that, it jump to the next day after
> leaving no new record in the DB :( an so on
...
> 2010-08-08 11:30:23.955 Updating myth channels.
> 2010-08-08 11:30:23.966 Error preparing query: SELECT dd_v_station.stationid,
> dd_v_station.callsign,                dd_v_station.stationname,
> dd_v_station.fccchannelnumber,        dd_v_station.channel,
> dd_v_station.channelMinor      FROM dd_v_station LEFT JOIN channel ON
> dd_v_station.stationid = channel.xmltvid AND      channel.sourceid = :SOURCEID
> WHERE channel.chanid IS NULL
> 2010-08-08 11:30:23.966 Driver error was [2/1267]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and
> (utf8_general_ci,IMPLICIT) for operation '='
>
> 2010-08-08 11:30:23.967 DB Error (Selecting new channels):
> Query was:
> SELECT dd_v_station.stationid,   dd_v_station.callsign,
> dd_v_station.stationname, dd_v_station.fccchannelnumber,
> dd_v_station.channel,     dd_v_station.channelMinor      FROM dd_v_station
> LEFT JOIN channel ON      dd_v_station.stationid = channel.xmltvid AND
> channel.sourceid = :SOURCEID WHERE channel.chanid IS NULL
> Bindings were:
> :SOURCEID=21
> Driver error was [2/1064]:
> QMYSQL: Unable to execute query
> Database error was:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near ':SOURCEID WHERE
> channel.chanid IS NULL' at line 1

What does:

cat<< "EOF" | mysql -umythtv -p mythconverg 2>&1 | tee -a ~/output.txt
show variables like '%coll%';
show create database mythconverg;
EOF

give?

I have a feeling your my.cnf is setting some part of MySQL to use 
utf8_unicode_ci as a default collation for utf8, so your database 
definition is broken, so when we create new tables (temp tables), they 
have a broken definition.

Mike