[mythtv-users] mythfilldatabase failure .16

Tim t.tait at comcast.net
Thu Oct 28 21:26:45 UTC 2004


Dave Ashmore wrote:

> 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
>>  
>>
>
>
Try "mysqlcheck -c mythconverg". If it has errors, running it with -r 
will try to repair. Solved similar problems I had (as a result of the 
full disk).

Tim


More information about the mythtv-users mailing list