[mythtv-users] mythcommflag not updating database

[Justin Alcorn]

When I cut commercials out of a recording, and run mythcommflag
--rebuild, it reports running successfully but never updates the
recordedseektable. When I run with --verbose database, I see it
accessing the database, updating the recordedmarkup table, so I know
it has access to the database

Oct 18 12:36:02 gossamer mythcommflag: mythcommflag[7727]: I
CoreContext mythdbcon.cpp:193 (OpenDatabase) [DBManager0] Connected to
database 'mythconverg' at host: localhost
Oct 18 12:36:02 gossamer mythcommflag: mythcommflag[7727]: D
CoreContext mythcontext.cpp:432 (FindDatabase) FindDatabase() -
Success!
...
Oct 18 12:36:02 gossamer mythcommflag: mythcommflag[7727]: I
CoreContext mythdbcon.cpp:193 (OpenDatabase) [DBManager1] Connected to
database 'mythconverg' at host: localhost
Oct 18 12:36:02 gossamer mythcommflag: mythcommflag[7727]: I
CoreContext mythdbcon.cpp:709 (exec) MSqlQuery::exec(DBManager1)
SELECT data FROM settings WHERE value = 'language' AND hostname =
'gossamer' <<<< Took 0ms, Returned 1 row(s)
Oct 18 12:36:02 gossamer mythcommflag: mythcommflag[7727]: D
CoreContext mythdbcon.cpp:779 (seekDebug) MSqlQuery::next(DBManager1)
Result: "data = EN_US"
...
Oct 18 12:37:09 gossamer mythcommflag: mythcommflag[7727]: I
CoreContext mythdbcon.cpp:709 (exec) MSqlQuery::exec(DBManager1)
INSERT INTO recordedmarkup (chanid, starttime, mark, type, data)
VALUES ( '2267', '2014-10-07T06:30:00Z', 0, '34', '684292'); <<<< Took
0ms

But no inserts or updates at all into recordedseek. I do see it
looking for existing information:

Oct 18 12:39:25 gossamer mythcommflag: mythcommflag[7860]: I
CoreContext mythdbcon.cpp:709 (exec) MSqlQuery::exec(DBManager1)
SELECT mark, offset FROM recordedseek WHERE chanid = '2267' AND
starttime = '2014-10-07T06:30:00Z' AND type = '7' ; <<<< Took 0ms,
Returned 0 row(s)

If I go ahead and tell mythcommflag to flag commercials, I still get
no seektable, and can't fast forward or rewind correctly.

I do see this error, but it seems that people say it's not consequential.

2014-10-18 12:39:25.209938 C mythcommflag version: master
[v0.28-pre-2291-gd97aeef] www.mythtv.org
2014-10-18 12:39:25.209969 C Qt version: compile: 4.8.6, runtime: 4.8.6
2014-10-18 13:27:41.525877 E decoding error
eno: Unknown error 541478725 (541478725)

What am I missing? I thought this was how you built that table.
--
Justin B. Alcorn
PGP Fingerprint A36D D691 C5B0 BE15 5A2A AF49 AA1C 372C