[mythtv-users] Mythnews disappears and Music schema update notice

[Ian Evans]

On Wed, Sep 23, 2015 at 1:15 AM, Ian Evans <dheianevans at gmail.com> wrote:

> On Wed, Sep 23, 2015 at 12:21 AM, Ian Evans <dheianevans at gmail.com> wrote:
>
>> Been running Mythnews since I started with Myth in 2011. Running
>> .27-fixes.
>>
>> Tonight, went to check my feeds and News Feeds wasn't in my Information
>> Center at all. I decided to exit and restart the frontend (I'm on a
>> combined FE/BE BTW) and was presented with a message that Myth wanted to
>> upgrade the Music schema from 1000 to 1020. Did I miss something or has my
>> setup gone haywire?
>>
>> Thanks.
>>
>
> after I fired up the frontend again, I checked the log. Seems Myth is
> trying to add fields that already exist. Myhnews is also still not showing
> up:
>
> Sep 23 01:04:30 buster mythfrontend.real: mythfrontend[3090]: I
> CoreContext schemawizard.cpp:118 (Compare) Current MythMusic Schema Version
> (MusicDBSchemaVer): 1000
> Sep 23 01:04:30 buster mythfrontend.real: mythfrontend[3090]: E
> CoreContext dbutil.cpp:604 (DoBackup) Backing up database with script:
> '/usr/share/mythtv/mythconverg_backup.pl'
> Sep 23 01:04:54 buster mythfrontend.real: mythfrontend[3090]: C
> CoreContext dbutil.cpp:625 (DoBackup) Database Backup complete.
> Sep 23 01:04:54 buster mythfrontend.real: mythfrontend[3090]: C
> CoreContext dbutil.cpp:656 (DoBackup) Backed up database to file:
> '/var/lib/mythtv/db_backups/mythconverg-1317-20150923050430.sql.gz'
> Sep 23 01:04:56 buster mythfrontend.real: mythfrontend[3090]: I
> CoreContext bonjourregister.cpp:115 (BonjourCallback) Bonjour: Service
> registration complete: name 'Mythfrontend on buster' type
> '_mythfrontend._tcp.' domain: 'local.'
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: E
> CoreContext main.cpp:685 (mythplugin_init) Couldn't upgrade music database
> schema, exiting.
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: E
> CoreContext mythplugin.cpp:166 (init_plugin) Unable to initialize plugin
> 'mythmusic'.
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: I
> CoreContext mythtranslation.cpp:65 (load) Loading en_us translation for
> module mythnetvision
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: N
> CoreContext dbcheck.cpp:38 (performActualUpdate) Upgrading to MythNews
> schema version 1001
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: E
> CoreContext dbcheck.cpp:53 (performActualUpdate) DB Error (Performing
> database upgrade): #012Query was: ALTER TABLE `newssites` ADD `podcast`
> BOOL NOT NULL DEFAULT '0'; #012
> Error was: Driver error was [2/1060]:#012QMYSQL: Unable to execute
> query#012Database error was:#012Duplicate column name 'podcast'#012 #012new
> version: 1001
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: E
> CoreContext main.cpp:69 (mythplugin_init) Couldn't upgrade database to new
> schema, exiting.
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: E
> CoreContext mythplugin.cpp:166 (init_plugin) Unable to initialize plugin
> 'mythnews'.
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: N
> CoreContext dbcheck.cpp:31 (performActualUpdate) Upgrading to MythWeather
> schema version 1001
> Sep 23 01:05:31 buster mythfrontend.real: mythfrontend[3090]: E
> CoreContext dbcheck.cpp:48 (performActualUpdate) DB Error (Performing
> database upgrade): #012Query was: ALTER TABLE weathersourcesettings ADD
> COLUMN updated TIMESTAMP NOT NU
> LL DEFAULT CURRENT_TIMESTAMP           ON UPDATE CURRENT_TIMESTAMP;
> #012Error was: Driver error was [2/1060]:#012QMYSQL: Unable to execute
> query#012Database error was:#012Duplicate column name 'updated'#012 #012new
> version: 1001
>
>

Looking at this Michael Dean email from 2014, I see the only option may ne
to go back to a database backup from a few days ago before the schema
upgrade attempt:
http://lists.mythtv.org/pipermail/mythtv-users/2014-December/374753.html

May be a terribly obvious question, but what happens to the recording
entries done after the last clean backup? Do I lose those entries? The
timing of this is a real WAF storm...I can't fix this right now and a Law &
Order marathon for the missus starts at 9am.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150923/163a8030/attachment.html>