Opened 8 years ago

Closed 7 years ago

#11600 closed Bug Report - General (Won't Fix)

canned_searches.conf.php New Titles Premieres fix for UTC local time comparison

Reported by: mythtv01@… Owned by: Rob Smith
Priority: minor Milestone: unknown
Component: Plugin - MythWeb Version: 0.26
Severity: low Keywords: mythweb canned_searches utc
Cc: Ticket locked: no


The New Titles, Premieres search in mythweb does not find many new titles because in 0.26, the starttime is in UTC but originalairdate is left in local time. So this comparison fails:

         . '     AND DAYOFYEAR(program.originalairdate) ='
         . '         DAYOFYEAR(program.starttime))'

I have hacked my system to wrap a CONVERT_TZ around starttime but my php knowledge is terrible so I don't know how to look up what the correct local timezone conversion should be to supply a real patch. But I can confirm that doing this produces the right data for me, since this is my timezone:

. '     AND DAYOFYEAR(program.originalairdate) ='
. 'DAYOFYEAR(CONVERT_TZ(program.starttime,"GMT","America/Los_Angeles")))'

Change History (1)

comment:1 Changed 7 years ago by Rob Smith

Resolution: Won't Fix
Status: newclosed

Given Mythweb is EOL, I'm closing new features. This should be done via the backend webserver now.

Note: See TracTickets for help on using tickets.