How to fix "no seektable" in MythTV .20

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.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.

More information about formatting options