[mythtv] Re: mythweb program listing 'out of memory'.

[Martin Moeller]

I do not have data for channels outside the channel table, but I do have
channels named in the channel table for which I have no data. Mostly
fringe channels, but they're there and I'm paying for them so... :)
I have though about getting them from another source, but have not done
anything like that yet...

The data I get currently is primarily sweding in language (I'm danish
and I can read swedish pretty well, but danish is better, naturally :))

We have another good source of TV material, but no grabber exists for
it: http://tv.tv2.dk - if you choose 'TV Guide' you will get a nice list
of channels (and probably not understand too much of the titles but
that's ok). If i get the time and skill, I might try to make an xmltv
grabber for this source, but that is probably quite a ways off yet...

The result of your query:
mysql> select count(*) as 'this value should be zero'
    ->         from program left join channel using (chanid)
    ->         where isnull(channum);
+---------------------------+
| this value should be zero |
+---------------------------+
|                         0 |
+---------------------------+
1 row in set (0.01 sec)

I love mythtv/mythweb though, and I seem to have a workable solution to
my problem now. If movies could also work, even in a limited way, that
would be *very* nice. The bychannel view is very nice, I must say... :o)

søn, 2003-03-16 kl. 18:17 skrev Andy Davidoff:
> 'order by channum + 0' is a clause of a 'select'ion query which defines
> how to order the result; it is not a value.  When it's present in your
> query, the channelarray lines up with the program listing properly.  When
> it's altered to order the result by the chanid, then things get screwy.
> 
> This is expected.  The while loop on cvs/mythweb/functions.php:418 handles
> skipping channels for which we've already retrieved program data; eg. the
> 2nd half-hour of a one-hour program.  This loop requires the order of the
> channelarray to match that of the query result.
> 
> Do you have data in your program table for channels which do not exist in
> your channel table?  Try this:
> 
> 	select count(*) as 'this value should be zero'
> 	from program left join channel using (chanid)
> 	where isnull(channum);
> 
> 
> #if Martin Moeller /* Mar 16, 16:25 */
> > On looking it over, it seems that 'order by channum + 0' is recurring
> > quite a bit? Perhaps the value should be grabbed from the database (also
> > making me not have to update functions all the time :))
> #endif /* martin at martinm-76.dk */
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at snowman.net
> http://www.snowman.net/mailman/listinfo/mythtv-dev
-- 
Martin Moeller <martin at martinm-76.dk>