[mythtv-users] the right way to do tuner priority?

[Brian J. Murrell]

On Mon, 2014-09-29 at 09:06 -0700, Karl Newman wrote:
> I know you already found the root of your issue but I wanted to mention
> that the powerpriority rules match against *program* entries, so you
> wouldn't use CURDATE(), you'd use starttime (or possibly program.starttime
> if it's ambiguous). And since all the mythtv times are in UTC, you'd use
> CONVERT_TZ(starttime,'UTC','SYSTEM').

Ahhh.  Thanks!

> So your full powerpriority
> selectclause would look something like this:
> 
> channel.callsign = 'WWNY' AND
> DAYOFWEEK(CONVERT_TZ(starttime,'UTC','SYSTEM')) = 1 AND
> HOUR(CONVERT_TZ(starttime,'UTC','SYSTEM')) BETWEEN 18 AND 23

That produces an error when I try to "Test" it.  But this also produces
an error:

$ echo 'select CONVERT_TZ(CURDATE(),'UTC','SYSTEM');' | mysql -u mythtv -p**** mythconverg
ERROR 1054 (42S22) at line 1: Unknown column 'UTC' in 'field list'

Not sure if that's the same error as MythTV is getting because the error
dialog is not very help either.

Cheers,
b.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140929/cb2f32f8/attachment.sig>