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

Juergen Sachs juergen-sachs at gmx.de
Wed Jan 13 23:30:04 UTC 2010


Am Mittwoch, 13. Januar 2010 23:59:33 schrieb 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).
The select reports "1".
So I did an "UPDATE recorded SET bookmark = 1 WHERE bookmark not in (0,1);" an 
it SOLVED. (Changed only the one line that seems to be buggy, hope thats fine 
too)

By the way I do not saw the error message about length mismatch before running 
the SQL query. I had that in the past where I saw nothing, but now it is gone. 
Also when I saw it in the past I found out, that mythbackend did not a schema 
update, I think it was because of mythfrontend running already.

Thanks a lot
Juergen


More information about the mythtv-users mailing list