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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...DNN6: Changing page order in tree view causes increasing level value of child tabsDNN6: Changing page order in tree view causes increasing level value of child tabs
Previous
 
Next
New Post
7/28/2011 7:45 PM
 
Probably this is a bug in DNN6:
When parent page is moved to new position in tree view (to the same level in tabs tree) level value of child tabs increases.

This is SQL to check:
SELECT     dnn_Tabs_1.TabID as TabIDParent, dnn_Tabs.TabID AS TabIDChild, dnn_Tabs_1.[Level] AS ParentLevel, dnn_Tabs.[Level] as ChildLevel
FROM         dnn_Tabs RIGHT OUTER JOIN
                      dnn_Tabs AS dnn_Tabs_1 ON dnn_Tabs.ParentId = dnn_Tabs_1.TabID
WHERE     (dnn_Tabs.[Level] - dnn_Tabs_1.[Level] > 1)

This is SQL to fix:
UPDATE    dnn_Tabs
SET              [Level] = (dnn_Tabs_1.[Level] + 1)
FROM         dnn_Tabs RIGHT OUTER JOIN
                      dnn_Tabs AS dnn_Tabs_1 ON dnn_Tabs.ParentId = dnn_Tabs_1.TabID
WHERE     (dnn_Tabs.[Level] - dnn_Tabs_1.[Level] > 1)

Fix works for me as I have only level 0 and level 1 pages, but probably it has to be run many times if you have more than 1 level of child tabs.
Backup database before you try this.

BR
Jurij
 
New Post
7/29/2011 3:54 AM
 
please make sure, the issue is logged in the tracker at support.dotnetnuke.com, to get investigated by the QA team and fixed in a future version of DNN.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...DNN6: Changing page order in tree view causes increasing level value of child tabsDNN6: Changing page order in tree view causes increasing level value of child tabs


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