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 ...TabSettings Table obsolete valuesTabSettings Table obsolete values
Previous
 
Next
New Post
7/5/2015 6:32 AM
 

Noticed the latest version 7.4.1 (I updated from 7.3.4) the following values in the columns (SettingName) > Table TabSettings are no longer inserted when a page (tab) is added:

DefaultAdminContainer
DebugMode
DefaultDocType

While the value CacheDuration in SettingName column (with an empty value in the SettingValue column) is inserted when a new page is added or an existing page is updated for whatever reason.

If I am correct CacheDuration
 (in the SettingName > TableSettings) was not there prior to ver. 7.4.x

I have deleted the "obsolete" (if I may call them as such)  values using the following:

DELETE FROM TabSettings
WHERE SettingName = 'DefaultDocType';

Have tested the pages, added, deleted and changed the page settings, so far no issue, I feel the page load is a bit faster.

Am I correct these values are not longer needed?

also used Will Stroh instructions to clean reference of old skins that have been deleted, and reset the portal to the default skin.

http://www.willstrohl.com/Blog/PostId/515/How-to-Clear-Out-Skins-and-Containers-in-DotNetNu





 
New Post
7/6/2015 4:29 AM
 
Salem,
if I remember correctly, DefaultAdminContainer, DebugMode and DefaultDocType are Host Settings, not TabSettings.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/6/2015 4:03 PM
 

Many thanks Sebastian for your reply:

The PortalSettings Table does not have DebugMode and DefaultDocType SettingsName value; it only has the DefaultAdminContainer please see the following, I made a screenshot of the TabSettings table (ver 7.4.1 CE) prior to me removing them (as referred).

 

PortalSettings Table

Column > SettingName (some may include third party settings as well)

AddCachebusterToResourceUris

AddCompatibleHttpHeader

addresscell

addresscity

addresscountry

addressfax

addresspostal

addressregion

addressstreet

addresstelephone

AllowUserUICulture

AUM_RedirectOldProfileUrl

AUM_VanityUrlPrefix

Column_Address

Column_Authorized

Column_CreatedDate

Column_DisplayName

Column_Email

Column_FirstName

Column_LastLogin

Column_LastName

Column_Telephone

ContentLocalizationEnabled

ControlBar_BookmarkCategory

ControlPanelMode

ControlPanelSecurity

ControlPanelVisibility

coreSitemapProviderEnabled

coreSitemapProviderOverride

coreSitemapProviderValue

CreateNewPageCultureType

CrmEnableCompositeFiles

CrmMinifyCss

CrmMinifyJs

CrmUseApplicationSettings

CrmVersion

DefaultAdminContainer

DefaultAdminSkin

DefaultAuthProvider

DefaultIconLocation

DefaultPortalAlias

DefaultPortalContainer

DefaultPortalSkin

DefaultTranslatorRoles-ar-JO

DefPreviewProfiles_Created

DisablePrivateMessage

Display_Mode

Display_SuppressPager

EnableBrowserLanguage

EnableModuleEffect

EnablePopups

EnableRegisterNotification

EnableSkinWidgets

EnableUrlLanguage

Facebook_APIKey

Facebook_APISecret

Facebook_Enabled

FavIconPath

Google_APIKey

Google_APISecret

Google_Enabled

HideFoldersEnabled

HideLoginControl

IncludePortalCss

InjectModuleHyperLink

InlineEditorEnabled

Live_APIKey

Live_APISecret

Live_Enabled

LiveID_Enabled

LiveID_IncludeHelp

MaximumVersionHistory

MaxSearchWordLength

MessagingAllowAttachments

MessagingProfanityFilters

MessagingRecipientLimit

MessagingSendEmail

MessagingThrottlingInterval

MinSearchWordLength

PageHeadText

paypalsandbox

paypalsubscriptioncancelreturn

paypalsubscriptionreturn

PortalAliasMapping

Profile_DefaultVisibility

Profile_DisplayVisibility

Profile_ManageServices

Records_PerPage

Redirect_AfterLogin

Redirect_AfterLogout

Redirect_AfterRegistration

Registration_ExcludeTerms

Registration_RandomPassword

Registration_RegistrationFormType

Registration_RequireConfirmPassword

Registration_RequireUniqueDisplayName

Registration_UseAuthProviders

Registration_UseEmailAsUserName

Registration_UseProfanityFilter

Search_ReindexRequestedOn

SearchAdminInitialization

SearchIncludeCommon

SearchIncludeNumeric

Security_CaptchaChangePassword

Security_CaptchaLogin

Security_CaptchaRegister

Security_CaptchaRetrivePassword

Security_DisplayNameFormat

Security_EmailValidation

Security_RequireValidProfile

Security_RequireValidProfileAtLogin

Security_UserNameValidation

Security_UsersControl

SitemapCacheDays

SitemapExcludePriority

SitemapIncludeHidden

SitemapLevelMode

SitemapMinPriority

SMTPAuthentication

SMTPConnectionLimit

SMTPEnableSSL

SMTPMaxIdleTime

SMTPmode

SMTPPassword

SSLEnabled

SSLEnforced

SSLURL

STDURL

Store_Password

Store_Username

TimeZone

Tweetification_AppUserName

Tweetification_AutoFollow

Tweetification_AutoTweet

Tweetification_ConsumerKey

Tweetification_ConsumerSecret

Tweetification_Enabled

Tweetification_TweetThis

Twitter_APIKey

Twitter_APISecret

Twitter_Enabled

UserIndexer_ReIndex

wnsogp-sitename

wnsogp-sitetype

wnsogp-useportaltitle

 
New Post
7/7/2015 3:39 AM
 
Sorry, Salem, I was talking about HOSTSETTINGS table.
E.g. I am not aware of a debug option per page.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/7/2015 4:35 AM
 

Yes you are right  Sebastian :) It is my overlook. But still the values are no longer added in the TabSettings table for version 7.4.x and deleting from the values from the TableSettings table was safe and somewhat bettered the page load.

HostSettings Table > Column > SettingName  (referred values in bold)

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...TabSettings Table obsolete valuesTabSettings Table obsolete values


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.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out