I have installed The latest UDT module on DNN 5.1.1 and it installed with out error. When i install a module on a page it gives me the following message as i would expect..

There are no columns defined. Setup the module inside the form and list configuration

Now clicking on the form and List Configuration link i then get the following error..

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.UserDefinedTable_GetFields' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.UserDefinedTable_GetFields' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.GetFields(Int32 ModuleId) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.GetFieldsTable(Boolean AddNewColumn, Boolean AddTrackColumns) at DotNetNuke.Modules.UserDefinedTable.Configuration.BindFields(Boolean blnInsertField) at DotNetNuke.Modules.UserDefinedTable.Configuration.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Now I reported a similar issue before but it could not be resolved so i stripped all components of UDT from the system and ran the unistall.sqldataprovider script to make sure, but this time i get the same issue but with a different error report ??? Help

On installing a clean install the system halts on loading the script 03.03.06.. running this script on its own it throws back this error..the new scripts are not being loaded to the dnn sqldataprovider folder?

System.Data.SqlClient.SqlException: Incorrect syntax near ''. 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) /************************************************************/ /***** SqlDataProvider *****/ /***** Install/Upgrade for UserDefinedTable 3.3.6 *****/ /***** [sleupold] 10/12/2006 *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search AND replace operation *****/ /***** for dbo. AND *****/ /***** or use 'SQL' FROM Host Menu AND run this. *****/ /***** *****/ /***** *****/ /************************************************************/ SET QUOTED_IDENTIFIER ON System.Data.SqlClient.SqlException: There is already an object named 'UserDefinedTable_SwapFieldOrder' 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_SwapFieldOrder] @FirstUserDefinedFieldId INT, @SecndUserDefinedFieldId INT AS DECLARE @Pos1 INT DECLARE @Pos2 INT SET @Pos1 = (SELECT FieldOrder FROM dbo.UserDefinedFields WHERE UserDefinedFieldId = @FirstUserDefinedFieldId) SET @Pos2 = (SELECT FieldOrder FROM dbo.UserDefinedFields WHERE UserDefinedFieldId = @SecndUserDefinedFieldId) UPDATE dbo.UserDefinedFields SET FieldOrder = -1 WHERE UserDefinedFieldId = @SecndUserDefinedFieldId UPDATE dbo.UserDefinedFields SET FieldOrder = @Pos2 WHERE UserDefinedFieldId = @FirstUserDefinedFieldId UPDATE dbo.UserDefinedFields SET FieldOrder = @Pos1 WHERE UserDefinedFieldId = @SecndUserDefinedFieldId