Hello,
Following JonRobertson advice, I have made this new post to try helping new user with the HELP Module V2.0.4.
I had many problem in the past to have a HELP module V2.0.4 fully functionnal (and it seems that I am not the only one). So, I carefully read all threads here and I have prepared this small guide to help you. Proceed as follows and everything will work as it should (my Help module is fully functionnal after one day of test). I hope it can help other people having similar problems:
1- If you have already installed the HELP module and it is not working, delete it (same way than uninstalling any module)
2- Access your database (generally, your provider gives you the possibility to access your database using a web tool). Run the following command :
drop procedure dbo.helpxxxx
(replace xxx with all the procedure which have not been deleted by the process at step 1)
3- Download the latest version of Help module (today 2.0.4)
4- Install the HELP module as usual (you may have error messages).
5- To correct the error messages you had before, you must install one sp by typing the following command in your portal (log as HOST, choose the 'sql' menu, and tick the box "run as script" - do not forget the two carriage return at the end of the command):
CREATE PROCEDURE {databaseOwner}[{objectQualifier}Help_SearchTutorials]
@Search nvarchar(100)
AS
SELECT
{databaseOwner}{objectQualifier}Help_Tutorials.TutorialGUID,
{databaseOwner}{objectQualifier}Help_Tutorials.TutorialID,
{databaseOwner}{objectQualifier}Help_Tutorials.Title,
{databaseOwner}{objectQualifier}Help_Tutorials.ProductImage,
{databaseOwner}{objectQualifier}Help_Tutorials.Featured,
{databaseOwner}{objectQualifier}Help_Tutorials.KeyWords,
{databaseOwner}{objectQualifier}Help_Tutorials.DownloadName,
{databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc,
{databaseOwner}{objectQualifier}Help_Tutorials.Archive,
{databaseOwner}{objectQualifier}Help_Tutorials.Description,
0 AS ViewOrder
FROM {databaseOwner}{objectQualifier}Help_Tutorials
WHERE ({databaseOwner}{objectQualifier}Help_Tutorials.Title LIKE N'%' + @Search + '%')
OR
({databaseOwner}{objectQualifier}Help_Tutorials.KeyWords LIKE N'%' + @Search + '%') OR
({databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc LIKE N'%' + @Search +
'%') OR
({databaseOwner}{objectQualifier}Help_Tutorials.Description LIKE N'%' + @Search + '%')
GO
6- Finally, alter one procedure to have the buttons up/down correctly shown in your category module. Type the following in your portal (log as HOST, click on "sql" menu, and tick the box "run as script" - do not forget the two carriage return at the end of the text):
ALTER PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryActiveByParent]
@ModuleID int,
@ParentID int
AS
SELECT [CategoryID],
[CategoryGUID],
[Name],
[Description],
[Image],
[KeyWords],
[ModuleID],
[Order],
[Level],
[Parent],
[Visible],
[Deleted]
FROM {databaseOwner}{objectQualifier}Help_Category
WHERE [Parent] = @ModuleID AND [ModuleID] = @ParentID
AND [Deleted] <> 1
AND [Visible] <> 0
ORDER BY [Level] ASC,
[Parent] ASC,
[Order] ASC
GO
7- Finally, you should verify that your help module is linked to the correct category. To do so, open the settings in your help module (not the category module), and verify that the "set the category module" is not empty. UPDATE (even if you did not make any changes). Then, you should have a fully functionnal HELP module.
Hope it can help some of you,
Déclic Vidéo FX