Skip to content

Win10+MSSQL cannot insert explicit value for identity column #1141

Description

@jaypoc

Describe the bug
Installation fails on MSSQL Server. UI provides the following error:

insert into [groups] ([createdAt], [id], [isSystem], [name], [pageRules], [permissions], [updatedAt]) output inserted.[id] values (@p0, @p1, @p2, @p3, @P4, @p5, @p6) - Cannot insert explicit value for identity column in table 'groups' when IDENTITY_INSERT is set to OFF.

To Reproduce
Steps to reproduce the behavior:

  1. Follow installation steps 1-5 at: https://docs.requarks.io/en/install/windows

  2. Edit "db" section of config.yml

    host: "127.0.0.1"
    port: 1433
    user: username
    pass: password
    db: wiki
    ssl: false

  3. Run node server

  4. Enter Administrator Email, Password, Confirm Password and Site URL. Disable Telemetry, Click Install

Expected behavior
Installation should succeed.

Screenshots

image

image

Host Info (please complete the following information):

  • OS: Windows 10 (Version 10.0.18362.418)
  • Wiki.js version: Wiki.js 2.0.0-rc.1
  • Database engine Microsoft SQL Server (Tried two servers)
  1. Microsoft SQL Server 2016 Enterprise Edition (64-bit)
  2. Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C)

Additional context
I first attempted the installation on a Hosted SQL Server available to me. Although the issue appeared to be DB related, I suspected it could be due to limited permissions, so I installed SQL Server Express locally as well.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions