<div dir="ltr">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).<div>
<br></div><div>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.</div>
<div><br></div><div>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.</div><div><br></div><div>When I look at mythsetup.log, I have this:</div>
<div><br></div><div><div>Sep 8 14:20:43 MythTV mythtv-setup.real: mythtv-setup[4299]: I CoreContext schemawizard.cpp:118 (Compare) Current MythTV Schema Version (DBSchemaVer): 1315</div><div>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/<a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a>'</div>
<div>Sep 8 14:20:49 MythTV mythtv-setup.real: mythtv-setup[4299]: C CoreContext dbutil.cpp:625 (DoBackup) Database Backup complete.</div><div>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'</div>
<div>Sep 8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: C CoreContext dbcheck.cpp:402 (performActualUpdate) Upgrading to MythTV schema version 1316</div><div>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</div>
<div>Sep 8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext dbcheck.cpp:502 (UpgradeTVDatabaseSchema) Database schema upgrade failed.</div><div>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.</div>
</div><div><br></div><div><br></div><div>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.</div><div><br></div><div>
Thanks for any assistance provided.</div></div>