Database Update Error (Refresh 30.0)

2024/12/18 7:14 PM

Environment

  • Xperience by Kentico version: [30.0.0]

After updating my nuget packages to version 30.0 and rebuilding. Im getting the following error when running the database update command ()

Answers

2024/12/18 8:13 PM

Are there any nuget packages that depend on an older version of Kentico.Xperience.* ?

I know a lot of things 'broke' in 30 for extensions and such, I had to rebuild most of mine.

The other thing to check is, is the appsettings.json found in your BIN folder pointing to the right database, as when you rebuild it copies the "appsettings.json" but NOT the "appsettings.json.development" or any sub settings.

2024/12/23 6:02 PM

Have you attempted to run that query manually against the not-yet-upgraded database to see if it fails and results in an error?

If your project successfully builds then I don't think this is related to NuGet packages. When you use --kxp-update, only Xperience's update logic runs, not any external custom code.

  1. What version of SQL Server are you using?
  2. What version of Xperience are you upgrading from?
  3. How recently did you run a CI Restore before updating your NuGet packages? I'm wondering if your database is in an invalid state and CI Restore can identify this issue.

To answer this question, you have to login first.