[mythtv-users] mythfilldatabase hang on schedulesdirect since update

[Jonatan]

On 2010-08-27 17:07, Philippe Demartin wrote:
> On Thursday 26 August 2010 11:52:54 Michael T. Dean wrote:
>>    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
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>>
> this command give me nothing, it dose not complete and hang at the next line :
> (
> cat<<  "EOF" | mysql -umythtv -p mythconverg 2>&1
>
> phd at Philippe:~>  cat<<  "EOF" | mysql -umythtv -p mythconverg 2>&1 | tee -a
> ~/output.txt
>>
>
That's because you missed the following lines:
show variables like '%coll%';
show create database mythconverg;
EOF

--
Jonatan