Hi there
I currently run into the following error when I try to install nopCommerce 4.6 on my linux server.
It seems that nopCommerce tries to just run the migrations for 4.6 instead of creating the Database first. Anyone else ever had this issue? Locally everything works fine. Also nopCommerce created the MigrationHistory table in the new Database but there is no data inside.
Here is my log:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1000]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: StoreMigration migrating
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: Beginning Transaction
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: BEGIN TRANSACTION
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: AlterTable Store
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1002]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: => 0.000643s
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: CreateColumn Store Deleted Boolean
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: ALTER TABLE [dbo].[Store] ADD [Deleted] BIT NOT NULL CONSTRAINT [DF_Store_Deleted] DEFAULT 0
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: fail: FluentMigrator.Runner.MigrationRunner[0]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: An error occured executing the following sql:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: ALTER TABLE [dbo].[Store] ADD [Deleted] BIT NOT NULL CONSTRAINT [DF_Store_Deleted] DEFAULT 0
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: The error was Cannot find the object "dbo.Store" because it does not exist or you do not have permissions.
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: System.Exception: An error occured executing the following sql:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: ALTER TABLE [dbo].[Store] ADD [Deleted] BIT NOT NULL CONSTRAINT [DF_Store_Deleted] DEFAULT 0
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: The error was Cannot find the object "dbo.Store" because it does not exist or you do not have permissions.
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.Store" because it does not exist or y ou do not have permissions.
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInA ction)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrap CloseInAction)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectio nLock, Boolean asyncClose)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, B ulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, In t32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteNonQuery(String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: ClientConnectionId:bdef6909-853b-4b6f-bece-966b74b3203b
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: Error Number:4902,State:1,Class:16
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: --- End of inner exception stack trace ---
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteNonQuery(String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.Processors.ProcessorBase.Process(CreateColumnExpression expression)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Expressions.CreateColumnExpression.ExecuteWith(IMigrationProcessor processor)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass80_0.<ExecuteExpressions>b__1()
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.StopWatch.Time(Action action)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: Rolling back transaction
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: ROLLBACK TRANSACTION