Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Orphan Pages and SQL TablesOrphan Pages and SQL Tables
Previous
 
Next
New Post
6/4/2010 6:12 AM
 
Hi! I have the same problem, my version of DNN is 5.4.2, windows server 2008, IIS 7, SQL 2005. Does anyone know why this happens? Please answer this thread To change the order direct in SQL, do like this: - open your SQL management - click to expand your db - expand Tables - rightclick on dbo.Tabs - click open table Here you will find all that you need to move a page In ParentID you can change which page is the parent page, this makes it right even in dotnetnuke
 
New Post
6/4/2010 1:47 PM
 
AFAIK this issue has been logged and fixed for next version (5.4.3).

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/5/2010 1:39 PM
 
This behavior was still repeating in 5.5.0, I notice a cryptic "What's New" in 5.5.1 that indicates it might have been finally addressed.

At the core, what is happening is that a page record has both a reference to its ParentId, and a Level code (0-based index) that tells what level hierarchy it should be. The Admin Pages module looks at the Level apparently, not attempting to rebuild the hierarchy - apparently an attempt at optimization.

We have noticed that if you use the Admin Pages module exclusively no inconsistencies result between the actual hierarchy chain and the Level index. However, using the RibbonBar Current Page Move command, situations seem to happen to corrupt the Level with regard to the changed ParentId. This SQL statement finds the pages that are corrupted (we had dozens, including some we'd forgotten about):

SELECT p.*,t.*
  FROM Tabs t JOIN (SELECT TabId,[Level] FROM Tabs) p
ON t.ParentId=p.TabID
  WHERE t.[Level] != (p.[Level]+1)

It is trivial to see what level is expected and what it actually is (in the two Level columns). When the Level is corrupted so that a child page's Level is less than its parent's, the Admin Pages does not display the child even though it is actually present and linked properly with the ParentId (in 5.5.0).

The data fix is to simply readjust the Level field in the Tabs table directly for the corrupt child pages. Then restart the application (in case of caching). Of course, the code should be fixed to prevent the possibility of such corruption in the first place (transactions, anyone?).
 
New Post
11/5/2010 7:08 PM
 
you may use any disfesction - some bugs are always surviving :;)

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Orphan Pages and SQL TablesOrphan Pages and SQL Tables


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out