[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