Closed meffj00 closed 4 years ago
Is this a fresh installation or a module upgrade? If upgrade: from which version?
Also, is it possible you already had a table called Surveys before the installation, maybe created from another module or something?
This is a module upgrade from Survey 4.70.1.
4.70.1 was not an official release, and a bit spooky to be true. The latest official release was 4.70.0,
Quick solution: Uninstall the module and install Survey 09.00.01.
If that is no option (because the existing Surveys must not be lost), let me know and I do a special upgrade package, but this will last until the beginning of next year.
Thank you for your quick response and services!
I uninstalled the module Survey (i have checked the database and there were no Survey tables anymore).
I installed the module 9.00.01, but the error below appeared:
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 Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.00.30.txt
Info Verwijderd - DesktopModules\Survey\04.00.30.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.00.70.txt
Info Verwijderd - DesktopModules\Survey\04.00.70.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.00.85.txt
Info Verwijderd - DesktopModules\Survey\04.00.85.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.01.10.txt
Info Verwijderd - DesktopModules\Survey\04.01.10.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.50.00.txt
Info Verwijderd - DesktopModules\Survey\04.50.00.txt
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(TaskCompletionSource
1 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:88ef4f79-7b24-4d4b-9abd-f03427db0cac 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(TaskCompletionSource
1 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:88ef4f79-7b24-4d4b-9abd-f03427db0cac 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(TaskCompletionSource
1 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:88ef4f79-7b24-4d4b-9abd-f03427db0cac 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(TaskCompletionSource
1 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:88ef4f79-7b24-4d4b-9abd-f03427db0cac 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 Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.30.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.70.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.85.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.01.10.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.50.00.txt
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.30.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.70.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.85.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.01.10.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.50.00.txt
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Installatie mislukt - DNN_Survey
Info Tijdelijke installatie map verwijderd
EndJob Installatie mislukt
Ok - I'll have a look at it, but please understand that this will be after Christmas. I never had an issue with upgrading or freshly installing, so I really wonder how this happens...
Hmm, this is odd for sure, the 03.xx.xx scripts should not run if you are upgrading from a higher version already, my guess is that it was not properly registered somehow previously...
@valadas : the 03.xx.xx scripts are running because @meffj00 has uninstalled the module before, I guess.
@meffj00 : Is it the case that you do not run as dbo (which could be the case in a shared hosting environment)? In this case, please try to installl from the attached package. Dnn.Modules.Survey_09.00.01_Install_SpecialTestPackage.zip
Hi Michael,
Thanks for your great support! Sorry, i did install the miodule on DNN 9.2.2. you send me, but it failed to install (see error log beliow). No Survey module installed and no Survey tables in the database. I don’t know what is happening, please help me?
Greatings, Jan Meffert janmeffert@live.nl
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 Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.00.30.txt
Info Verwijderd - DesktopModules\Survey\04.00.30.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.00.70.txt
Info Verwijderd - DesktopModules\Survey\04.00.70.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.00.85.txt
Info Verwijderd - DesktopModules\Survey\04.00.85.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.01.10.txt
Info Verwijderd - DesktopModules\Survey\04.01.10.txt
Info Backup van vorige versie wordt gemaakt - DesktopModules\Survey\04.50.00.txt
Info Verwijderd - DesktopModules\Survey\04.50.00.txt
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): Incorrect syntax near '.'. 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(TaskCompletionSource
1 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:49f96f42-f412-4dbe-911e-04396ddb4a83 Error Number:102,State:1,Class:15 create procedure dbo.GetSurvey @SurveyID int, @ModuleID int as select SurveyID, ModuleID, Question, ViewOrder, OptionType, dbo.Users.FirstName + ' ' + dbo.Users.LastName AS CreatedByUser, CreatedDate, ( select sum(Votes) fromdbo.SurveyOptions where dbo.SurveyOptions.SurveyID = dbo.Surveys.SurveyID ) AS Votes from dbo.dbo.Surveys left outer join dbo.Users on dbo.Surveys.CreatedByUser = dbo.Users.UserID where SurveyID = @SurveyID and ModuleID = @ModuleID
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 Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.30.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.70.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.85.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.01.10.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.50.00.txt
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.30.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.70.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.00.85.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.01.10.txt
Info Backup van vorige versie teruggezet - DesktopModules\Survey\04.50.00.txt
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Installatie mislukt - DNN_Survey
Info Tijdelijke installatie map verwijderd
EndJob Installatie mislukt
No Survey at a c
Verzonden vanuit Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 voor Windows 10
Van: Michael Tobischmailto:notifications@github.com Verzonden: maandag 13 januari 2020 07:42 Aan: DNNCommunity/DNN.Surveymailto:DNN.Survey@noreply.github.com CC: Jan Meffertmailto:janmeffert@live.nl; Mentionmailto:mention@noreply.github.com Onderwerp: Re: [DNNCommunity/DNN.Survey] Error when installing DNN Survey module 9.00.01 on DNN 9.2.2 (#44)
@valadashttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fvaladas&data=02%7C01%7C%7C3930d8e41b5c497b382708d797f3bd6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637144945412298342&sdata=48L4PVOhHc0AI367NNhE7f%2Bnp%2BNXvwrR5V3VR3MrHnc%3D&reserved=0 : the 03.xx.xx scripts are running because @meffj00https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmeffj00&data=02%7C01%7C%7C3930d8e41b5c497b382708d797f3bd6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637144945412298342&sdata=jCiBROS86ZE4b053zTvXdOMqxDTEUWoWV05MXjBHPVw%3D&reserved=0 has uninstalled the module before, I guess.
@meffj00https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmeffj00&data=02%7C01%7C%7C3930d8e41b5c497b382708d797f3bd6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637144945412308343&sdata=Gt%2B6idRTNfZ%2B%2BVwgJAgfM7Sv4wmPm32ESJuSDW0%2BdDM%3D&reserved=0 : Is it the case that you do not run as dbo (which could be the case in a shared hosting ebvironment)? In this case, please try to installl from the attached package. Dnn.Modules.Survey_09.00.01_Install_SpecialTestPackage.ziphttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FDNNCommunity%2FDNN.Survey%2Ffiles%2F4052326%2FDnn.Modules.Survey_09.00.01_Install_SpecialTestPackage.zip&data=02%7C01%7C%7C3930d8e41b5c497b382708d797f3bd6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637144945412308343&sdata=zQLrvVwZtGgRor3lX7AJTTMCBdbYzI0pW%2B426k2vAkA%3D&reserved=0
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FDNNCommunity%2FDNN.Survey%2Fissues%2F44%3Femail_source%3Dnotifications%26email_token%3DAC4HRXHV6YQYVEPZUTPPWNLQ5QEMXA5CNFSM4J52EFNKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEIXVSIQ%23issuecomment-573528354&data=02%7C01%7C%7C3930d8e41b5c497b382708d797f3bd6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637144945412318348&sdata=ughseFV9AuPivXRjnqJqVOu45ZkuIrionCgoUQjVkOY%3D&reserved=0, or unsubscribehttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAC4HRXBMAAF2QF2CKCNRRATQ5QEMXANCNFSM4J52EFNA&data=02%7C01%7C%7C3930d8e41b5c497b382708d797f3bd6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637144945412318348&sdata=e%2B6Tr9aEYhRmrct1qy%2F7ANxdUtBW4UGUKuPxGZkDCJ8%3D&reserved=0.
Sorry, Jan - just a little typo... please try again. Thanks... Dnn.Modules.Survey_09.00.01_Install_SpecialTestPackage2.zip
Hi Michael,
Thanks for your great and quick service. I like that! I have re-installed the modified module again and now it works perfect! Thanks a lot!
Greetings,
Jan Meffert janmeffert@live.nl
Van: Michael Tobisch notifications@github.com Verzonden: dinsdag 14 januari 2020 06:45 Aan: DNNCommunity/DNN.Survey DNN.Survey@noreply.github.com CC: Jan Meffert janmeffert@live.nl; Mention mention@noreply.github.com Onderwerp: Re: [DNNCommunity/DNN.Survey] Error when installing DNN Survey module 9.00.01 on DNN 9.2.2 (#44)
Sorry, Jan - just a little typo... please try again. Thanks... Dnn.Modules.Survey_09.00.01_Install_SpecialTestPackage2.ziphttps://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FDNNCommunity%2FDNN.Survey%2Ffiles%2F4057528%2FDnn.Modules.Survey_09.00.01_Install_SpecialTestPackage2.zip&data=02%7C01%7C%7Cb055b3015a654dd3cb9008d798b4df9b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637145774912623851&sdata=gNjkW61FFrq1n75%2BQXmCLI9XW0LcaF8VMcf%2B1hPZ0iw%3D&reserved=0
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FDNNCommunity%2FDNN.Survey%2Fissues%2F44%3Femail_source%3Dnotifications%26email_token%3DAC4HRXHSHWH4MVBVE3ZQ4X3Q5VGNDA5CNFSM4J52EFNKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEI3LYEQ%23issuecomment-574012434&data=02%7C01%7C%7Cb055b3015a654dd3cb9008d798b4df9b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637145774912623851&sdata=lBZXvWU6s0oMar5agO1I5O78APN87HG6tB66foFZQxM%3D&reserved=0, or unsubscribehttps://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAC4HRXG3TX37JOCZRAUMMTTQ5VGNDANCNFSM4J52EFNA&data=02%7C01%7C%7Cb055b3015a654dd3cb9008d798b4df9b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637145774912633859&sdata=0aJbHtNMfFxNwxXRl%2BGEU9dP%2FuVCpO32VOM9I4ilEG0%3D&reserved=0.
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, Action
1 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(TaskCompletionSource
1 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(TaskCompletionSource
1 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(TaskCompletionSource
1 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(TaskCompletionSource
1 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