Database problems installing version 4.10

I am trying top create a new installation with version 4.10.


When trying to install I initially I got the error: setup failed: Cannot find the object "dbo.QueuedEmail" because it does not exist or you do not have permissions. Indeed, my tables have the name username.etc. not dbo.etc


Using advice on this forum I ran the following script with my correct database and usernames: USE yourDatabase;
ALTER USER [yourUser] WITH DEFAULT_SCHEMA = dbo;



Now I get the error: Setup failed: The property 'Id' on entity type 'Store' has a temporary value while attempting to change the entity's state to 'Unchanged'. Either set a permanent value explicitly or ensure that the database is configured to generate values for this property.



What do I do next, I don't want to keep compounding the problem?

Can someone help me here please. I am completely stuck!

Hello,

I think you used windows authentication.

And your db schema(pool) has not permission of db reader and writer.

So you should first give permission for that.

Again follow your step to installation..!!

Hi, thanks for your response but I solved the issues myself. There were two of them.

Firstly, the appsettings.json file need editing to set UseRowNumberForPaging": true, to give backward compatibility with SQL Server 2008R2

Secondly the default user on the databse needed changing. the database is on the hosting company's server:


USE MYDATABASE;
ALTER USER MYUSER WITH DEFAULT_SCHEMA = dbo;


All is now working.

Slotraccoon wrote:

I have done the same for SQL SERVER 2017 for linux

You must use SA user or any other DBO in order to install nopCommerce properly.