>
> 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.
Is this a MySQL bug? Currently using version 5.0.15.
Dag
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
