I know this had worked at one point but that might have been with R5E50 so I'm not sure if it's a new issue with R5F1.

Basically, the mythcommflag program does seem to run after a program is recorded, the status page Job Queue shows that commercial detection was successful and shows a has several breaks detected but playing it back on either of my frontends the commercials don't get skipped automatically.

On a frontend I can go to Menu -> Commercial Auto-Skip and "Auto-Skip ON" is enabled. I even hooked up a keyboard and tried to hit End to skip the commercial and it says "Not Flagged" on the screen?

I even checked the mythconverg database in the "settings" table and sure enough all the values with "%Skip%" are showing that commercial skip SHOULD be enabled and working.


AutoCommercialSkip 1 mythtv
MaximumCommercialSkip 3600 NULL
CommSkipAllBlanks 1 NULL
CommercialSkipMethod 1 NULL
AutoCommercialSkip 1 mythfe1
AutoCommercialSkip 1 mythfe2

The right column is the hostname field, mythtv is the backend and mythfe1 and mythfe2 are not surprisingly the frontends.

Any ideas why commerical skip doesn't work 99.9% of the time?[/img]

ggulik,

I am new to mythTv, but I am having the same problem. The commercial skip feature does not appear to be working. I am running R5F1. I have commercial skip enabled. I went to the "System Status" screen but the job queue is empty and see no log entries (checked level 1-8). I did not setup logs to go to the local database, so I do not know if this is why my log queue is empty.

When I try to enable commercial skipping I get the "Not Flagged" message.

So far, Knoppmyth is fabulous and I have this issue and a gigabyte 7300gs video problem to work through. Any advice on how you resolved this (if it is indeed resolved) is greatly appreciated.

I wish I had a resolution but I don't. It seems to work every once in a while. Every week or two I watch a program and suddenly commercial skip works. But, if I play that same program again later it doesn't work any more.

Saying that it's frustrating is an understatement. I never had problems like this with R5E50 so I'm considering going back to that release but its' going to have to wait until I find the time to go through that effort.

ggulick,

I found my problem ... not 100% sure of the result.

I ran 'myisamchk /var/lib/mysql/mythconverg/recordedmarkup.MYI' which came back saying my database was corrupt. I then re-ran with a "-r" option as directed. The next time I recorded, commercials were properly flagged and skipped.

The problem is in the 2 days since I found this issue, I have had to run the command with -r once a day. I am not sure why the corruption occurs.

I read that if you run 'mythcommflag --all' it will re-flag commercials on the already recorded programs.

Hope this helps. I'd be curious if this helps and if you too are having repeated corruption problems.

oh oh!!!!

My database doesn't have a "recordedmarkup" table!!!

Maybe that's my problem?
Can you send me the table definition for that table?

Can you connect to the database from the command line and issue the command "show tables;" and compare it to this list:

Here you go. Hope this helps.

FYI, I did not upgrade, but installed outright. If you upgraded, maybe that had something to do with missing tables.

+--------------------------------+
| Tables_in_mythconverg |
+--------------------------------+
| archiveitems |
| callsignnetworkmap |
| capturecard |
| cardinput |
| channel |
| codecparams |
| credits |
| customexample |
| diseqc_config |
| diseqc_tree |
| dtv_multiplex |
| dtv_privatetypes |
| dvdinput |
| dvdtranscode |
| eit_cache |
| favorites |
| filemarkup |
| gallerymetadata |
| gamemetadata |
| gameplayers |
| housekeeping |
| inuseprograms |
| jobqueue |
| jumppoints |
| keybindings |
| keyword |
| music_albums |
| music_artists |
| music_genres |
| music_playlists |
| music_smartplaylist_categories |
| music_smartplaylist_items |
| music_smartplaylists |
| music_songs |
| music_stats |
| musicmetadata |
| musicplaylist |
| mythlog |
| netflix |
| networkiconmap |
| newssites |
| oldfind |
| oldprogram |
| oldrecorded |
| people |
| phonecallhistory |
| phonedirectory |
| pidcache |
| playgroup |
| profilegroups |
| program |
| programgenres |
| programrating |
| recgrouppassword |
| record |
| recorded |
| recordedcredits |
| recordedmarkup |
| recordedprogram |
| recordedrating |
| recordedseek |
| recordingprofiles |
| recordmatch |
| romdb |
| schemalock |
| settings |
| streams |
| tvchain |
| videocategory |
| videocountry |
| videogenre |
| videometadata |
| videometadatacountry |
| videometadatagenre |
| videosource |
| videotypes |
| websites |
+--------------------------------+
77 rows in set (0.00 sec)

From the diff of the two lists, this is what we have:
We both have the same number of rows, but you have a record_tmp and mythweb_sessions where I have a netflix and recordedmarkup

Maybe someone on the forum knows what caused this.

39c39
< mythweb_sessions
---
> netflix
56d55
< record_tmp
58a58
> recordedmarkup

Well you should definitely have the recordedmarkup table. You can get the SQL to create it from the script used by the installer. Search for a semi-recent post by me that mentions /usr/local/share/knoppmyth/KnoppMyth.sql for details.