deprecated.net

I was watching a recording the other day and tried to use the "edit recording" function to cut off the commercials andp the beginning and end. Up popped "no seektable" and I couldn't do it. I tried to fast forward, but that wasn't possible, Mythtv acted like I'd zoomed directly to the end.

Using PHPMyAdmin, I checked the "recordedseek" table in the database. It was corrupted.

I entered these commands at a prompt (I'm on ubuntu):

$ sudo /etc/init.d/mythtv-backend stop
$ mysqlcheck -r -u mythtv -p mythconverg
$ sudo /etc/init.d/mythtv-backend start


relevant output of mysqlcheck is here:

mythconverg.recordedseek
warning : Number of rows changed from 151562 to 151532
status : OK


Then I ran commercial flagging on the recordings in my mythtv directory.

$ mythcommflag --rebuild -f


The date of the recording is in the filename.
And now it works for me.