id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 4563 Scheduler ambiguous SQL query with certain custom recording rules taco_mel@… Janne Grunau "I had occasion to write a custom ""power search"" query that includes a table containing a column called 'recordid', and this makes the 'recordid' of the resulting query ambiguous. Here's what was run within MySQL: INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime, IF(search = 5, '''recordid''', 0) FROM (record, program INNER JOIN channel ON channel.chanid = program.chanid)... A patch for scheduler.cpp is attached to qualify that with the appropriate table name." defect closed minor 0.21 mythtv head medium fixed mythbackend scheduler power search 0