[mythtv-users] Single channel shifting
Peter Baumgartner
pete at northwest-data.com
Thu Mar 4 11:48:49 EST 2004
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?
More information about the mythtv-users
mailing list