[mythtv-users] Error preparing query: insert into recordmatch (:NR7RECID not being expanded)

Jan Ceuleers jan.ceuleers at gmail.com
Sat Apr 21 11:37:15 UTC 2012


Found/resolved the problem:

Jan Ceuleers wrote:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Column 'title' in where clause is ambiguous

I was using a reference to column title in a power search rule. There 
must have been a recent change to the database schema that caused this 
to become ambiguous, so I had to change this to program.title instead.

Quite obscure; found the solution because I vaguely recognised part of 
the query as a power search rule I created long ago.

Thanks, Jan


More information about the mythtv-users mailing list