Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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...Upgrading DNN P...Upgrading DNN P...'Host Settings' not available after upgrading from 5.6.3 to 6.0.1
Previous
 
Next
New Post
9/12/2011 4:53 PM
 
Horacio Judeikin


https://www.evotiva.com
Joined: 9/3/2004
Posts: 389
Richard Manley-Tannis wrote:
Hi Horacio,

could you tell me where/how I run this query please?

 As a 'host' (super user) user , from Host > SQL
 
New Post
9/12/2011 7:44 PM
 
Richard Manley-Tannis


Joined: 11/10/2005
Posts: 62
Hi Horacio,

As this is outside of my experience, I have c&p the following after running the script. I hope this is useful and thanks so much!

2
1 Access Denied
1 Adsense
1 CONTROLPANEL:CLASSIC
1 CONTROLPANEL:ICONBAR
1 CONTROLPANEL:RIBBONBAR
1 Edit
1 ExportModule
1 ExportTab
1 File Manager
1 Help
1 ImportModule
1 ImportTab
1 Install
1 Login
1 Logoff
1 ManageTextSizePro
1 Module
1 Privacy
1 Profile
1 Purchase
1 Register
1 SendPassword
1 Settings
1 Tab
1 Terms
1 UnInstall
1 View Vendor
1 ViewProfile
1 ViewSource
1 12
1 12 Edit
1 12 EditGroup
1 12 User Roles
1 12 UserSettings
1 13
1 13 Edit
1 14
1 15
1 15 Edit
1 15 EditProfileProperty
1 15 ManageProfile
1 15 User Roles
1 15 UserSettings
1 19
1 19 Affiliate
1 19 Banner
1 19 Edit
1 20
1 20 Edit
1 21
1 21 Edit
1 27
1 28
1 63
1 63 Edit
1 63 Signup
1 63 Template
1 65
1 72
1 74
1 75
1 76
1 79
1 79 Edit
1 80
1 80 Edit
1 80 History
1 80 Status
1 85
1 86
1 86 Settings
1 87
1 87 Settings
1 88
1 90
1 92
1 92 Edit
1 93
1 93 Settings
1 95
1 95 Edit
1 95 MyWork
1 95 Settings
1 96
1 96 Edit
1 96 Settings
1 99
1 100
1 100 Edit
1 100 Settings
1 101
1 101 edit
1 101 settings
1 108
1 108 About
1 108 Activate
1 108 AddFromHTML
1 108 AddFromURL
1 108 AddRSSAlbum
1 108 AddStdAlbum
1 108 Albums
1 108 AmazonS3
1 108 Appearance
1 108 Approve
1 108 ChooseFile
1 108 ClassicUpload
1 108 CopyAndPaste
1 108 EditPhoto
1 108 EditPhoto2
1 108 EditRssAlbum
1 108 EditStdAlbum
1 108 Manage
1 108 ModuleSettings
1 108 MyPhotos
1 108 NoQuota
1 108 QuickCreateAlbum
1 108 Search
1 108 SharePG
1 108 UpgradeGuide
1 108 Upload
1 108 WizardStep1
1 108 WizardStep2
1 108 WizardStep3
1 108 WizardStep4
1 109
1 109 FromDirectory
1 109 FromUPG1
1 109 TransferAlbum
1 110
1 110 TopPhotosSettings
1 111
1 111 TopCommentsSettings
1 112
1 112 ConfirmOrder
1 112 ModuleSettings
1 112 ShoppingCartSettings
1 113
1 113 ModuleSettings
1 113 PurchasedItemsSettings
1 115
1 115 ACP
1 115 ContentRemoved
1 115 EmailTemplates
1 115 Emoticon
1 115 ForumEdit
1 115 ForumManage
1 115 ForumSearch
1 115 MCP
1 115 MemberList
1 115 PMEdit
1 115 PMThread
1 115 PostDelete
1 115 PostEdit
1 115 PostModerate
1 115 PostReport
1 115 PublicProfile
1 115 RoleAvatar
1 115 Settings
1 115 ThreadMove
1 115 ThreadSplit
1 115 UCP
1 116
1 116 ModuleSettings
1 120
1 120 Settings
1 121
1 121 Settings
1 122
1 122 Settings
1 123
1 123 Settings
1 124
1 124 ModuleSettings
1 126
1 126 DashboardControls
1 126 Export
1 127
1 128
1 128 BatchInstall
1 128 Edit
1 128 EditControl
1 128 EditModuleDefinition
1 128 NewExtension
1 128 PackageWriter
1 128 UsageDetails
1 129
1 129 Edit
1 129 Editor
1 129 EditResourceKey
1 129 PackageWriter
1 129 Settings
1 129 TimeZone
1 129 TranslationStatus
1 129 Verify
1 130
1 131
1 132
1 132 Settings
1 133
1 134
1 135
1 135 ModuleSettings
1 136
1 136 ModuleSettings
1 137
1 137 ModuleSettings
1 138
1 138 ModuleSettings
1 139
1 139 ModuleSettings
1 140
1 140 Settings
1 141
1 142
1 142 EditMessage
1 142 ViewMessage
1 143
1 143 CreateVocabulary
1 143 EditVocabulary
1 144
1 145
 
New Post
9/12/2011 8:42 PM
 
Horacio Judeikin


https://www.evotiva.com
Joined: 9/3/2004
Posts: 389
Richard Manley-Tannis wrote:
Hi Horacio,

As this is outside of my experience, I have c&p the following after running the script. I hope this is useful and thanks so much!

The problem seems to be on the first row.
Now run this query, to see which are the related modules:

select * from  modulecontrols
where moduledefid is null and controlkey is null

Then, with the given clues, maybe Cathal could have some ideas about the best way to remove the duplicates.

Thanks,
Horacio.-
 
New Post
9/12/2011 8:59 PM
 
Richard Manley-Tannis


Joined: 11/10/2005
Posts: 62
Thanks again Horatio,

If you have time and think it can be made understandable to me, what does all this mean? Below is the 2nd query you asked me to run:

ModuleControlID ModuleDefID ControlKey ControlTitle ControlSrc IconFile ControlType ViewOrder HelpUrl SupportsPartialRendering CreatedByUserID CreatedOnDate LastModifiedByUserID LastModifiedOnDate
172 Admin/Syndication/FeedExplorer.ascx 0
169 Admin/Vendors/Adsense.ascx 0
 
New Post
9/13/2011 9:29 AM
 
Noah Bast


www.os-cubed.com
Joined: 9/29/2005
Posts: 40
I modified the query slightly for our situation, and here are the results:

274 NULL Adsense Google Adsense DesktopModules/Adsense/EditAdsense.ascx NULL 1 NULL NULL 0 NULL NULL NULL NULL 0
290 NULL NULL NULL Admin/Vendors/Adsense.ascx NULL 0 NULL NULL 0 NULL NULL NULL NULL 0
292 NULL Adsense Google Adsense Admin/Vendors/EditAdsense.ascx NULL 2 NULL NULL 0 NULL NULL NULL NULL 0
293 NULL NULL NULL Admin/Syndication/FeedExplorer.ascx NULL 0 NULL NULL 0 NULL NULL NULL NULL 0

Using query:
select * from  modulecontrols
where moduledefid is null and (controlkey is null or ControlKey='Adsense')
 
 Page 3 of 10
Previous1234...10Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...'Host Settings' not available after upgrading from 5.6.3 to 6.0.1


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