[mythtv] Trouble playing back recordings from remote frontend

[Joe Doucette]

On 10/3/07, Kevin Kuphal <kuphal at dls.net> wrote:
>
>
> What happens if you manually execute the SQL against the DB from either
> the command-line or something like phpmyadmin?
>
> SELECT basename FROM recorded WHERE chanid = '1039' AND       starttime =
> '2007-10-03T17:30:00';
>
> Kevin
>


Hmm -- interesting...empty set. I guess that explains that.

mysql> SELECT basename FROM recorded WHERE chanid = '1039' AND
starttime =
 '2007-10-03T17:30:00';
Empty set (0.00 sec)

mysql> SELECT basename FROM recorded WHERE chanid = '1039';
+-------------------------+
| basename                |
+-------------------------+
| 1039_20070928200000.mpg |
| 1039_20070928210000.mpg |
| 1039_20070929020000.mpg |
| 1039_20070929220000.mpg |
| 1039_20071003093000.mpg |
| 1039_20071003120000.mpg |
| 1039_20071003123000.mpg |
| 1039_20071003190000.mpg |
| 1039_20071003193000.mpg |
+-------------------------+
9 rows in set (0.00 sec)

mysql>

So I noticed getting into myth that the clock was a couple hours off....and
there's a recording on that channel a couple hours off from the intended
time. Turns out the timezone on the frontend was set to mountian time, while
my backend was set to eastern. Correcting the timezone on the frontend fixed
things up.

...so for any future puzzled searchers, another cause of this message is
apparently disagreeing timezones between the front and back end. I'm
guessing there aren't too many folks whose configuration spans time
zones....

Thanks!

    - Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20071003/59cce223/attachment.htm