On Mon, Sep 1, 2008 at 9:05 AM, Kevin Steen <[EMAIL PROTECTED]> wrote:
> On Sun, 2008-08-31 at 19:02 -0700, Michael Drons wrote:
> > Dave,
> > I am not sure why the query does not find the needed value. I am
> hoping that someone who understand PAL can help. If you look at the query
> do the values look correct, channel ID and starttime?
> >
> > Type = 6, is a constant value, and I believe it to be correct for
> everyone.
> >
> > the offset is the piece that must be wrong. In the setting of the
> bookmark, offset comes from the mvpmc video seek function. Which basically
> returns the location in the mpeg stream. Mythtv marks the stream at
> different offsets. We need the mark values from the DB that is closest to
> the offset.
> >
> > Can you test jumping to a bookmark? I suspect it does not work also.
> >
> > Can you run a DB query by hand?
> >
> > SELECT * FROM recordedseek WHERE chanid = '1004' AND type = 6 AND
> starttime = '2008-03-06T00:05:00' (this should return 3000+ rows)
> >
> > Thanks, Mike
>
> In my database, every entry has a type of '9'. All my recordings are
> from a DVB-Terrestrial card from UK transmissions.
>
I can also confirm that UK DVB-T recordings are type 9.
The log shows:
VIDEO MODE = 1
MIKE -- SELECT mark FROM recordedseek WHERE chanid = 2002 AND offset>=
177187272 AND type = 6 AND starttime = 2008-09-01T18:26:00 ORDER by MARK
MIKE -- mark = 0
Bookmark not set
Regards
Andy
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
