Re: [Mvpmc-devel] commskip update plus more
Status: Alpha
Brought to you by:
gettler
From: Michael D. <md...@ya...> - 2007-10-29 19:37:19
|
--- Scott Harris <mv...@we...> wrote: > Quoting Michael Drons <md...@ya...>: > > > > > The DB query would be this to pull the break > starts: > > > > SELECT mark, type FROM recordedmarkup WHERE chanid > = > > '2008' AND starttime = '2007-10-24T018:00:00' AND > type > > = 4 ORDER BY mark; > > > > To pull the break ends, change the type to 5. > > > > Here are the steps to do this from the command > line > > > > bash# mysql -u username -p password <enter> > > mysql> connect mythconverg; > > mysql> select statement from above > > > > mysql> SELECT mark, type FROM recordedmarkup WHERE > > chanid = '1024' AND starttime = > '2007-10-29T09:30:00' > > AND type = 4 ORDER BY mark; > > +-------+------+ > > | mark | type | > > +-------+------+ > > | 1 | 4 | > > | 45030 | 4 | > > | 52238 | 4 | > > +-------+------+ > > 3 rows in set (0.00 sec) > > > > Let me know what you find. > > > > Cool, thanks, much easier than going through the > code. > Here are the two examples we've been working with. > > SELECT mark, type FROM recordedmarkup WHERE chanid = > '2008' AND > starttime = '2007-10-24T18:00:00' AND type = 4 ORDER > BY mark; > +-------+------+ > | mark | type | > +-------+------+ > | 24804 | 4 | > | 34897 | 4 | > +-------+------+ > 2 rows in set (0.00 sec) > > mysql> SELECT mark, type FROM recordedmarkup WHERE > chanid = '2008' AND > starttime = '2007-10-24T18:00:00' AND type = 5 ORDER > BY mark; > +-------+------+ > | mark | type | > +-------+------+ > | 29351 | 5 | > | 46575 | 5 | > +-------+------+ > 2 rows in set (0.00 sec) > > ------------------------------------ > SELECT mark, type FROM recordedmarkup WHERE chanid = > '2008' AND > starttime = '2007-10-26T18:00:00' AND type = 4 ORDER > BY mark; > +-------+------+ > | mark | type | > +-------+------+ > | 19244 | 4 | > | 31284 | 4 | > | 40134 | 4 | > +-------+------+ > 3 rows in set (0.00 sec) > > mysql> SELECT mark, type FROM recordedmarkup WHERE > chanid = '2008' AND > starttime = '2007-10-26T18:00:00' AND type = 5 ORDER > BY mark; > +-------+------+ > | mark | type | > +-------+------+ > | 23811 | 5 | > | 35868 | 5 | > | 45402 | 5 | > +-------+------+ > 3 rows in set (0.00 sec) > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet > Messaging Program. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? > Stop. > Now Search log events and configuration files using > AJAX and a browser. > Download your FREE copy of Splunk now >> > http://get.splunk.com/ > _______________________________________________ > Mvpmc-devel mailing list > Mvp...@li... > https://lists.sourceforge.net/lists/listinfo/mvpmc-devel > OK so that tells us that the commbreaks are in the database. If mvpmc is reporting zero when you select the show, we need to investigate why. Can you enable myth debug on the mvpmc and send the log file to me. add a -M to the command line in the config and reboot. then send me the log file. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |