search

patrickdemooij9 / SeoToolkit.Umbraco

SeoToolkit is a SEO package for Umbraco 9, 10, 11, 12 & 13. This package features most functionalities needed for your SEO needs like meta fields, sitemap, robots.txt and much more.
MIT License
38 stars 28 forks source link

Error 'no such column: SeoToolkitRedirects.IsEnabled' after upgrading from 3.4.0 to 3.5.0 #265

Open iliyan-kulishev opened 9 months ago

iliyan-kulishev commented 9 months ago

image

image

image

image

grafsnikers commented 9 months ago

I faced the same issue while upgrading my site from Umbraco CMS from 12.0.1 to 12.3.7 and SeoToolkit from 3.3.0 to 3.5.0. It seems that the error happend when you run unattended upgrade.

MarkMcDonald commented 4 months ago

Hitting this also. It looks like there is a migration to add the column in SeoToolkit.Umbraco.Redirects.Core.Migrations.IsEnabledMigration but not seeing the migrations run, and can't see any documentation on the issue.

MarkMcDonald commented 4 months ago

For reference you can manually run the package migrations from https:///umbraco#/packages/packages/installed

There is some documentation here on package creation: https://docs.umbraco.com/umbraco-cms/extending/packages/creating-a-package

SpurguX commented 1 month ago

In my local setup, neither trying to re-run the migrations via the backoffice UI nor deleting the migration records from the local SQLite db solved the issue, so I just created the missing field manually via a db client (DB Browser for SQLite) according to the migration. However, SQLite has no Boolean type field so creating an Integer field is the way.

I wonder if the AsBoolean() calls are failing the migration as SQLite only has Integer fields.