Hi.<br><br><div><span class="gmail_quote">2005/5/2, Michael S. Keller <<a href="mailto:samsara@tulsaconnect.com">samsara@tulsaconnect.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> If someone knows what's happening, please help :)<br><br>Is your recordedmarkup table healthy?<br><br>-M<br></blockquote></div><br>
I don't actually know how to know; however:<br>
<br>
I got 41333 entries:<br>
<br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">mysql> select count(*) from recordedmarkup;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+----------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| count(*) |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+----------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 41333 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+----------+</span><br>
<br>
That look like:<br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">mysql> select * from recordedmarkup limit 10;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+--------+---------------------+-------+--------+------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| chanid | starttime | mark | offset | type |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+--------+---------------------+-------+--------+------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-02-28 23:00:00 | 5074 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 15248 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 15247 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 132 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 133 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 134 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 135 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 636 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1006 | 2005-04-05 22:02:00 | 93418 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1006 | 2005-04-05 22:02:00 | 93417 | NULL | 3 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+--------+---------------------+-------+--------+------+</span><br style="font-family: courier new,monospace;">
<br>
Note that offset=NULL for every row:<br>
<br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">mysql> select count(offset) from recordedmarkup;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+---------------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| count(offset) |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+---------------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 0 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+---------------+</span><br>
<br>
Then, the different "recordings":<br>
<br>
<span style="font-family: courier new,monospace;">mysql> select chanid, starttime, count(*) from recordedmarkup group by chanid, starttime;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+--------+---------------------+----------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| chanid | starttime | count(*) |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+--------+---------------------+----------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-02-23 23:13:00 | 203 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-02-24 00:58:00 | 374 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-03-03 00:58:00 | 616 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-03-10 00:58:00 | 343 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-03-15 22:33:00 | 1563 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-03-17 01:13:00 | 200 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-03-31 00:13:00 | 675 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-04-07 00:58:00 | 527 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-04-10 21:08:00 | 555 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-04-14 00:58:00 | 401 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-04-21 00:28:00 | 756 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1002 | 2005-04-28 00:28:00 | 329 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-12 21:28:00 | 222 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-19 21:28:00 | 147 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-03-26 21:28:00 | 405 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-04-02 21:28:00 | 586 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-04-09 21:28:00 | 313 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-04-16 21:28:00 | 625 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-04-23 21:28:00 | 141 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1003 | 2005-04-30 21:28:00 | 240 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-02-28 21:58:00 | 1058 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-02-28 23:00:00 | 1898 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-03-07 21:58:00 | 1227 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-03-14 21:58:00 | 2913 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-03-21 21:58:00 | 2771 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-03-22 00:00:00 | 944 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-03-28 21:58:00 | 2686 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-03-29 00:00:00 | 1108 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-04-04 21:58:00 | 1224 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-04-11 21:58:00 | 1322 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-04-11 23:00:00 | 1612 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-04-18 21:58:00 | 1329 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-04-18 23:00:00 | 1343 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-04-25 21:58:00 | 611 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-04-25 23:00:00 | 636 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-05-02 21:58:00 | 672 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1004 | 2005-05-02 23:00:00 | 595 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1006 | 2005-04-05 22:02:00 | 6969 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 1006 | 2005-04-12 22:04:00 | 1194 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+--------+---------------------+----------+<br>
<br>
The different types:<br>
<br>
mysql> select type, count(type) from recordedmarkup group by type;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+------+-------------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| type | count(type) |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+------+-------------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| -3 | 38 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 3 | 40983 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 4 | 156 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| 5 | 156 |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+------+-------------+</span><br style="font-family: courier new,monospace;">
<br>
So... how's the patient doing, Doc? :-D<br>
<br>
<br>
Regards, and thanks in advance,<br>
<br>
Juan Jesús.<br>
<br>
<br><br>-- <br>How can dreams come true? Is their type boolean?