Nop commerce Data base installation error in 2.20

Sir,

I have serveral problems to create data base on web server. i tried several method to Install this version .All process has 95 % success.

method 1

Installing db on server using Initial Installation process. ie,  /install page.

Then the db created on my sql server. But I have a problem in that method. That is, I got home page, Innerpage, admin page etc. When I add a new Product , then there will occur error. I also tried to copy your product option.Then I add a new product. When I goes through home page there will no error , but In the Inner page redirects ErrorPage.htm
page. But, I can access your existing data through the inner page. But  I added product would redirect. This is the first method issue.

method 2

First I create sdf database locally on my APP_Data folder. Then I migrate this nop_db.sdf to our sql server 2008. The mirgation success and I got the full tables on the sql server data base.When I run the site, I will get the following error.


Server Error in '/' Application.
Invalid column name 'IsSystemRole'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'IsSystemRole'.

Source Error:

Line 801:                            where cr.SystemName == systemName
Line 802:                            select cr;
Line 803:                var customerRole = query.FirstOrDefault();
Line 804:                return customerRole;
Line 805:            });


Source File: c:\Users\admin\Desktop\2.20\Libraries\Nop.Services\Customers\CustomerService.cs    Line: 803

Stack Trace:

[SqlException (0x80131904): Invalid column name 'IsSystemRole'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +443 ............
....

.....

...

Please mention which method is good and also request for solve this issue.


Please check error and kindly send reply as soon as possible.