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 -- Barry McLarnon VE3JF Ottawa, ON ------------------------------------------------------------------------- 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/
