Hi there! Have you changed packages to target SQLServer? You need to change both the data package as well as the Identity package! See this page for reference:

https://piranhacms.org/docs/architecture/databases/sql-server

Best regards

@tidyui Yes, sorry, I forgot to mention. I installed both packages as the necessary types for SQL EF and SQL Identity aren't already present. I did not uninstall any packages, only added the two referenced on this page.

@timgabrhel I actually also missed that you were running on master and not the current packages 😁 Master is our development branch and might not be stable. The SiteLogo field is new for 8.4 and we probably haven’t had time to create the migration for SQLServer yet!

If you’re happy with the 8.3 functionality you can find the latest stable release in the version branch!

Best regards

Håkan

@filipjansson Can you take a look at this when you get the time. It looks like you have already created the migration for SQLServer but it doesn't appear to be executing correctly.

@tidyui Might I suggest some guidance of this note, perhaps under this section.
https://github.com/PiranhaCMS/piranha.core#get-the-latest-source-code-and-get-going

Yes good idea! I’ll rename this issue and move it to the documentation repo!

Hi!

I tried to reproduce this behavior but without success.
All the migration run and all the columns is in place.

What I did notice is that your EFMigrationHistory table is missing one migration from the Piranha.AspNetCore.Identity.SQLServer package, the initial migration called 20180516203540_InitialCreate.

My startup:

services.AddPiranha(options =>
{
    options.AddRazorRuntimeCompilation = true;

    options.UseFileStorage(naming: FileStorageNaming.UniqueFolderNames);
    options.UseImageSharp();
    options.UseManager();
    options.UseTinyMCE();
    options.UseMemoryCache();

    options.UseEF<SQLServerDb>(db =>
        db.UseSqlServer("Data source=.\\sqlexpress;initial catalog=piranha;Integrated Security=True;multipleactiveresultsets=true;"));
    options.UseIdentityWithSeed<IdentitySQLServerDb>(db =>
        db.UseSqlServer("Data source=.\\sqlexpress;initial catalog=piranha;Integrated Security=True;multipleactiveresultsets=true;"));

    options.UseSecurity(o =>
    {
        o.UsePermission("Subscriber");
    });
});

BR
Filip