[mythtv-users] mythfilldatabase failure .16
Dave Ashmore
pubmail at djash.com
Thu Oct 28 19:04:15 UTC 2004
Tim wrote:
> Asher Schaffer wrote:
>
>> It appears that mythfilldatabase is failing to pull data from zap2it.
>> After the initial 401 Unauthorized failure (which is normal I
>> believe), it is getting a 500 Internal Server Error.
>>
>> --08:40:02--
>> 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... 500 Internal Server Error
>> 08:40:14 ERROR 500: Internal Server Error.
>>
>>
>> Is anyone else seeing this? I double checked that my subscription
>> with zap2it, and it looks fine, doesn't expire until December. Any
>> ideas, I only have about 10 days of programming info left, it would be
>> most unfortunate to run out.
>>
>> Thanks,
>> Asher
>>
>>
> Any chance your disk is full? I got some wierd errors from
> mythfilldatabase when that happened to me (cause for some reason mysql
> is making*huge* log files).
>
> Tim
I just posted a message last night with the following I too am experiencing trouble.
DB Error (Inserting into dd_schedule):
Query was:
INSERT INTO dd_schedule
(programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION,:REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED,:TVRATING,:PARTNUMBER,:PARTTOTAL,:ENDTIME);
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.dd_schedule' doesn't exist
I exported a known mythconverg database and imported it thinking maybe
it did no get created right and when I run mythfilldatabase I still get
this error.
The table dd_schedule does not exit.
When I initally ran mythtvsetup the database had 36 tables the known
good database on another machine had 59.
So I exported it and imported it ino the other thinking it would fix.
Please help.
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
--
Regards
Dave Ashmore
MDK 10.0 Official Mozilla 1.7
More information about the mythtv-users
mailing list