[mythtv-users] Saved position no longer working

[Michael T. Dean]

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