[mythtv-users] Saved position no longer working

[Stuart Larson]

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
>