[mythtv-users] Record only shows which don't exist in the video database

Thomas Boehm mythtv-users at lists.boehmi.net
Wed Apr 13 12:20:41 UTC 2011

Hi all,

I try to setup a custom rule which should record movies from certain actors, but only if they don't exist in my video database. The first part is quite easy and works, but I'm struggling with the test whether a movie already exists or not. 

I tried the following

(... bla bla ...) AND program.title NOT LIKE videometadata.title

This gives me the following SQL error

There is an error in your custom SQL query:

Unknown column 'videometadata.title' in 'where clause' [#1054]

Is there a way to do this? Obviously I'm not am SQL expert ;-)


More information about the mythtv-users mailing list