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

Mark Perkins perkins1724 at hotmail.com
Wed Aug 21 05:02:50 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.
Mark



More information about the mythtv-users mailing list