BootFailedException: Boot failed: Umbraco cannot run
Umbraco is drivig me bonkers at the moment, can't seem to get my local environment working, after updating some Nuget packages I can't get the Umbracs site to launch, the error is below if anybody can shed any light on this. I've tried deleting the solution and pulling down an instance from GitHub, but still no joy, any help would be much appreciated.
An unhandled exception occurred while processing the request.
BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Cms.Core.Exceptions.BootFailedException: SQLite Error 1: 'near "ALTER": syntax error'.
-> Microsoft.Data.Sqlite.SqliteException: SQLite Error 1: 'near "ALTER": syntax error'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Umbraco.Cms.Persistence.Sqlite.Services.SqlitePreferDeferredTransactionsConnection.CommandWrapper.ExecuteNonQuery()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 288
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__32_0()
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass38_0`1.<Execute>b__0()
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func`1 f)
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery()
at NPoco.Database.<>c__DisplayClass296_0.<ExecuteNonQueryHelper>b__0()
at NPoco.Database.ExecutionHook[T](Func`1 action)
at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)
at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)
at NPoco.Database.Execute(Sql Sql)
at NPoco.Database.Execute(String sql, Object[] args)
at SeoToolkit.Umbraco.MetaFields.Core.Migrations.MetaFieldsValueTextMigration.Migrate()
at Umbraco.Cms.Infrastructure.Migrations.MigrationBase.Run()
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.Execute(MigrationPlan plan, String fromState)
at Umbraco.Cms.Core.Migrations.IMigrationPlanExecutor.ExecutePlan(MigrationPlan plan, String fromState)
at Umbraco.Cms.Infrastructure.Migrations.Upgrade.Upgrader.Execute(IMigrationPlanExecutor migrationPlanExecutor, ICoreScopeProvider scopeProvider, IKeyValueService keyValueService)
at Umbraco.Cms.Infrastructure.Install.PackageMigrationRunner.RunPackagePlans(IEnumerable`1 plansToRun)
at Umbraco.Cms.Infrastructure.Install.UnattendedUpgrader.HandleAsync(RuntimeUnattendedUpgradeNotification notification, CancellationToken cancellationToken)
at SeoToolkit.Umbraco.MetaFields.Core.Migrations.MetaFieldsValueTextMigration.Migrate()
Seems to suggest that SeoToolkit on install runs a Migration which perhaps prepares some database tables for it's functionality, and the syntax it's using isn't compatible with SQLLite!
Looking at the SeoToolkit github repository, they have an open ticket with your error in it...
So if you were able to make that change manually and then update the umbracoKeyValue database table to have an entry with a key which I think will be
SeoToolkitMetaFieldsMigration
and the value 'state-2'
then if that is the right key, then I think that would stop the migration running again, and therefore allow you to continue.
But that is the issue, SeoTookit currently has a problem with its migration step on a SqlLite db, which is that 'Alter Column' is not a supported command in SQL Lite.
BootFailedException: Boot failed: Umbraco cannot run
Umbraco is drivig me bonkers at the moment, can't seem to get my local environment working, after updating some Nuget packages I can't get the Umbracs site to launch, the error is below if anybody can shed any light on this. I've tried deleting the solution and pulling down an instance from GitHub, but still no joy, any help would be much appreciated.
When debugging also get this error:
Many thanks in advance
Hi Nick
Looks like an issue with the SeoToolkit package.
This line here in your stack
at SeoToolkit.Umbraco.MetaFields.Core.Migrations.MetaFieldsValueTextMigration.Migrate()
Seems to suggest that SeoToolkit on install runs a Migration which perhaps prepares some database tables for it's functionality, and the syntax it's using isn't compatible with SQLLite!
Looking at the SeoToolkit github repository, they have an open ticket with your error in it...
https://github.com/patrickdemooij9/SeoToolkit.Umbraco/issues/185
So it looks like something they are having a look at.
In the meantime, this is the migration they are trying to run:
https://github.com/patrickdemooij9/SeoToolkit.Umbraco/blob/f2df0d8bad13b3bcc38221dc6c5aa6d5fb710bcf/src/SeoToolkit.Umbraco.MetaFields.Core/Migrations/MetaFieldsValueTextMigration.cs#L5
So if you were able to make that change manually and then update the umbracoKeyValue database table to have an entry with a key which I think will be
SeoToolkitMetaFieldsMigration
and the value 'state-2'
then if that is the right key, then I think that would stop the migration running again, and therefore allow you to continue.
But that is the issue, SeoTookit currently has a problem with its migration step on a SqlLite db, which is that 'Alter Column' is not a supported command in SQL Lite.
regards
Marc '
Thanks Marc,
I just removed the offending SEO package and the site now runs, will wait until they have a fix and try again.
Many thanks for your help
Cheers
Nick
Hi Nick
Good news, looks like a fix is on the way for SEO Toolkit on SQLLite
https://github.com/patrickdemooij9/SeoToolkit.Umbraco/pull/190
regards
Marc
is working on a reply...