[mythtv-users] Mythweb problem

[Chris Petersen]

> Anyway I am very close to a solution now.
> Down in programs.php the SQL produced in load_all_program_data() is bogus
> it contains 4 "?" marks and the query is only passed 3 parameters. I told PHP 
> to
> print the SQL statement in my case and got:
> query = SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS starttime_unix, 
> UNIX_TIMESTAMP(program.endtime) AS endtime_unix, CONCAT(repeat(?, 
> program.stars * ?), IF((program.stars * ? * 10) % 10, "?", "")) AS starstring, 
> IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS 
> rating, oldrecorded.recstatus FROM program LEFT JOIN oldrecorded USING 
> (seriesid, programid) LEFT JOIN programrating USING (chanid, starttime) WHERE 
> program.chanid='30' AND program.starttime = FROM_UNIXTIME('1137685500') GROUP 
> BY program.chanid, program.starttime ORDER BY program.starttime
> 
> The substituting parameters in the query are:
> star_character, max_stars, max_stars

That's not what that query looks like...  remove the file and re-up svn.

-Chris