Hi, I am getting the following install error when I install the module. I have not installed the module previously. Can you please help me? I believe that I have the latest Dynamic Registration module because I've just purchased it. The file is named 7917_0_DataSprings_DynamicRegistration_Module31_DNN44PLUS.zip.
Thanks for your help
Steven
Info Executing 03.10.10.SqlDataProvider
StartJob Start Sql execution: 03.10.10.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Disallowed implicit conversion from data type text to data type nvarchar, table 'C1345_SQLDEV.dbo.DynamicRegistration_FormLocalization', column 'FormHeader'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type text to data type nvarchar, table 'C1345_SQLDEV.dbo.DynamicRegistration_FormLocalization', column 'FormFooter'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type text to data type nvarchar, table 'C1345_SQLDEV.dbo.DynamicRegistration_FormLocalization', column 'DisplayAfterMessage'. Use the CONVERT function to run this query. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[DynamicRegistration_AddRegistrationLocal] @LocalizationLanguage as nvarchar(300), @FormHeader as text, @FormFooter as text, @DisplayAfterMessage as text, @DuplicateEmailText as text, @ValidationErrorMessage as text, @UseRegisterButton as integer, @RegisterText as nvarchar(300), @RegisterImage as nvarchar(300), @UseUpdateButton as integer, @UpdateText as nvarchar(300), @UpdateImage as nvarchar(300), @UseCancelButton as integer, @CancelText as nvarchar(300), @CancelImage as nvarchar(300), @UseContinueButton as integer, @ContinueText as nvarchar(300), @ContinueImage as nvarchar(300), @ModuleID as integer AS Insert Into dbo.DynamicRegistration_FormLocalization(LocalizationLanguage, FormHeader, FormFooter, DisplayAfterMessage, DuplicateEmailText, ValidationErrorMessage, UseRegisterButton, RegisterText, RegisterImage, UseUpdateButton, [UpdateText], UpdateImage, UseCancelButton, CancelText, CancelImage, UseContinueButton, ContinueText, ContinueImage, ModuleID) Values(@LocalizationLanguage, @FormHeader, @FormFooter, @DisplayAfterMessage,@DuplicateEmailText, @ValidationErrorMessage, @UseRegisterButton, @RegisterText, @RegisterImage, @UseUpdateButton, @UpdateText, @UpdateImage, @UseCancelButton, @CancelText, @CancelImage, @UseContinueButton, @ContinueText, @ContinueImage, @ModuleID) System.Data.SqlClient.SqlException: Disallowed implicit conversion from data type text to data type nvarchar, table 'C1345_SQLDEV.dbo.DynamicRegistration_FormLocalization', column 'FormHeader'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type text to data type nvarchar, table 'C1345_SQLDEV.dbo.DynamicRegistration_FormLocalization', column 'FormFooter'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type text to data type nvarchar, table 'C1345_SQLDEV.dbo.DynamicRegistration_FormLocalization', column 'DisplayAfterMessage'. Use the CONVERT function to run this query. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[DynamicRegistration_UpdateRegistrationLocal] @DynamicRegistrationLocalizationID as uniqueidentifier, @LocalizationLanguage as nvarchar(300), @FormHeader as text, @FormFooter as text, @DisplayAfterMessage as text, @DuplicateEmailText as text, @ValidationErrorMessage as text, @UseRegisterButton as integer, @RegisterText as nvarchar(300), @RegisterImage as nvarchar(300), @UseUpdateButton as integer, @UpdateText as nvarchar(300), @UpdateImage as nvarchar(300), @UseCancelButton as integer, @CancelText as nvarchar(300), @CancelImage as nvarchar(300), @UseContinueButton as integer, @ContinueText as nvarchar(300), @ContinueImage as nvarchar(300), @ModuleID as integer AS Update dbo.DynamicRegistration_FormLocalization Set LocalizationLanguage = @LocalizationLanguage, FormHeader = @FormHeader, FormFooter =@FormFooter, DisplayAfterMessage = @DisplayAfterMessage, DuplicateEmailText = @DuplicateEmailText, ValidationErrorMessage = @ValidationErrorMessage, UseRegisterButton = @UseRegisterButton, RegisterText = @RegisterText, RegisterImage =@RegisterImage, UseUpdateButton =@UseUpdateButton, [UpdateText] =@UpdateText, UpdateImage = @UpdateImage, UseCancelButton = @UseCancelButton, CancelText = @CancelText, CancelImage = @CancelImage, UseContinueButton = @UseContinueButton, ContinueText = @ContinueText, ContinueImage = @ContinueImage, ModuleID = @ModuleID Where ModuleID = @ModuleID and LocalizationLanguage = @LocalizationLanguage
EndJob End Sql execution: 03.10.10.SqlDataProvider file |