[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