[mythtv-users] mythfilldatabase hang on schedulesdirect since update

[Philippe Demartin]

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
>