Database problems installing version 4.10

Posted: January 24, 2019 at 5:59 AM Quote #218288
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?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: January 29, 2019 at 7:44 AM Quote #218465
Can someone help me here please. I am completely stuck!
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: February 11, 2019 at 7:40 PM Quote #218850
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..!!
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Please up-vote the answer, if it helpful to you! :)

Cheers,
sk5202
Posted: February 19, 2019 at 3:29 AM Quote #221133
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.
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.