I created a new page and dropped the UDT into the main content pane. When the page reloaded I see a message that:
"There are no fields defined. Please go to Manager Table first." When I click on "Manage Table" (logged in as admin) I see this error:
An error has occurred.
Error: Manage User Defined Table is currently unavailable.
When I click in "Manage Table" logged in as Host/SU I see:
Error: Manage User Defined Table is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UserDefinedFields_Modules". The conflict occurred in database "DotNetNuke_Intranet", table "dbo.Modules", column 'ModuleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UserDefinedFields_Modules". The conflict occurred in database "DotNetNuke_Intranet", table "dbo.Modules", column 'ModuleID'. The statement has been terminated. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.AddField(Int32 ModuleId, String FieldTitle, Boolean Required, String FieldType, String Default, Boolean Visible, String ExtendedSettings) 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 the problem is, if I simply need to enable a feature so that I can manage this module or if there is a larger problem. Anyone offer some assitance?
Thanks!