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 StartedInstalling DNN ...Installing DNN ...Module Definitions - IssueModule Definitions - Issue
Previous
 
Next
New Post
3/14/2011 6:15 PM
 
I can get to Host - SQL and am very comfortable in SQL, just need to know what should be in the table and what shouldn't.

I assume the ModuleControls table didn't update but don't know what the update is.
 
New Post
3/14/2011 6:52 PM
 
Were you able to check the \Admin folder and its child folders as I requested previously:

Please take a look at the site's file system and list the child folders of the \Admin folder. In a successful upgrade from a 4.x site, the \Admin child folders should only be the following: Containers, ControlPanel, Modules, Portal, Sales, Security, Skins, and Tabs. Most of the other Admin and Host module folders should have been moved to the \DesktopModules\Admin folder and their registration updated to reflect the change.

Also, while looking at the file system, does the following folder and .ascx control exist?

\DesktopModules\Admin\Extensions\Extension.ascx


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
3/14/2011 6:53 PM
 
Yes, all looks good on both.
 
New Post
3/14/2011 10:35 PM
 
So, for now we'll assume that all the administrative module controls such as Extensions.ascx were properly placed in child folders of DesktopModules\Admin.

Please run the following SQL script using SQL Server Management Studio or other tool of your choice. Before running the script you will need to replace all occurances of the {databaseOwner} token with the value of the databaseOwner attribute from the site's web.config (most likely it will be "dbo" so replace with "dbo." and of the {objectQualifier} token with the value of the objectQualifier attribute from the site's web.config (most likely it will be an empty string or "DNN_".

/** ========================= **/

SELECT
T.TabName,
T.TabPath,
P.TabName As 'Parent_TabName',
P.TabPath As 'Parent_TabPath'
FROM
{databaseOwner}{objectQualifier}Tabs T
Inner Join {databaseOwner}{objectQualifier}Tabs P on P.TabID = T.ParentId
WHERE
P.TabPath Like '//Host%' or P.TabPath Like '//Admin'
ORDER BY T.TabPath

SELECT
 T.TabPath,
 MD.ModuleDefID,
 MD.FriendlyName,
 MC.ControlTitle
FROM
{databaseOwner}{objectQualifier}ModuleControls MC
Inner Join {databaseOwner}{objectQualifier}ModuleDefinitions MD on MC.ModuleDefID = MD.ModuleDefID
Inner Join {databaseOwner}{objectQualifier}Modules M On M.ModuleDefID = MD.ModuleDefID
Inner Join {databaseOwner}{objectQualifier}TabModules TM on TM.ModuleID = M.ModuleID
Inner Join {databaseOwner}{objectQualifier}Tabs T on T.TabID = TM.TabID
WHERE T.TabPath Like '//Host%' or T.TabPath Like '//Admin'
ORDER BY T.TabPath, MD.ModuleDefID, MC.ControlTitle

DECLARE @ModuleDefID int

SET @ModuleDefID = (SELECT ModuleDefID
FROM {databaseOwner}{objectQualifier}Modules M
Inner Join {databaseOwner}{objectQualifier}TabModules TM on TM.ModuleID = M.ModuleID
Inner Join {databaseOwner}{objectQualifier}Tabs T on T.TabID = TM.TabID
WHERE T.TabPath = '//Host//Module Definitions'
)

SELECT
ControlKey,
ControlTitle,
ControlSrc
FROM {databaseOwner}{objectQualifier}ModuleControls
WHERE ModuleDefID = @ModuleDefID

GO

/** ========================= **/

Then, post the results to this forum thread or email them to me at bill (at) wesnetdesigns (dot) com. I need to be certain that all host and admin tabs and all administrative controls were registered. Hopefully only the ControlSrc column values in the ModuleControls table for the rows relating to the Extensions module are incorrect.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Module Definitions - IssueModule Definitions - Issue


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