[mythtv-users] mythfilldatabase hang on schedulesdirect since update
Philippe Demartin
philippe at demartinenchile.com
Wed Aug 25 02:40:27 UTC 2010
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
phd at Philippe:~> mythfilldatabase --sourceid 21
2010-08-08 11:28:53.459 Using runtime prefix = /usr
2010-08-08 11:28:53.459 Using configuration directory = /home/phd/.mythtv
2010-08-08 11:28:53.460 Empty LocalHostName.
2010-08-08 11:28:53.460 Using localhost value of Philippe
2010-08-08 11:28:53.607 New DB connection, total: 1
2010-08-08 11:28:53.657 Connected to database 'mythconverg' at host: localhost
2010-08-08 11:28:53.657 Closing DB connection named 'DBManager0'
2010-08-08 11:28:53.657 Connected to database 'mythconverg' at host: localhost
2010-08-08 11:28:53.661 Current MythTV Schema Version (DBSchemaVer): 1254
2010-08-08 11:28:53.663 Running for sourceid 21 ONLY because --sourceid was
given on command-line
2010-08-08 11:28:53.663 New DB connection, total: 2
2010-08-08 11:28:53.663 Connected to database 'mythconverg' at host: localhost
2010-08-08 11:28:53.665 Updating source #21 (SCDMexico_Cable) with grabber
schedulesdirect1
2010-08-08 11:28:53.666 Found 88 channels for source 21 which use grabber
2010-08-08 11:28:53.666
2010-08-08 11:28:53.666 Checking day @ offset 0, date: Sun Aug 8 2010
2010-08-08 11:28:53.669 Data refresh needed because no data exists for day @
offset 0 from 8PM - midnight.
2010-08-08 11:28:53.669 Refreshing data for Sun Aug 8 2010
2010-08-08 11:28:53.669 New DB DataDirect connection
2010-08-08 11:28:53.669 Connected to database 'mythconverg' at host: localhost
2010-08-08 11:28:53.670 Retrieving datadirect data.
2010-08-08 11:28:53.670 Grabbing data for Sun Aug 8 2010 offset 0
2010-08-08 11:28:53.670 From Sun Aug 8 04:00:00 2010 to Mon Aug 9 04:00:00
2010 (UTC)
2010-08-08 11:28:53.670 Grabbing listing data
--2010-08-08 11:28:53--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to webservices.schedulesdirect.tmsdatadirect.com|
144.142.232.53|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to webservices.schedulesdirect.tmsdatadirect.com|
144.142.232.53|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: `STDOUT'
[ <=> ] 36,274
8.23K/s 2010-08-08 11:29:02.599 New DB connection, total: 3
2010-08-08 11:29:02.599 Connected to database 'mythconverg' at host: localhost
2010-08-08 11:29:02.601 DataDirect: Your subscription expires on Sun Jun 19
(2011) 22:24
2010-08-08 11:29:02.809 sourceid 21 has lineup type: Cable
[ <=> ]
927,344 9.15K/s in 85s
2010-08-08 11:30:23 (10.6 KB/s) - `-' saved [927344]
2010-08-08 11:30:23.955 Grab complete. Actual data from Sun Aug 8 04:00:00
2010 to Mon Aug 9 04:00:00 2010 (UTC)
2010-08-08 11:30:23.955 Main temp tables populated.
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
2010-08-08 11:30:23.967 IconData: Updating icons for sourceid: 21
2010-08-08 11:30:23.967 Channels updated.
2010-08-08 11:30:23.968 Error preparing query: INSERT INTO dd_v_program (
chanid, starttime, endtime, title,
subtitle, description, airdate, stars,
previouslyshown, stereo, dolby, subtitled,
hdtv, closecaptioned, partnumber, parttotal,
seriesid, originalairdate, showtype,
category_type, colorcode, syndicatedepisodenumber, tvrating,
mpaarating, programid ) SELECT chanid,
scheduletime, endtime, title, subtitle,
description, year, stars, isrepeat,
stereo, dolby, subtitled, hdtv,
closecaptioned, partnumber, parttotal, seriesid,
originalairdate, showtype, category_type, colorcode,
syndicatedepisodenumber, tvrating, mpaarating,
dd_program.programid FROM channel, dd_schedule, dd_program WHERE
((dd_schedule.programid = dd_program.programid) AND (channel.xmltvid
= dd_schedule.stationid) AND (channel.sourceid = :SOURCEID))
2010-08-08 11:30:23.968 Driver error was [2/1267]:
QMYSQL3: Unable to prepare statement
Database error was:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(utf8_unicode_ci,IMPLICIT) for operation '='
2010-08-08 11:30:23.968 DB Error (Populating temporary table dd_v_program):
Query was:
INSERT INTO dd_v_program ( chanid, starttime,
endtime, title, subtitle, description,
airdate, stars, previouslyshown, stereo,
dolby, subtitled, hdtv,
closecaptioned, partnumber, parttotal, seriesid,
originalairdate, showtype, category_type, colorcode,
syndicatedepisodenumber, tvrating, mpaarating, programid )
SELECT chanid, scheduletime, endtime,
title, subtitle, description, year,
stars, isrepeat, stereo, dolby,
subtitled, hdtv, closecaptioned, partnumber,
parttotal, seriesid, originalairdate, showtype,
category_type, colorcode, syndicatedepisodenumber, tvrating,
mpaarating, dd_program.programid FROM channel, dd_schedule,
dd_program WHERE ((dd_schedule.programid = dd_program.programid) AND
(channel.xmltvid = dd_schedule.stationid) AND (channel.sourceid
= :SOURCEID))
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))' at
line 1
2010-08-08 11:30:24.025 Did not find any new program data.
More information about the mythtv-users
mailing list