Now I tried to install module form and list 5003 and get the following errors. Please advise what I should do. Thanks, Hy
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'PrivateField' in table 'dbo.UserDefinedFields' is specified more than once. 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) ALTER TABLE dbo.[UserDefinedFields] ADD PrivateField BIT DEFAULT 0 Not Null /* replace stored procedures with updated versions: */ IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_AddField]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_AddField] System.Data.SqlClient.SqlException: There is already an object named 'UserDefinedTable_AddField' in the database. 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.[UserDefinedTable_AddField] @ModuleId INT, @FieldTitle NVARCHAR(50), @BeforePos INT, @HelpText NVARCHAR(512), @Required BIT, @FieldType VARCHAR(20), @Default NVARCHAR(2000), @Visible BIT, @ShowOnEdit BIT, @Searchable BIT, @Private BIT, @InputSettings NVARCHAR(2000), @OutputSettings NVARCHAR(2000), @NormalizeFlag BIT, @ValidationRule NVARCHAR(512), @ValidationMessage NVARCHAR(512) AS DECLARE @InsPos INT /* find insert position and adjust field order of subsequent fields: */ SET @InsPos = (SELECT MAX(FieldOrder) AS MaxPos FROM dbo.UserDefinedFields WHERE ModuleID = @ModuleID GROUP BY ModuleID) + 1 IF @InsPos IS Null SET @InsPos = 1 IF @BeforePos Is Null SET @BeforePos = @InsPos IF @InsPos > @BeforePos BEGIN UPDATE [UserDefinedFields] SET FieldOrder = FieldOrder + 1 WHERE ModuleID = @ModuleID AND FieldOrder >= @BeforePos SET @InsPos = @BeforePos END INSERT INTO dbo.[UserDefinedFields] ( ModuleId, FieldTitle, HelpText, Required, FieldType, FieldOrder, [Default], Visible, ShowOnEdit, Searchable, PrivateField, InputSettings, OutputSettings, NormalizeFlag, ValidationRule, ValidationMessage ) VALUES ( @ModuleId, @FieldTitle, @HelpText, @Required, @FieldType, @InsPos, @Default, @Visible, @ShowOnEdit, @Searchable, @Private, @InputSettings, @OutputSettings, @NormalizeFlag, @ValidationRule, @ValidationMessage ) SELECT SCOPE_IDENTITY()