[mythtv-users] mythfilldatabase ran, but did not insert any new data

[William Powers]

Hmmm.  At first I assumed that the mythfilldatabase results were 
unrelated the channel changing (or lack thereof) problem.  Upon further 
reflection, however, may have been a bad assumption.

I remembered that when I performed the migration to 0.15, I had no 
problems until I got to the post-install portion of the procedure in 
section 21.19 of the docs.  At that point, I ran mythfilldatabase like 
it said and that seemed to work ok.  Then I tried to run the procedure 
to restore the channel icons.  First I made a backup (I always backup 
the database before I do anything in mysql that changes it) and I 
checked my version of mysql which was 3.23.something.  I interpreted 
that to mean I needed to run the seven line version of the procedure 
which I did via cut-and-paste.  After that, my database was borked and I 
had the same  channel-won't-change problem.  To get out of it, I dropped 
my database and restored from the pre-procedure backup.  At that point, 
I decided to worry about icons later and skipped the rest of 21.19.

If you have mythweb running, try going to Settings->Channels and see if 
all your channum(s) and freqid(s) are as expected (ie., 2,2 3,3 4,4, 
etc.).  If not, if they're blank or have text in them, that is probably 
the cause of the no-channel-changes problem.  At that point, I would 
suggest re-running section 21.19 again; specifically running setup, 
answering 'yes' to 'clear all program/channel settings..." and then 
running mythfilldatabase again.

William Powers wrote:

> I presume that you ran mythfilldatabase during the migration and got ~ 
> 12.75 days worth of guide data?  Then, a few hours later, the normal, 
> daily DataDirect transaction ran and produced the message you cited?  
> If so, I don't believe there is anything unusual about that, since 
> there was probably no new information available.  However, if it 
> doesn't work the next day, then that would be a problem.
>
> Gary Lerhaupt wrote:
>
>> I followed the guidelines to transition from xmltv to datadirect.  I set
>> up my account, redid the setup and mythfilldatabase performs (or seems
>> to perform) as I would expect it.  However, I don't get any guide
>> information, and from status, it tells me that
>> mythfilldatabase ran, but did not insert any new data into the Guide. 
>> This can indicate a potential grabber failure.
>>
>> Interestingly, when I go into myth setup and look at the channel editor,
>> it does not show any channels there.  As well, though this is probably
>> unrelated, I recently started getting segfaults from klipper whenever
>> going into init 5.  Further, I can no longer even change the channel and
>> am stuck permanently on ABC (channel 3).  Each time I try to change the
>> channel, it just shows the info as (-1440 minutes).  If I bring up the
>> guide, it is completely empty (doesn't even say Unknown) and if I try to
>> move the cursor, the frontend completely dies.
>>
>> I have updated and recompiled as of cvs today.  I have done a lot of
>> searching through the list and have not seen anyone else report similar
>> behavior.  Any thoughts?
>>
>> Thanks,
>> Gary
>>
>>
>>  
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>  
>>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users