Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Nick 84 posts 451 karma points
    May 09, 2023 @ 22:42
    Nick
    1

    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)
    

    When debugging also get this error:

    enter image description here

    Many thanks in advance

  • Marc Goodson 2141 posts 14344 karma points MVP 8x c-trib
    May 10, 2023 @ 08:34
    Marc Goodson
    100

    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 '

  • Nick 84 posts 451 karma points
    May 10, 2023 @ 18:08
    Nick
    0

    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

  • Marc Goodson 2141 posts 14344 karma points MVP 8x c-trib
    May 11, 2023 @ 09:16
    Marc Goodson
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft