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  |  

Affordable ASP.NET Hosting Service
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Biz Modules provides professional business modules and solutions for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
 


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 1/14/2008 8:28 PM
User is offline Philip Beadle
1164 posts
www.philipbeadle.net
6th Ranked








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

Been on leave :)  OK try this.

Run this query and make sure you dont have any sprocs that like they are duplicates

select * from dbo.sysobjects
where name like '%Help%' and OBJECTPROPERTY(id, N'IsProcedure') = 1

You should get a list like this

Help_AddCategory
Help_AddCategoryFromImport
Help_AddTutorial
Help_AddTutorialFromImport
Help_CategorySetLevel
Help_CategorySetVisibility
Help_DeleteCategory
Help_DeleteTutorial
Help_GetCategory
Help_GetCategoryModules
Help_GetMaximumTutorialCategoryViewOrder
Help_GetTutorial
Help_GetTutorialsByModule
Help_ListCategory
Help_ListCategoryActive
Help_ListCategoryActiveByParent
Help_ListCategoryByParent
Help_ListTutorial
Help_ListTutorialAlphabetical
Help_SearchTutorials
Help_TutorialAddToCategory
Help_TutorialCategoryList
Help_TutorialDeleteCategory
Help_UpdateCategory
Help_UpdateTutorial
Help_UpdateTutorialViewOrder

I think you may have some messed up sprocs in your db.


Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
New Post 1/14/2008 8:45 PM
User is offline Philip Beadle
1164 posts
www.philipbeadle.net
6th Ranked








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

Also run this sql and make sure the sproc has been updated.

 

SELECT text
FROM syscomments
WHERE id = (SELECT id FROM sysobjects WHERE name = 'Help_ListCategoryByParent')
ORDER BY colid


Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
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.

 


Easily Build DNN Solutions with XMod
XMod makes it easy to build news articles, house listings, custom feedback forms, product reviews and much more - without programming
www.DNNDev.com
Software Development and Integration with DNN
HNP Solutions focuses on the pragmatic use of technology and process to meet an organization's business objectives. HNP Solutions employs seasoned Enterprise and Solution Architects, Delivery Managers and QA & Business Leads. Our capabilities range from project assessments & recommendations, design & code reviews, to full program implementations. We also work with organizations in need of senior staff augmentation purposes in the areas of Enterprise and Solution architecture.
www.hnpsolutions.com
Willhite & Sharron Realtors
Exemplary service for your Seattle Real Estate needs. It's what you deserve from your Realtor®!
www.alkihomes.com

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