[mythtv-users] Saved position no longer working

Michael Lynch lynchmv at gmail.com
Tue Jun 13 02:17:48 UTC 2006


On 6/12/06, Stuart Larson <halcyon at obfus.com> wrote:
> Well, that was easy enough:
>
> mysql> ALTER TABLE recorded MODIFY bookmark varchar(128);
> Query OK, 460 rows affected (0.07 sec)
> Records: 460  Duplicates: 0  Warnings: 0
>
> *remembers to make backups more often*
>
>
> > On 06/12/06 21:22, Stuart Larson wrote:
> >
> >>Myth frontend and backend running rev 9710 on .19-fixes branch.
> >>
> >>Strange thing started happening after I installed a second frontend - my
> >>saved positions for recorded programs are no longer working.
> >>
> >>
> >
> > Sounds like someone might have used a newer version of Myth on a
> > frontend or backend.  The new version updated the database for the new
> > bookmark-handling, and the old version can't use it.
> >
> >>On either frontend, I can save position and it says "Position saved" up
> >> in
> >>the top left, but when I start the playback again, even when going
> >>"Playback from... saved position" it starts at the beginning of the
> >>recording.
> >>
> >>On both frontends I have "Save Position and Exit" in the playback
> >> options.
> >> On the main frontend, I have clear saved position on playback checked,
> >>not so on the new frontend. (I watch most stuff from the main frontend).
> >>
> >>I ran mythfrontend -v database, but saw no obvious errors.  The following
> >>is when I 1) start a program, 2) clear the saved postion, 3) save the
> >>position, and 4) exit,  which saves the position again.
> >>
> >>2006-06-12 20:13:21.537 Using realtime priority.
> >>2006-06-12 20:13:21.567 TV: Changing from None to WatchingPreRecorded
> >>2006-06-12 20:13:21.574 MSqlQuery: SELECT COUNT(name) FROM playgroup
> >> WHERE
> >>name <> 'Default' ORDER BY name;
> >>2006-06-12 20:13:21.584 MSqlQuery: SELECT mark, type FROM recordedmarkup
> >>WHERE chanid = '1062' AND starttime = '2006-06-12T15:00:00' AND type = 4
> >>ORDER BY mark;
> >>2006-06-12 20:13:21.586 MSqlQuery: SELECT mark, type FROM recordedmarkup
> >>WHERE chanid = '1062' AND starttime = '2006-06-12T15:00:00' AND type = 5
> >>ORDER BY mark;
> >>2006-06-12 20:13:21.639 Video timing method: USleep with busy wait
> >>2006-06-12 20:13:29.733 MSqlQuery: SELECT bookmark FROM recorded WHERE
> >>chanid = '1062' AND starttime = '2006-06-12T15:00:00' ;
> >>2006-06-12 20:13:29.741 MSqlQuery: UPDATE recorded SET bookmark = NULL
> >>WHERE chanid = '1062' AND starttime = '2006-06-12T15:00:00' ;
> >>2006-06-12 20:13:30.959 MSqlQuery: SELECT bookmark FROM recorded WHERE
> >>chanid = '1062' AND starttime = '2006-06-12T15:00:00' ;
> >>2006-06-12 20:13:30.961 MSqlQuery: UPDATE recorded SET bookmark = '399'
> >>WHERE chanid = '1062' AND starttime = '2006-06-12T15:00:00' ;
> >>2006-06-12 20:13:40.565 MSqlQuery: UPDATE recorded SET bookmark = '687'
> >>WHERE chanid = '1062' AND starttime = '2006-06-12T15:00:00' ;
> >>2006-06-12 20:13:40.565 TV: Attempting to change from WatchingPreRecorded
> >>to None
> >>
> >>When I look at the bookmark value for this program I get:
> >>
> >>mysql> SELECT bookmark FROM recorded WHERE chanid = '1062' AND starttime
> >> >'2006-06-12T15:00:00' ;
> >>+----------+
> >>| bookmark |
> >>+----------+
> >>|      127 |
> >>+----------+
> >>1 row in set (0.00 sec)
> >>
> >>Is this normal?
> >>
> >>One thing I know I did in error was download, compile, install and run
> >>mythfrontend on revision 9710 of the main code branch (as opposed to
> >>.19-fixes).  I then uninstalled, and rebuilt from rev 9710 .19-fixes.
> >>Would this have corrupted tables at all?  Only thing I can think of is
> >>that it messed up the DB schema somehow..
> >>
> >
> > Bingo.
> >
> >> or I'm missing something
> >>entirely easy to fix.
> >>
> >>
> >
> > Roll back your database to your pre-upgrade backup to continue using
> > 0.19-fixes.
> >
> > Mike
> > _______________________________________________
> > 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
>

http://www.flyingsawdust.com/mysqlbackups.sh.txt

Set up to run nightly for me and so far I've not had to use it, but, I
know it's there (and actually mirrored on another local box)


More information about the mythtv-users mailing list