[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