Quoting Barry McLarnon <[EMAIL PROTECTED]>: > On Sunday 30 March 2008 16:53, Barry McLarnon wrote: >> > The SQL query ran by mvpmc top retrieve the commercial break list >> > was posted to the developers list a while back. Hunt down that >> > message and try running the query manually from a MySQL client. >> >> Thanks - I'll pursue that and see where it leads me. A munged >> database seems to be the only logical explanation for this >> weirdness. > > Well, I've tried connecting to the mythconverg database with an SQL > browser, and I have no problem pulling out the commercial break data > for the same recordings for which mvpmc reports "Found 0 commercial > breaks for current program." The number of breaks in the database > matches the mythcommflag reports in the backend log. So, it seems > that the database is okay... what now? > > Barry >
I fought with commercial skip for a long time, wasting a lot of people's time in the process ;) The end problem turned out to be the time format on the mvpmc. Even though the time was displayed as right, the time zone was incorrect. So when it went to do the lookups it always looked at the wrong time slot. Scott ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Mvpmc-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mvpmc-users mvpmc wiki: http://mvpmc.wikispaces.com/
