[mythtv-users] Database upgrading failed after update to .27

[Captain Hook]

I attempted to update to .27 from .26.  It seems to have updated, however,
I could not access any recordings from a frontend (complaining about
database version) and then I noticed that Mythweb wasn't working either
(blank screen).

I then logged into my backend and tried to open MythTV Backend Setup, only
to receive a white screen for 5-10 seconds, followed by a message that says
MythTV needs to upgrade database for my TV schema, from 1315 to 1317.  If I
select upgrade, it tells me a location of a backup file if the system
becomes unstable, and then quickly closes, then asks me if I want to start
the backend.  I enter my password, it then asks about mythfilldatabase.

It still doesn't work, and upon subsequent launches of MythTV Backend
Setup, I am prompted with the same questions, so it isn't upgrading.

When I look at mythsetup.log, I have this:

Sep  8 14:20:43 MythTV mythtv-setup.real: mythtv-setup[4299]: I CoreContext
schemawizard.cpp:118 (Compare) Current MythTV Schema Version (DBSchemaVer):
1315
Sep  8 14:20:43 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext
dbutil.cpp:604 (DoBackup) Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
Sep  8 14:20:49 MythTV mythtv-setup.real: mythtv-setup[4299]: C CoreContext
dbutil.cpp:625 (DoBackup) Database Backup complete.
Sep  8 14:20:49 MythTV mythtv-setup.real: mythtv-setup[4299]: C CoreContext
dbutil.cpp:656 (DoBackup) Backed up database to file:
'/var/lib/mythtv/db_backups/mythconverg-1315-20130908182043.sql.gz'
Sep  8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: C CoreContext
dbcheck.cpp:402 (performActualUpdate) Upgrading to MythTV schema version
1316
Sep  8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext
dbcheck.cpp:417 (performActualUpdate) DB Error (Performing database
upgrade): #012Query was: ALTER TABLE program ADD INDEX title_subtitle_start
(title, subtitle, starttime); #012Error was: Driver error was
[2/1061]:#012QMYSQL: Unable to execute query#012Database error
was:#012Duplicate key name 'title_subtitle_start'#012 #012new version: 1316
Sep  8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext
dbcheck.cpp:502 (UpgradeTVDatabaseSchema) Database schema upgrade failed.
Sep  8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext
main.cpp:553 (main) Couldn't upgrade database to new schema.


Before I restore my snapshot of my backend, any thoughts on a quick fix?
 Fall TV season is around the corner and I don't want to mess with this too
much.

Thanks for any assistance provided.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130908/42c9f623/attachment.html>