[mythtv-users] no seek table after upgrade to 0.27

Mark Perkins perkins1724 at hotmail.com
Wed Aug 21 05:22:55 UTC 2013


//snip//  it appears that the seek table on existing recordings are wiped.
//snip//

Further to the above. Using Mythcommflag to rebuild the seektable fails with
the following:

2013-08-21 14:27:55.482999 E  Error preparing query: INSERT INTO
recordedseek (chanid, starttime, mark, type, offset)  VALUES ( :CHANID ,
:STARTTIME , :MARK , :TYPE , :OFFSET )
2013-08-21 14:27:55.483012 E  Driver error was [2/144]:
QMYSQL3: Unable to prepare statement
Database error was:
Table './mythconverg/recordedseek' is marked as crashed and last
(automatic?) repair failed

2013-08-21 14:27:55.483170 E  DB Error (delta position map insert):
Query was:
INSERT INTO recordedseek (chanid, starttime, mark, type, offset)  VALUES (
:CHANID , :STARTTIME , :MARK , :TYPE , :OFFSET ) Bindings were:
:CHANID=1022, :MARK=48996, :OFFSET=1959840, :STARTTIME=2013-08-20T22:25:00Z,
:TYPE=33
Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ':CHANID ,
:STARTTIME , :MARK , :TYPE , :OFFSET )' at line 1

Any assistance possible would be greatly appreciated.

Sorry should add:
Mythfrontend Version: master (v0.27-beta-11-gba1af1d)
MythTV Python Bindings
  local versions
    bindings version:         0.27.-1.0
    ttvdb version:            1.2.1
    tmdb version:             v0.2.6
  external versions
    lxml version:             3.1.0
    MySQLdb version:          1.2.3.final.0
  protocol versions
    backend:                  77
    schema:                   1316
    music schema:             1018
    netvision schema:         1007



More information about the mythtv-users mailing list