Revision as of 23:47, 25 August 2013

Starting with MythTV version 0.26, the time zone tables must be loaded
in MySQL. This should be done before attempting the upgrade. mythtv-setup
and mythbackend will not start without the tables loaded and an error
message will apppear in the respective log explaining that.

This is important for users building from source, users loading MythTV from a package,
for example Mythbuntu, should expect the tables to be loaded automatically.

Data too long for column 'Abbreviation' Error

Some users are getting the above message. The solution is to save the output of
the 1st command in a file. Edit the file, search and delete all offending
entries. Then cat that file to the 2nd command. Note that the bad entries
could be on one line or be spread over several. Three line example:

Missing UTC Time Zone

It appears that some distributions do not contain info for the UTC time zone, which seems to be the timezone that mythbackend and mythtv-setup check for before starting. Some distributions may have something called Etc/UTC, but not UTC!