[mythtv-users] trunk: mythfrontend does not show all recordings

[Michael T. Dean]

On 01/13/2010 05:41 PM, Juergen Sachs wrote:
> Am Mittwoch, 13. Januar 2010 20:47:59 schrieb Michael T. Dean:
>   
>> Do me a favor and shut down mythfrontend, then go to
>> $HOME/.mythtv/config.xml and /all/ of the mysql.txt files (use locate or
>> find to find them) on your system and edit them to override the
>> LocalHostName.
>>
>> So, for mysql.txt, something like:
>>
>> LocalHostName=testhostnametoresetdefaults
>> DBHostName=localhost
>> DBUserName=mythtv
>> DBPassword=mythtv
>> DBName=mythconverg
>> DBType=QMYSQL3
>>
>> and for config.xml add:
>>
>>         <LocalHostName>testhostnametoresetdefaults</LocalHostName>
>>
>> to the <DefaultBackend> section of the file (with <DBHostName>,
>> <DBUserName>, etc.).
>>
>> Then restart mythfrontend and, if all works, please let me know--as it
>> means you have the wrong settings.  Then, I'll take the time to point
>> out every single setting you need to change to make it work.
>>
>> This is /exactly/ why we need to simplify settings (as there are about
>> 5-10 settings involved).
>>     
> I did as you told me.
> First the config.xml file is empty, but in the same directory is a mysql.txt.
> I made the changes you mentioned and when mythfrontend comes up, it request to 
> select the language. So it seems to be a new configuration.
>
> But still the same. When I select "All Programs" it tells me "There are 101 
> recordings in this group", when I press "m" then "change group filter" it 
> tells me "All Programms [1388 items]".
>   

OK.  So you can go ahead and put things back the way they were (and use 
the other/real hostname)--probably just delete the LocalHostName 
override lines from the files.

> So still not all recordings, they are only showed up to about end January 
> 2006.
>
> Any ideas ?

I could have sworn I had already asked you to do this, but looking 
through the ML archive, I don't see my asking you.  Perhaps I had asked 
someone else, or perhaps the message is still in the "Unsent" folder on 
my laptop (being busy with travel last week, I may well have forgotten).

Anyway, do you see an error in your frontend log files about, "length 
mismatch between programinfo"?  Can you please run:

cat << "EOF" | mysql -umythtv -p mythconverg
SELECT COUNT(*) FROM recorded WHERE bookmark NOT IN (0, 1);
EOF

If the value is anything other than 0, that's the problem, and you can 
fix it with:

cat << "EOF" | mysql -umythtv -p mythconverg
UPDATE recorded SET bookmark = 1 WHERE bookmark != 0;
EOF

as mentioned at http://svn.mythtv.org/trac/ticket/7467#comment:2

Note, also, that eventually Qt will be fixed.  There are bug reports at 
http://bugreports.qt.nokia.com/browse/QTBUG-5758 and 
http://bugreports.qt.nokia.com/browse/QTBUG-5765 .  QTBUG-5758 has been 
fixed for Qt 4.6.1 (so with 4.6.1, Myth would actually see the failure 
and tell you things are wrong).  QTBUG-5765 is still awaiting review 
(though you can apply that patch if you happen to compile Qt yourself), 
and it will fix the problem completely (i.e. you won't have the 
truncation, so everything will work--even with invalid data).  However, 
it's much easier to do the update above, if you do have invalid data, 
and you'll never see this problem again (even with a buggy Qt).

Mike