After I upgrade from DNN 4.0.3 to 4.0.9, it works fine until I try to add the "user defined table".

    This is the first table, so it has the expected warning message, then I click the "manage user defined table" icon, and the error message pop up.

    Here it is the event viewer message.

ModuleId: 374
ModuleDefId: 123
FriendlyName: Manage User Defined Table
ModuleControlSource: DesktopModules/UserDefinedTable/ManageUserDefinedTable.ascx
AssemblyVersion: 04.09.01
PortalID: 0
PortalName: My Website
UserID: 1
UserName: host
ActiveTabID: 36
ActiveTabName: Home
RawURL: /DotNetNuke/Home/tabid/36/ctl/Manage/mid/374/Default.aspx
AbsoluteURL: /DotNetNuke/Default.aspx
AbsoluteURLReferrer: http://localhost/DotNetNuke/Home/tabid/36/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: e9019b33-a518-4896-93a8-be1f02f7e253
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.AddField(Int32 ModuleId, String FieldTitle, Int32 BeforePos, String HelpText, Boolean Required, String FieldType, String Default, Boolean Visible, Boolean ShowOnEdit, Boolean Searchable, String InputSettings, String OutputSettings, Boolean NormalizeFlag, String validationRule, String validationMessage) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.AddField(Int32 ModuleID, String FieldTitle, Int32 before, String HelpText, Boolean Required, String FieldType, String Default, Boolean Visible, Boolean ShowOnEdit, Boolean Searchable, String InputSettings, String OutputSettings, Boolean NormalizeFlag, String validationRule, String validationMessage) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.GetFieldsTable(Int32 ModuleId, Boolean AddNewColumn, Boolean AddTrackColumns) at DotNetNuke.Modules.UserDefinedTable.ManageUserDefinedTable.BindData(Boolean blnInsertField) at DotNetNuke.Modules.UserDefinedTable.ManageUserDefinedTable.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

    Not sure what is going on, and really like to find the solution for it.

    Thanks.

   It used to be 3.0.3 (or 3.3, which is default for dnn 4.0.3), now it is 3.5.1,.

    After uninstall, and reinstall, it works now, great thanks.

    Just like to know a little bit beyond the UDT, is there anyway that I can set up a role to control its own UDT table and content.

    For example:

     In our church, I like to set up different groups, and inside the group, they can build the UDT based contents, such as contact information, each group will has its own group admin, who should able to add new UDT based contents, such as new group member information, I am not very sure how to work this out.

     Thanks.