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

Sun Sep 8 20:11:03 UTC 2013

On 8 September 2013 14:34, Captain Hook <captainhookzero at gmail.com> wrote:

> 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.

looks like you had earlier attempted an upgrade and somehow screwed up
your database schema...
did you run any command touching the mysql database ?