1690 update won't start - SQLite error

Looks like 1690 was picked up yesterday, now the service is failing to start. Any suggestions?
Windows 8.1 x64

14-7-24 07:12:51.2|Fatal|ConsoleApp|EPIC FAIL!

System.Exception: SQL logic error or missing database
duplicate column name: SortTitle
While Processing:
"ALTER TABLE "Series" ADD COLUMN "SortTitle" TEXT" ---> System.Data.SQLite.SQLiteException: SQL logic error or missing database
duplicate column name: SortTitle
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at FluentMigrator.Runner.Processors.Sqlite.SqliteProcessor.ExecuteNonQuery(String sql) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\Processors\Sqlite\SqliteProcessor.cs:line 147
   --- End of inner exception stack trace ---
   at FluentMigrator.Runner.Processors.Sqlite.SqliteProcessor.ExecuteNonQuery(String sql) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\Processors\Sqlite\SqliteProcessor.cs:line 151
   at FluentMigrator.Runner.Processors.Sqlite.SqliteProcessor.Process(String sql) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\Processors\Sqlite\SqliteProcessor.cs:line 135
   at FluentMigrator.Runner.Processors.ProcessorBase.Process(CreateColumnExpression expression) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\Processors\ProcessorBase.cs:line 70
   at FluentMigrator.Expressions.CreateColumnExpression.ExecuteWith(IMigrationProcessor processor) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator\Expressions\CreateColumnExpression.cs:line 53
   at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass18.<ExecuteExpressions>b__15() in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\MigrationRunner.cs:line 379
   at FluentMigrator.Runner.StopWatch.Time(Action action) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\StopWatch.cs:line 57
   at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\MigrationRunner.cs:line 392
   at FluentMigrator.Runner.MigrationRunner.ExecuteMigration(IMigration migration, Action`2 getExpressions) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\MigrationRunner.cs:line 348
   at FluentMigrator.Runner.MigrationRunner.ApplyMigrationUp(IMigrationInfo migrationInfo, Boolean useTransaction) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\MigrationRunner.cs:line 226
   at FluentMigrator.Runner.MigrationRunner.MigrateUp(Boolean useAutomaticTransactionManagement) in c:\Community\tommarien\fluentmigrator\src\FluentMigrator.Runner\MigrationRunner.cs:line 109
   at NzbDrone.Core.Datastore.Migration.Framework.MigrationController.MigrateToLatest(String connectionString, MigrationType migrationType) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 47
   at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Datastore\DbFactory.cs:line 69
   at NzbDrone.Core.Datastore.DbFactory.RegisterDatabase(IContainer container) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Datastore\DbFactory.cs:line 31
   at NzbDrone.Host.Bootstrap.Start(ApplicationModes applicationModes, StartupContext startupContext) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Host\Bootstrap.cs:line 72
   at NzbDrone.Host.Bootstrap.Start(StartupContext startupContext, IUserAlert userAlert, Action`1 startCallback) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Host\Bootstrap.cs:line 41
   at NzbDrone.Console.ConsoleApp.Main(String[] args) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Console\ConsoleApp.cs:line 19

I manually removed the existing “SortTitle” field from the table and was able to start. Not sure what happened… My almost duplicate install on Ubuntu worked without issue.

The migration must have failed and left the DB in an inconsistent state. Thanks for the info, we’ll see what we can do to prevent this.