[mythtv-users] Jumping to end of show

Juan Jesús García de Soria Lucena skandalfo at gmail.com
Tue May 3 00:07:14 UTC 2005


Hi.

2005/5/2, Michael S. Keller <samsara at tulsaconnect.com>:
> 
> > 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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20050503/9effd481/attachment.htm


More information about the mythtv-users mailing list