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  |  

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


  Ads  
WebHostForAsp.net
 


  Sponsors  

Meet Our Sponsors

CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
Click here to go to dev.live.com for Windows Live developer resources
SteadyRain
 


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
357 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
1142 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
357 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
5 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
357 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.

 


Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com
DNNCovered.com - Your Offshore Dotnetnuke Partner
Dnncovered.com is the only Dotnetnuke offshore outsourcing center specializes in DNN skinning and module development with lowest pricing and quality service. Our staff is dedicated to websites based on DNN and our graphic designers are creative and imaginative well enough to provide customers the complete set of skinning solutions and packages
www.dnncovered.com
PointClick.Net DNN Solutions
DotNetNuke Hosting Platform for Business and personal use.
PointClick.Net Hosted Solutions

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