[mythtv-users] Problems with mythweb since atrpms 183 update.

[Richard Shaw]

On Fri, Mar 21, 2008 at 10:31 AM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 03/21/2008 11:11 AM, Richard Shaw wrote:
>  > I can't be sure but this seemed to happen after the 183 update from
>  > atrpms (I'm running F8). Mythweb loads but if I try to go to the
>  > listings page it gives me the header where it shows the currently
>  > browsing and jump to but nothing else. Guide data seems fine in the
>  > EPG. Also, when I try to do a search from the main search I get what
>  > looks like a database error because it can't find 'people.name':
>  >
>  > Fatal Error at /var/www/html/mythweb/objects/Database/Query/mysql.php, line 83:
>  > SQL Error: Unknown column 'people.name' in 'where clause' [#1054]
>
>  Looks like your search.php got updated, but program.php didn't...
>
>
>  > (
>  >     [0] => SELECT program.*,
>  >                          UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
>  >                          UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
>  >                          IFNULL(programrating.system, "") AS rater,
>  >                          IFNULL(programrating.rating, "") AS rating,
>  >                          channel.callsign,
>  >                          channel.channum
>  >                   FROM program
>  >                        LEFT JOIN programrating USING (chanid, starttime)
>  >                        LEFT JOIN channel ON program.chanid = channel.chanid
>  >
>
>  because you're missing:
>
>  LEFT JOIN credits ON (program.chanid = credits.chanid AND
>  program.starttime = credits.starttime)
>  LEFT JOIN people ON (credits.person = people.person)
>
>  I'd say uninstall MythWeb, then delete the MythWeb directory structure,
>  then re-install MythWeb.
>
>  Mike
>  _______________________________________________
>  mythtv-users mailing list
>  mythtv-users at mythtv.org
>  http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

That worked perfectly! Thanks! I had already tried rpm --nodeps -e
mythweb but didn't go and remove the directories...

Richard