[mythtv-users] cutlists not saved

[Patrick Mansfield]

I am (apparently) unable to save cutlists in my database.

I've tried via mythfrontend, per these steps:

http://www.mythtv.org/wiki/index.php/Removing_Commercials#Removing_commercials_using_mythfrontend

It loads a cutlist from the commercial flagging, modify them some, but
once I exit the editor, the cutlist is gone.

Running transcode at that point does nothing (well the commercial flag
list disappears, but otherwise the video is the same).

I've run mysqlcheck, with no problems flagged - though I am not sure what
options to use other than the default.

I am running svn .19 fixes current, with current FC5.

I started out with .19, and also screwed up and tried to run svn current
at one point (it is not hard to do if you confuse svn-0.19-fixes with just
svn ... oh well).

Scheduling, recording, and everything else is working fine.

Any clues as to how to fix this?

Here is some debug output for gencutlist, followed immediately by
getcutlist for mythcommflag:

# mythcommflag -v database --gencutlist -c 1013 -s 20060509230000
2006-05-17 18:11:02.465 Using runtime prefix = /usr/local
2006-05-17 18:11:02.478 New DB connection, total: 1
2006-05-17 18:11:02.483 Connected to database 'mythconverg' at host: localhost
2006-05-17 18:11:02.486 MSqlQuery: SELECT recorded.chanid,starttime,endtime,title, subtitle,description,channel.channum, channel.callsign,channel.name,channel.commfree, channel.outputfilters,seriesid,programid,filesize, lastmodified,stars,previouslyshown,originalairdate, hostname,recordid,transcoder,playgroup, recorded.recpriority,progstart,progend,basename,recgroup FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recorded.chanid = '1013' AND starttime = '20060509230000' ;
2006-05-17 18:11:02.488 New DB connection, total: 2
2006-05-17 18:11:02.489 MSqlQuery: SELECT commflagged, cutlist, autoexpire, editing, bookmark FROM recorded WHERE chanid = '1013' AND starttime = '2006-05-09T23:00:00' ;
2006-05-17 18:11:02.492 MSqlQuery: SELECT mark, type FROM recordedmarkup WHERE chanid = '1013' AND starttime = '2006-05-09T23:00:00' AND type = 4 ORDER BY mark;
2006-05-17 18:11:02.495 MSqlQuery: SELECT mark, type FROM recordedmarkup WHERE chanid = '1013' AND starttime = '2006-05-09T23:00:00' AND type = 5 ORDER BY mark;
2006-05-17 18:11:02.496 MSqlQuery: UPDATE recorded SET cutlist = '1 - 5204
17904 - 21513
34509 - 36781
48544 - 51659
' WHERE chanid = '1013' AND starttime = '2006-05-09T23:00:00' ;

# mythcommflag -v database --getcutlist -c 1013 -s 20060509230000
2006-05-17 18:11:11.453 Using runtime prefix = /usr/local
2006-05-17 18:11:11.467 New DB connection, total: 1
2006-05-17 18:11:11.472 Connected to database 'mythconverg' at host: localhost
2006-05-17 18:11:11.473 MSqlQuery: SELECT cutlist FROM recorded WHERE chanid = '1013' AND starttime = '20060509230000' ;
Cutlist: 1

Thanks ...

-- Patrick Mansfield