Skip to content

Error when installing DNN Survey module 9.00.01 on DNN 9.2.2 #44

Description

@meffj00

StartJob Installatie starten
Info Installatie starten - DNN_Survey
Info Installatie starten - Config
Info Backup van vorige versie wordt gemaakt - web.config
Info Configuratie bestand bijgewerkt - web.config
Info Component succesvol geïnstalleerd - Config
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Script
Info Begin uitvoer Sql
Info Backup van vorige versie wordt gemaakt - Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Aangemaakt - Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Uitvoeren03.01.00.SqlDataProvider
Info Start uitvoer Sql: 03.01.00.SqlDataProvider bestand
Failure SQL uitvoer leverde de volgende uitzonderingen op: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.GetSurveys @ModuleID int as select SurveyID, Question, ViewOrder, OptionType, CreatedByUser, CreatedDate from Surveys where ModuleID = @ModuleID order by ViewOrder System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.GetSurvey @SurveyID int, @ModuleID int as select SurveyID, ModuleID, Question, ViewOrder, OptionType, Users.FirstName + ' ' + Users.LastName AS CreatedByUser, CreatedDate, ( select sum(Votes) from SurveyOptions where SurveyOptions.SurveyID = Surveys.SurveyID ) AS Votes from Surveys left outer join Users on Surveys.CreatedByUser = Users.UserID where SurveyID = @SurveyID and ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.AddSurvey @ModuleID int, @question nvarchar(500), @ViewOrder int, @OptionType char(1), @UserName nvarchar(100) as insert into Surveys ( ModuleID, Question, ViewOrder, OptionType, CreatedByUser, CreatedDate ) values ( @ModuleID, @question, @ViewOrder, @OptionType, @userName, getdate() ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.UpdateSurvey @SurveyID int, @question nvarchar(500), @ViewOrder int, @OptionType char(1), @UserName nvarchar(100) as update Surveys set Question = @question, ViewOrder = @ViewOrder, OptionType = @OptionType, CreatedByUser = @UserName, CreatedDate = getdate() where SurveyID = @SurveyID
Info Einde Sql uitvoer: 03.01.00.SqlDataProvider gereed
Info Sql uitvoer gereed
Failure Installatie mislukt - Script
Info Component installatie wordt ongedaan gemaakt - Config
Info Aanpassingen in configuratie bestand succesvol ongedaan gemaakt - web.config
Info Component installatie succesvol ongedaan gemaakt - Config
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Installatie mislukt - DNN_Survey
Info Tijdelijke installatie map verwijderd
EndJob Installatie mislukt

Metadata

Metadata

Assignees

No one assigned

    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