[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