I am trying to update the UDT to version 03.03.06 on a DNN installation of 3.2.2.  Now all my existing instances of the UDT are giving me this error:

Error: 2006-07 Meal Pricers is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.GetUserDefinedField' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.GetUserDefinedField' 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 Wfra.DNN.Modules.WFRA_UDT.Data.SqlDataProvider.GetUserDefinedField(Int32 UserDefinedFieldId) at Wfra.DNN.Modules.WFRA_UDT.Business.WFRA_UDTController.GetUserDefinedField(Int32 UserDefinedFieldId) at Wfra.DNN.Modules.WFRA_UDT.WFRA_UDT.BindData() at Wfra.DNN.Modules.WFRA_UDT.WFRA_UDT.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace -

Any ideas what the problem might be?

Thanks

I think some of my confussion can from the download page where it states the following:

User Defined Table

03.03.06

Source

10/17/2006

3.03.05 / 4.03.05

It looks like my DNN version of 3.2.2 would work with the 03.03.06 UDT version.  Now I am thinking that I should be using the UDT 03.02.00 version. 

Since I have the 03.03.06 version installed DNN will not let me install the older version of UDT.  How can I get the older version installed without losing the data in my existing UDT's?

Thanks

please log in as host and go to host :: SQL menu item

enter the following text into the text box and hit enter (don't check "run as Script"):

UPDATE {databaseOwner}{objectQualifier}DesktopModules SET Version = '03.02.00' WHERE ModuleName Like N'DNN_UserDefinedTable'

and afterwards replace with the following text and hit enter again

SELECT Version from {databaseOwner}{objectQualifier}DesktopModules WHERE ModuleName Like N'DNN_UserDefinedTable'

I assume, you had installed UDT 3.2.0 before, otherwise replace the version number.

it should list version and "03.02.00"

Afterwards install the previous UDT version.