Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
 


  Sponsors  

Meet Our Sponsors

Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Help Module [Le...  I can't chage the category order after upgrade to 03.00.01?
Previous Previous
 
Next Next
New Post 8/24/2007 11:17 PM
User is offline Eric Peng
369 posts
sina101.com
8th Ranked




I can't chage the category order after upgrade to 03.00.01? 

I had tried the script that can fix this issue in the old version. But it's doesn't work this time. The up & down arrow disappear so I can change the category order.

Is there any new script I can use to fix this issue?

 
New Post 8/27/2007 4:20 PM
User is offline Philip Beadle
1165 posts
www.philipbeadle.net
6th Ranked








Re: I can't chage the category order after upgrade to 03.00.01? 

Try this.  I noticed that we had databaseowner in front of the sysobjects call which may have affected you.

 

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}Help_ListCategoryByParent]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure {databaseOwner}[{objectQualifier}Help_ListCategoryByParent]
GO


CREATE PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryByParent]

@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] = @ParentID AND [ModuleID] = @ModuleID
AND   [Deleted] <> 1

ORDER BY [Level] ASC,
   [Parent] ASC,
   [Order] ASC
   
GO


Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
New Post 8/28/2007 11:04 AM
User is offline Eric Peng
369 posts
sina101.com
8th Ranked




Re: I can't chage the category order after upgrade to 03.00.01? 

It doesn't work on my website. Did I miss something?

I copy

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}Help_ListCategoryByParent]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure {databaseOwner}[{objectQualifier}Help_ListCategoryByParent]
GO


CREATE PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryByParent]

@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] = @ParentID AND [ModuleID] = @ModuleID
AND   [Deleted] <> 1

ORDER BY [Level] ASC,
   [Parent] ASC,
   [Order] ASC
   
GO

 

to the SQL and choose "run as script" then click "Exeute". The answer is "The Query completed successfully! " But it doesn't work.

 
New Post 10/12/2007 11:03 PM
User is offline leolll
7 posts
10th Ranked


Re: I can't chage the category order after upgrade to 03.00.01? 

I also ran the above script, got the success message, but it still didn't work.  Anybody have an idea on what it might be?

 
New Post 12/30/2007 11:23 PM
User is offline Eric Peng
369 posts
sina101.com
8th Ranked




Re: I can't chage the category order after upgrade to 03.00.01? 
Modified By Eric Peng  on 12/31/2007 3:25:42 AM)

This issue only happened on upgrade process, I don't have this problem if I install a new DNN installation. But I have wrote a lot of content in old help module. I try to export the content but fail. I trace the source code. I think there some problem let this module "hide" this two icon. (Can't find previous category & can't find next category.)

Is there any solution can fix this issue? I wish to un-install, intall help module can fix this issue. But I need to backup the help content first(But I can't now.).

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Help Module [Le...  I can't chage the category order after upgrade to 03.00.01?
 


Forum Policy

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.

 


The Standard in Senior Housing Information
SNAPforSeniors provides consumers with free online resources to assist them with their search for senior housing
www.snapforseniors.com
DotNetNuke Web Hosting w/ ASP.NET 3.5
Unlimited email boxes, Unlimited databases, Unlimited domains. Plans start at $4.97
www.MyWinHosting.com
SteadyRain
Founded in 1999, SteadyRain has extensive experience delivering Internet technology strategies and solutions for a diverse client base, ranging from Fortune 500 firms to successful start-ups.
www.steadyrain.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP