>
> >
> > That's not what that query looks like... remove the file and re-up svn.
>
> Ok, did that.
>
> The new query with parameters replaced and run from mysql generates the
> following:
>
> mysql> SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
> UNIX_TIMESTAMP(program.endtime) AS endtime_unix, CONCAT(repeat("*",
> program.stars * 4), IF((program.stars * 4 * 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='5' AND program.starttime = FROM_UNIXTIME('1137693600') GROUP
> BY program.chanid, program.starttime ORDER BY program.starttime;
> ERROR 1052 (23000): Column 'chanid' in from clause is ambiguous
> mysql>
>
> I figure this is the problem here but really cannot see the reason for the
> error message.
Well, I think I figured out the reason for the message.
As both program and oldrecorded has their own chanid the poor MySQL
doesn't know which one to join the programrating to.
Now the question is: Why doesn't this happen to everyone?
Is it my for a long tim updated/upgraded database?
Dag
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
