Opened 12 years ago

Closed 12 years ago

#11342 closed Bug Report - General (Works for me)

mythweb recording download not working anymore

Reported by: martin.ereth@… Owned by: Rob Smith
Priority: minor Milestone: 0.26.1
Component: Plugin - MythWeb Version: 0.26
Severity: medium Keywords: mythweb recording download timezone
Cc: Ticket locked: no

Description

Due to timezone changes from 0.25 to 0.26 I am not able to download recordings in mythweb any more.

mythweb/modules/stream/tv.pl is not able to find the recording by SELECTing with chanid and starttime from DB because starttime is in local time and DB time is in UTC.

This is what I have done to get it going again: 

mythweb/modules/stream/tv.pl, line 29
- WHERE starttime=FROM_UNIXTIME(?)
+ WHERE starttime=CONVERT_TZ(FROM_UNIXTIME(?), \'Europe/Berlin\', \'UTC\')

Maybe a dev is able to change this thing so that it works for all users?

Change History (1)

comment:1 Changed 12 years ago by Raymond Wagner

Priority: major → minor
Resolution: → Works for me
Status: new → closed
Type: Bug Report - Hang/Deadlock → Bug Report - General

Works fine here, at least on developmental 0.27. Perhaps you have an old version of something installed?

Note: See TracTickets for help on using tickets.