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 <filename>

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

Reply

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>
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.

More information about formatting options