[mythtv-users] Latest bugfixes break timezone in 0.27

Steve Greene sgreene59 at verizon.net
Sat Nov 16 22:32:18 UTC 2013


On Sat, 2013-11-16 at 16:04 -0600, Bill Meek wrote:
> On 11/16/2013 03:52 PM, Steve Greene wrote:
> ...
>  > This problem did materialize with today's 0.27-fixes.
> >
> >  From mysql command line:
> > mysql> SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');
> > +----------------------------------------+
> > | CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') |
> > +----------------------------------------+
> > | NULL                                   |
> > +----------------------------------------+
> > 1 row in set (0.00 sec.)
> >
> > Last two lines of mythbackend.log:
> > Nov 16 15:19:07 bilbo mythbackend: mythbackend[3334]: N CoreContext
> > mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults
> > from /usr/share/mythtv//locales/en_us.xml
> > Nov 16 15:19:07 bilbo mythbackend: mythbackend[3334]: E CoreContext
> > main_helpers.cpp:547 (run_backend) MySQL time zone support is missing.
> > Please install it and try again.  See 'mysql_tzinfo_to_sql' for
> > assistance.
> >
> > Full mythbackend.log at http://pastebin.com/nGN1B5MN.
> >
> 
> You're right, this did it.
> 
> commit c6836330ca9b3242af58b247e8a2d28bf6c9da51
> Date:   Sun Jul 28 17:36:23 2013 -0400
> 
> code.mythtv.org/trac/changeset/c68363
> 
> The 'fix' is at the end of the Wiki (although you have to change
> the 2 instances of 'UTC' to 'Etc/UTC' because it's for 0.26.)

Thanks, Bill.

That did it!

Steve




More information about the mythtv-users mailing list