[mythtv-users] MythTV-0.19 and MySQL 5.0.18 Won't play nicely

[John Johnson]

On 25-Feb-2006, at 17:35, Kevin Kuphal wrote:

> John Johnson wrote:
>> Thanks for the reply Kevin. Everything seems to be intact in the
>> program table. The schema for the tables involved are attached below.
>> All the other recording types seem to be working okay. The People
>> Search ones are the only ones it is complaining about.
>>
>>
> Interesting.  If you paste that INSERT query into something like
> phpmyadmin or from mysql command-line, do you get the same error?  I
> don't really see anything wrong with the query syntax or your table
> definition that would generate that error.
>

I just backed up to MySQL 3.23.58 and the same query works just fine.

INSERT INTO recordmatch (recordid, chanid, starttime, manualid)
	SELECT record.recordid, program.chanid, program.starttime,
		IF(search = 5, recordid, 0) FROM record, program, people, credits
			INNER JOIN channel ON (channel.chanid = program.chanid)
				WHERE record.recordid = '4256' AND program.manualid = 0
					AND people.name LIKE 'Julia Louis-Dreyfus'
					AND credits.person = people.person
					AND program.chanid = credits.chanid
					AND program.starttime = credits.starttime
					AND channel.visible = 1
					AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR 
record.type = 10)
					OR  ((record.station = channel.callsign)
					AND   ((record.type = 3)
					OR   ((TIME_TO_SEC(record.starttime) = 
TIME_TO_SEC(program.starttime))
					AND     ((record.type = 2)
					OR     ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime)
					AND       ((record.type = 5)
					OR       ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))
					)       )      )     )    )   )  ) ))

Regards,
   JJ

---
Help everyone. If you can't do that, then at least be nice.