[mythtv] mythweb patch: "movies" page, bugfixes

Russell Hatch mythtv-dev@snowman.net
Mon, 9 Dec 2002 12:30:22 -0500

Yeah I modified your code to do just that, to return only programs that are
greater than 70 minutes in length over the next 5 days or so.  I think the
overall layout might need to be changed a little too, since once you get
that movie programs it becomes pretty unwieldy, but thanks for the start at


----- Original Message -----
From: "Grant Taylor" <gtaylor@picante.com>
To: <mythtv-dev@snowman.net>
Sent: Monday, December 09, 2002 11:34 AM
Subject: Re: [mythtv] mythweb patch: "movies" page, bugfixes

> >>>>> mythtv-dev@snowman.net writes:
> > Grant, I'm having a little trouble with your patch.. judging by the
> > query your added fetchListings() function is doing its returning a
> > whole lot of results and its exhausting the default 8M script
> > resource limit set in php.ini.
> > So basically, I was just wondering how it is that it works for you,
> Perhaps the small number of channels I have (25ish) or the fact that I
> only have listings through thursday loaded at the moment.
> The proper fix would be to twiddle the query to return only shows >=
> 70 minutes.  This is what I tried to do in the first place, but mysql
> didn't like having duration, or the unix_time computation it comes
> from, as a subexpression in the WHERE clause.  Perhaps you can concoct
> an expression that mysql will take?
> --
> Grant Taylor - gtaylor@picante.com - http://www.picante.com/~gtaylor/
>   Linux Printing Website and HOWTO:  http://www.linuxprinting.org/
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev@snowman.net
> http://www.snowman.net/mailman/listinfo/mythtv-dev