[mythtv] [mythtv-commits] mythtv commit: r8887 - in trunk/mythplugins/mythweb by xris

[Pekka Jääskeläinen]

> Is this restricted to mythweb TV listings, or do you also see it in
> mythweb "Upcoming Recordings", etc.?

Yes, it's restricted to mythweb TV listings. They are not visible in
"Upcoming Recordings".

> To help debug this, please attach the output of a sample listing that
> is not really "recorded" (as an attachment, please, not inlined into
> the e-mail):

Attached is the output of following query:

SELECT *
FROM program,channel
WHERE program.chanid = channel.chanid
      AND lower(program.title) = 'historian huoneissa' AND
program.starttime = '2006-02-08 20:00:00'
      AND useonairguide = 1
LIMIT 1;

That's an example of a program visible as 'the program is recorded' even though
it isn't. HTH.

> I am interested in the 'programid' and 'seriesid' values for
> EIT-filled records.

Those columns are empty strings, it seems:

SELECT programid, seriesid
FROM program,channel
WHERE program.chanid = channel.chanid
      AND lower(program.title) = 'historian huoneissa' AND
program.starttime = '2006-02-08 20:00:00'
      AND useonairguide = 1
LIMIT 1;

Results in:

+-----------+----------+
| programid | seriesid |
+-----------+----------+
|           |          |
+-----------+----------+

> If you are feeling less adventurous, simply revert your mythweb back
> to [8886].

Alright, I'll try the fix later. I can live with the bug for now...

--
--PJ
-------------- next part --------------
+--------+---------------------+---------------------+---------------------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+--------+---------+--------+----------+----------+---------+------+----------+--------------+------------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+
| chanid | starttime           | endtime             | title               | subtitle | description                                                                                                                                                                                                                                  | category                   | category_type | airdate | stars | previouslyshown | title_pronounce | stereo | subtitled | hdtv | closecaptioned | partnumber | parttotal | seriesid | originalairdate | showtype | colorcode | syndicatedepisodenumber | programid | manualid | generic | chanid | channum | freqid | sourceid | callsign | name    | icon | finetune | videofilters | xmltvid    | recpriority | contrast | brightness | colour | hue   | tvformat | commfree | visible | outputfilters | useonairguide | mplexid | serviceid | atscsrcid |
+--------+---------------------+---------------------+---------------------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+--------+---------+--------+----------+----------+---------+------+----------+--------------+------------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+
|   1006 | 2006-02-08 20:00:00 | 2006-02-08 20:28:00 | Historian huoneissa |          | Osa 1/8. Helsingin rautatieasema. Professori Matti Klinge opastaa meidÀt matkalle venÀlÀiseen sotilassairaalaan, Suomen ensimmÀisen jÀÀtelökoneen luo ja presidentti Kallion viimeisiin hengenvetoihin. Tekstitys Teksti-tv:n s. 333. | Social/Policical/Economics | tvshow        |    2006 |     0 |               0 |                 |      1 |         0 |    0 |              0 |          0 |         0 |          | NULL            |          |           |                         |           |        0 |       0 |   1006 | 1       |        |        1 | YLE TV1  | YLE TV1 | none |        0 |              | 1.katso.fi |           0 |    32768 |      32768 |  32768 | 32768 | Default  |        1 |       1 |               |             1 |       3 |        17 |         0 |
+--------+---------------------+---------------------+---------------------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+---------------+---------+-------+-----------------+-----------------+--------+-----------+------+----------------+------------+-----------+----------+-----------------+----------+-----------+-------------------------+-----------+----------+---------+--------+---------+--------+----------+----------+---------+------+----------+--------------+------------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+