Mythfilldatabase can not complete.
I can run the ./setup and being able to grab the channel info without 
difficulties:

--------------------------------------------
./setup
2005-02-12 11:12:38.677 Switching to square mode (blue)
2005-02-12 11:12:39.284 Joystick disabled.
2005-02-12 11:17:17.751
2005-02-12 11:17:17.805
2005-02-12 11:17:17.832
2005-02-12 11:18:02.992 Fetching lineups from DataDirect service...
--11:18:03--  http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
           => `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

    [     <=>                             ] 14,639         7.53K/s

11:18:07 (7.52 KB/s) - `-' saved [14,639]

Your subscription expires on 04/02/2005 11:00:10 PM
---------------------------------------------
Then when I run mythfilldatabase it seems that INSERT can not do it. Here is 
the error:

----------------------------------------------
Clearing from Fri Feb 11 00:00:00 2005 to Sat Feb 12 00:00:00 2005 (localtime)
Data for source cleared...
Main temp tables populated.  Updating myth channels...
Updating icons for sourceid: 1
Channels updated..  Updating programs...
DB Error (Inserting into program table):
Query was:
INSERT IGNORE INTO program (chanid, starttime, endtime, title, subtitle, descrip
tion, showtype, category, category_type, airdate, stars, previouslyshown, stereo
, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalaird
ate, colorcode, syndicatedepisodenumber, programid) SELECT chanid, starttime, en
dtime, title, subtitle, description, showtype, dd_genre.class, category_type, ai
rdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumb
er, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, dd
_v_program.programid FROM dd_v_program LEFT JOIN dd_genre ON (dd_v_program.progr
amid = dd_genre.programid AND dd_genre.relevance = '0');
Driver error was [2/2013]:
QMYSQL3: Unable to execute query
Database error was:
Lost connection to MySQL server during query
-------------------------------------------------

Please any tip?. I have been searching and testing any possible places and I 
can not find the problem.
Please email me and post it ([EMAIL PROTECTED]).

Thanks


-=terry(Denver)=- _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Reply via email to