I have exactly the same problem. On a 5.4.4 I'm unable to use the help module. On another 5.2.3 test environment i have no problems.

The list in the Help module > Setting > Categories is just emty even if the module is right below it and some catergories are defined. When trying to add a tutorial the list of categories is not visible.

Besides the error mentioned by the previous poster i get a additional event log:

UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1f22670f-d2ee-401e-bba7-6ccd81d1f715
InnerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "Intranetdb", table "dbo.Modules", column 'ModuleID'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "Intranetdb", 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleSetting(Int32 ModuleId, String SettingName, String SettingValue, Int32 createdByUserID) at DotNetNuke.Entities.Modules.ModuleController.UpdateModuleSetting(Int32 ModuleId, String SettingName, String SettingValue)

Thanks for any help!

Regarding the exception from the OP, it looks like the first error is generated because of some missing fields not being returned by the Help_GetCategoryModules SP.

I ran the following to fix this, but make sure you take a backup of the original first:

ALTER procedure [dbo].[Help_GetCategoryModules]
@TabId int
AS
SELECT    
    *
FROM         
dbo.ModuleDefinitions AS MD INNER JOIN
dbo.Modules AS M ON MD.ModuleDefID = M.ModuleDefID INNER JOIN
dbo.ContentItems AS CI ON M.ContentItemID = CI.ContentItemID LEFT OUTER JOIN
dbo.TabModules AS TM ON M.ModuleID = TM.ModuleID
       
WHERE     
    (MD.FriendlyName = N'Category') AND
    (TM.TabID = @TabId)
    and M.IsDeleted=0
order by
    TM.TabID

---

Steve White