[mythtv-users] Single channel shifting

[Peter Baumgartner]

Finally got my Myth Box up and running. It is really unbelievable, thanks to
all of the contributers and Jarod for the setup.

But...
I am still having issues with one channel not listing in my timezone (3
hours off). I saw a thread listed a while ago about a patch for this (Re:
Per-channel time offset?) has this been updated at all or is it included
now? I was going to try to shift the database myself, but my SQL coding is a
little rusty. This was what I was trying to do...

Mysql> update program
	-> SET starttime = starttime-30000, endtime = endtime-30000
	-> WHERE chanid = 1051;

But, it doesn't work because it tries to create duplicate keys. Is there a
better way?