| |
|
|
|
|
|
|
|
|
|
 |  | |
| | |
| | |
| | |
 | | |
|
|
|
| Is this a bug for Help module? |
|
|
I am trying to use help module now. But I found that I can move the category order. I can see the "View Order:"
and it's help said : Click the up or down arrows to move the item's view order. I didn't see any arrows within the page. Is this a bug of ver 4.3.2? Or I am missing something else? How can I fix this issue? |
|
|
|
| |
|
|
| Re: Is this a bug for Help module? |
|
|
There is a bug in 2.0.4 of the Help module where it checks where you can move the items to. For a quick fix run this in the SQL window.
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
Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 |
|
|
|
| |
|
|
| Re: Is this a bug for Help module? |
|
|
I run this script in the SQL window, but I got some error message. I used DotNetNuke 4.3.2. Can you help me?
When I click Execute directly, I got "There is an error in your query!"
When I check "System.Data.SqlClient.SqlException: near 'GO' is incorrect。 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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER PROCEDURE dbo.[Help_ListCategoryActiveByParent] @ModuleID int, @ParentID int AS SELECT [CategoryID], [CategoryGUID], [Name], [Description], [Image], [KeyWords], [ModuleID], [Order], [Level], [Parent], [Visible], [Deleted] FROM dbo.Help_Category WHERE [Parent] = @ModuleID AND [ModuleID] = @ParentID AND [Deleted] <> 1 AND [Visible] <> 0 ORDER BY [Level] ASC, [Parent] ASC, [Order] ASC GO" |
|
|
|
| |
|
|
| Re: Is this a bug for Help module? |
|
|
Thanks for your help, I have solved this problem when I remove the last GO in the script. It work well now.
I used script remove the GO here.
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
|
|
|
|
| |
|
|
| Re: Is this a bug for Help module? |
|
|
With the SQL control you need to add 2 carriage returns after the GO. This applies to any script executed by DNN.
Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
|
|
|
|
| |
| | |
| | |
| | |
|  |
| |
|
|
|
These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.
For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
|
| |
|
|
|
|
|
|
|
|