LinHES Forums
http://forum.linhes.org/

R5F1 issues: No commercial skip?
http://forum.linhes.org/viewtopic.php?f=6&t=15504		 Page 1 of 1
Author:  ggulik [ Mon Jun 04, 2007 10:06 pm ]
Post subject:  R5F1 issues: No commercial skip?
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.
Image
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]
Author:  cowsr4eating [ Thu Jul 05, 2007 1:16 pm ]
Post subject:  Any resolution?
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.
Author:  ggulik [ Thu Jul 05, 2007 1:21 pm ]
Post subject: 
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.
Author:  cowsr4eating [ Wed Jul 11, 2007 11:28 am ]
Post subject: 
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.
Author:  ggulik [ Wed Jul 11, 2007 12:23 pm ]
Post subject: 
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:
Code:
+--------------------------------+
| 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                        |
| mythweb_sessions               |
| networkiconmap                 |
| newssites                      |
| oldfind                        |
| oldprogram                     |
| oldrecorded                    |
| people                         |
| phonecallhistory               |
| phonedirectory                 |
| pidcache                       |
| playgroup                      |
| profilegroups                  |
| program                        |
| programgenres                  |
| programrating                  |
| recgrouppassword               |
| record                         |
| record_tmp                     |
| recorded                       |
| recordedcredits                |
| 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)
Author:  cowsr4eating [ Wed Jul 11, 2007 5:40 pm ]
Post subject: 
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)
Author:  cowsr4eating [ Wed Jul 11, 2007 7:56 pm ]
Post subject: 
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
Author:  tjc [ Wed Jul 11, 2007 10:51 pm ]
Post subject: 
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.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/