[mythtv-users] Mythweb issues after latest upgrade

[Steve Wilson]

--- "Michael T. Dean" <mtdean at thirdcontact.com> wrote:

> On 03/21/2008 09:35 PM, Steve Wilson wrote:
> > Well this fixes the icon issue.
> >
> > http://ubuntuforums.org/showthread.php?t=731007
> >
> > but I'm still having problems with Warning:unknown
> > programs. Oh well, I'll have to wait.
> 
> Did you ever figure out what's different between the
> shows that work and 
> those that don't?  That change you made should not
> be necessary (and 
> shouldn't do anything other than make the preview
> images bigger), so if 
> it is necessary for some, figuring out why (so the
> bug can be fixed, 
> rather than worked around) is important.
> 
> Note, also, that the change you made means all your
> recordings--even 
> 16:9 widescreen recordings--will have 4:3 preview
> images in MythWeb.  
> That's why that change cannot be made in the real
> MythWeb (and why we 
> need to figure out why the proper code, with a 0
> height allowing height 
> to be determined based on aspect ratio, doesn't
> work).
> 
> Thanks,
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
Yeah, I had a feeling it's a crappy work around. I
used phpmyadmin to look at the tables to see if
there's anything glaringly different between the two
recordings that would cause the code to handle each
recording differently and there isn't. However, I'm
surely no php expert. I ran backend with v all and
then went to mythweb the recording then details and
the bad ones give an error and comparing the good and
bad it's a SQL query that falls over.

good:
2008-03-22 00:12:13.263 read  <- 15 49     
QUERY_RECORDING TIMESLOT 2082 2008-02-28T19:00:57
2008-03-22 00:12:13.264 MSqlQuery: SELECT
recorded.chanid,starttime,endtime,title,
subtitle,description,channel.channum,
channel.callsign,channel.name,channel.commmethod,
channel.outputfilters,seriesid,programid,filesize,
lastmodified,stars,previouslyshown,originalairdate,
hostname,recordid,transcoder,playgroup,
recorded.recpriority,progstart,progend,basename,recgroup,
storagegroup FROM recorded LEFT JOIN channel ON
recorded.chanid = channel.chanid WHERE recorded.chanid
= '2082' AND starttime = '2008-02-28T19:00:57' ;
2008-03-22 00:12:13.265 MSqlQuery: SELECT commflagged,
cutlist, autoexpire, editing, bookmark, watched,
preserve FROM recorded LEFT JOIN recordedprogram ON
(recorded.chanid = recordedprogram.chanid AND
recorded.progstart = recordedprogram.starttime) WHERE
recorded.chanid = '2082' AND recorded.starttime =
'2008-02-28T19:00:57' ;
2008-03-22 00:12:13.266 MSqlQuery: SELECT audioprop+0,
videoprop+0, subtitletypes+0 FROM recorded LEFT JOIN
recordedprogram ON (recorded.chanid =
recordedprogram.chanid AND recorded.progstart =
recordedprogram.starttime) WHERE recorded.chanid =
'2082' AND recorded.starttime = '2008-02-28T19:00:57'
;

bad:
2008-03-22 00:13:56.884 read  <- 15 49     
QUERY_RECORDING TIMESLOT 2111 2008-03-21T21:02:00
2008-03-22 00:13:56.885 MSqlQuery: SELECT
recorded.chanid,starttime,endtime,title,
subtitle,description,channel.channum,
channel.callsign,channel.name,channel.commmethod,
channel.outputfilters,seriesid,programid,filesize,
lastmodified,stars,previouslyshown,originalairdate,
hostname,recordid,transcoder,playgroup,
recorded.recpriority,progstart,progend,basename,recgroup,
storagegroup FROM recorded LEFT JOIN channel ON
recorded.chanid = channel.chanid WHERE recorded.chanid
= '2111' AND starttime = '2008-03-21T21:02:00' ;
2008-03-22 00:13:56.885 write -> 15 5       ERROR


      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs