2005/5/2, Michael S. Keller <[EMAIL PROTECTED]>:
> If someone knows what's happening, please help :)
Is your recordedmarkup table healthy?
-M
I don't actually know how to know; however:
I got 41333 entries:
mysql> select count(*) from recordedmarkup;
+----------+
| count(*) |
+----------+
| 41333 |
+----------+
That look like:
mysql> select * from recordedmarkup limit 10;
+--------+---------------------+-------+--------+------+
| chanid | starttime | mark | offset | type |
+--------+---------------------+-------+--------+------+
| 1004 | 2005-02-28 23:00:00 | 5074 | NULL | 3 |
| 1003 | 2005-03-26 21:28:00 | 15248 | NULL | 3 |
| 1003 | 2005-03-26 21:28:00 | 15247 | NULL | 3 |
| 1003 | 2005-03-26 21:28:00 | 132 | NULL | 3 |
| 1003 | 2005-03-26 21:28:00 | 133 | NULL | 3 |
| 1003 | 2005-03-26 21:28:00 | 134 | NULL | 3 |
| 1003 | 2005-03-26 21:28:00 | 135 | NULL | 3 |
| 1003 | 2005-03-26 21:28:00 | 636 | NULL | 3 |
| 1006 | 2005-04-05 22:02:00 | 93418 | NULL | 3 |
| 1006 | 2005-04-05 22:02:00 | 93417 | NULL | 3 |
+--------+---------------------+-------+--------+------+
Note that offset=NULL for every row:
mysql> select count(offset) from recordedmarkup;
+---------------+
| count(offset) |
+---------------+
| 0 |
+---------------+
Then, the different "recordings":
mysql> select chanid, starttime, count(*) from recordedmarkup group by chanid, starttime;
+--------+---------------------+----------+
| chanid | starttime | count(*) |
+--------+---------------------+----------+
| 1002 | 2005-02-23 23:13:00 | 203 |
| 1002 | 2005-02-24 00:58:00 | 374 |
| 1002 | 2005-03-03 00:58:00 | 616 |
| 1002 | 2005-03-10 00:58:00 | 343 |
| 1002 | 2005-03-15 22:33:00 | 1563 |
| 1002 | 2005-03-17 01:13:00 | 200 |
| 1002 | 2005-03-31 00:13:00 | 675 |
| 1002 | 2005-04-07 00:58:00 | 527 |
| 1002 | 2005-04-10 21:08:00 | 555 |
| 1002 | 2005-04-14 00:58:00 | 401 |
| 1002 | 2005-04-21 00:28:00 | 756 |
| 1002 | 2005-04-28 00:28:00 | 329 |
| 1003 | 2005-03-12 21:28:00 | 222 |
| 1003 | 2005-03-19 21:28:00 | 147 |
| 1003 | 2005-03-26 21:28:00 | 405 |
| 1003 | 2005-04-02 21:28:00 | 586 |
| 1003 | 2005-04-09 21:28:00 | 313 |
| 1003 | 2005-04-16 21:28:00 | 625 |
| 1003 | 2005-04-23 21:28:00 | 141 |
| 1003 | 2005-04-30 21:28:00 | 240 |
| 1004 | 2005-02-28 21:58:00 | 1058 |
| 1004 | 2005-02-28 23:00:00 | 1898 |
| 1004 | 2005-03-07 21:58:00 | 1227 |
| 1004 | 2005-03-14 21:58:00 | 2913 |
| 1004 | 2005-03-21 21:58:00 | 2771 |
| 1004 | 2005-03-22 00:00:00 | 944 |
| 1004 | 2005-03-28 21:58:00 | 2686 |
| 1004 | 2005-03-29 00:00:00 | 1108 |
| 1004 | 2005-04-04 21:58:00 | 1224 |
| 1004 | 2005-04-11 21:58:00 | 1322 |
| 1004 | 2005-04-11 23:00:00 | 1612 |
| 1004 | 2005-04-18 21:58:00 | 1329 |
| 1004 | 2005-04-18 23:00:00 | 1343 |
| 1004 | 2005-04-25 21:58:00 | 611 |
| 1004 | 2005-04-25 23:00:00 | 636 |
| 1004 | 2005-05-02 21:58:00 | 672 |
| 1004 | 2005-05-02 23:00:00 | 595 |
| 1006 | 2005-04-05 22:02:00 | 6969 |
| 1006 | 2005-04-12 22:04:00 | 1194 |
+--------+---------------------+----------+
The different types:
mysql> select type, count(type) from recordedmarkup group by type;
+------+-------------+
| type | count(type) |
+------+-------------+
| -3 | 38 |
| 3 | 40983 |
| 4 | 156 |
| 5 | 156 |
+------+-------------+
So... how's the patient doing, Doc? :-D
Regards, and thanks in advance,
Juan Jes�s.
--
How can dreams come true? Is their type boolean?
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
