Giter Site home page Giter Site logo

Comments (7)

tidyui avatar tidyui commented on August 22, 2024

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

from piranha.core.docs.

timgabrhel avatar timgabrhel commented on August 22, 2024

@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.

from piranha.core.docs.

tidyui avatar tidyui commented on August 22, 2024

@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

from piranha.core.docs.

tidyui avatar tidyui commented on August 22, 2024

@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.

from piranha.core.docs.

timgabrhel avatar timgabrhel commented on August 22, 2024

@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

from piranha.core.docs.

tidyui avatar tidyui commented on August 22, 2024

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

from piranha.core.docs.

filipjansson avatar filipjansson commented on August 22, 2024

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

from piranha.core.docs.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.