[mythtv-users] MySQL update problems with mythconverg

[Bob Sully]

On Sun, 23 Jul 2017 12:44:02 -0700, you wrote:

>> Stephen:

<snip>

>>I haven't used the weather feature for some time but do remember
>>setting it up in the past (distinctly remember giving it location 
>> data
>>and which screens to display).  Clicking on it in mythfrontend 
>> doesn't
>>do anything now, and in Setup, there are no available options under
>>Info->Weather, of course.  Would re-installing mythweather generate 
>> the
>>tables in mythconverg?  Right now I can't install anything because of
>>dpkg's issues with mysql-server - but I'm just wondering whether it
>>could solve the weather tables issue.
>>
>>Regarding record_tmp - I have had *zero* problems scheduling and
>r>ecording programs.
>>
>Not sure what to do about the remaining error message ei>>
>>Thanks -
>>Bob


>I have edited a backup of my mother's MythTV database to get the
>structure of your four missing tables.  You can download the file from
>my web server:
>
>http://www.jsw.gen.nz/mythtv/re-create_missing_tables.sql
>
>This is for v0.28.1-38-geef6a48 (latest 0.28-fixes).
>
>I am not sure what creates and updates the tables for the builtin
>modules like weather.  For the optional plugins like music that only
>run in the frontend, it is done by the plugin when mythfrontend is
>run.  If found out all about the music database updates a few versions
>ago when there was a problem with that update and I had to uninstall
>the music plugin in order to do a MythTV version upgrade.  Since
>weather is only in the frontend also, it is likely the same.  Which
>would mean that its database upgrade would not be done by
>mythtv-setup, but by the plugin when mythfrontend is first run after
>the plugin has been upgraded as part of a MythTV version upgrade.


Stephen:  Thanks very much!  Worked great, upgrade completed.  I owe 
you one!!

Trying to configure the weather module in frontend->Setup still doesn't 
work (even after reinstalling the Mythweather package), but not a big 
deal, as I obviously wasn't using it much.  Will wait for the next 
upgrade.

By the way, that other error message was due to a "backup" directory 
containing the mythconverg database from last month, when I upgraded 
Ubuntu to 16.04 from 14.04, and forgot to delete.  Once I deleted it, 
the message went away.

Off-topic - we will be visiting your beautiful country in about six 
weeks (North Island).  Looking forward to it!

Thanks again, very much appreciated!

-- 
_____________________________
Bob