[mythtv-users] Latest bugfixes break timezone in 0.27
Bill Meek
keemllib at gmail.com
Sat Nov 16 22:04:03 UTC 2013
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.)
--
Bill
More information about the mythtv-users
mailing list