Learn More





DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

.Fixing PortalSettings issue on multilingual Websites in DNN 7.3.2-7.3.3

DNN 7.3.2 enhanced the stored procedure for saving Site Settings to add multilanguage support, unfortunately it missed to include proper handling of language specific settings within the business layer and some other aspects. As effect, DNN 7.3.2 fails to load site settings for multilingual sites and renders an error message.

I created a full solution to add localization support for website settings, which is scheduled to be included with DNN 7.4.0, meanwhile you may run the script below from Host > SQL, in order to fix this issue.


This fix is also included in TurboDNN 0.9.3 ff. - the solution to improve database performance of DNN, which might be downloaded for free from here. (Please take the time to read instructions enclosed.)

-- ensure, last modified is not Null (should not exist)
UPDATE {databaseOwner}[{objectQualifier}PortalSettings]
 SET   LastModifiedOnDate = '2000-01-01' 
 WHERE LastModifiedOnDate is Null

IF OBJECT_ID(N'{databaseOwner}[{objectQualifier}GetPortalSetting]', N'P') IS NOT NULL
    DROP PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSetting]

CREATE PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSetting]
    @PortalID    Int,		    -- Not Null
    @SettingName nVarChar(50),	-- Not Null
    @CultureCode nVarChar(50)	-- not Null
		CASE WHEN Lower(SettingValue) Like 'fileid=%'
		 THEN {databaseOwner}[{objectQualifier}FilePath](SettingValue)
		 ELSE SettingValue 
		END   AS SettingValue,
	 FROM  {databaseOwner}[{objectQualifier}PortalSettings]
	 WHERE PortalID    = @PortalID
	   AND SettingName = @SettingName
	 ORDER BY LastModifiedOnDate DESC

IF OBJECT_ID(N'{databaseOwner}[{objectQualifier}GetPortalSettings]', N'P') IS NOT NULL
    DROP PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSettings]

CREATE PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSettings]
    @PortalId    Int,            -- not Null!
    @CultureCode nVarChar(20)    -- not Null!
		CASE WHEN Lower(SettingValue) Like 'fileid=%'
		 THEN {databaseOwner}[{objectQualifier}FilePath](SettingValue)
		 ELSE SettingValue 
		END   AS SettingValue,
	 FROM  {databaseOwner}[{objectQualifier}PortalSettings] P
	 JOIN  (SELECT PortalID, SettingName SN, Max(LastModifiedOnDate) MD
	        FROM {databaseOwner}[{objectQualifier}PortalSettings] 
			WHERE PortalID = @PortalId
			GROUP BY PortalID, SettingName) S 
	   ON P.PortalID = S.PortalID AND P.SettingName = S.SN AND P.LastModifiedOnDate = S.MD;

UPDATE: this fix has been included with DNN 7.3.4, you shouldn't need it, if you upgraded to 7.3.4 and don't apply it to DNN 7.4.0 or later! (I will provide another post to explain why).

Addendum: Some users reported a duplicate key in Site Settings, even after applying this script and upgrading to 7.3.4. This has a different reason: DNN moved the skin location from skins folder of the portal directory to the portals system directory, e.g. from /portals/0/skins/ to /portals/0-system/skins/ - but without moving the skin folders beneath. as a result, if you re-install a portal specific skin, you will end up with 2 skin folders with same name. To solve it, manually delete the old skins folder in portal directory.


mohammad azarbara
Thanks for your script, Sebastian
mohammad azarbara Friday, August 29, 2014 10:44 AM (link)
Max Matt
You are precious as always... thanks!
Max Matt Thursday, September 04, 2014 6:29 AM (link)
Sebastian Leupold
Thanks for the feedback, guys.

FYI: I released a script to fix issues with HostSettings yesterday, it is available for free download at and does add missing value and reset incorrect values to default as well.
Sebastian Leupold Wednesday, September 10, 2014 2:49 AM (link)
thanks! helped indeed! only problem left: multilingual portal, site settings -> redirection after login in multiple languages just saves the last language redirection.. what is kinda frustrating.. any fix for this?
VisualNet Saturday, September 13, 2014 7:29 AM (link)
Sebastian Leupold
I am working on an improvement for true multilingual portal settings - this fix just makes sure, it is working properly without language specific settings.
Sebastian Leupold Saturday, September 13, 2014 10:35 AM (link)
Hi Sebastion, thanks for your DNNboost scripts btw! Question, can you look at my website it's a completely new dnn instance with just couple of modules on it, but it's sooo slow.. it's my slowest website ever, dnn 7.3.2 version multilanguage. Can I PM you or ?...

i think it's because of the DNN 7.3.2 multilingual issues the website is running extremely slow.
VisualNet Sunday, September 14, 2014 5:57 AM (link)
Sebastian Leupold
FYI: I just released a script, to add missing website settings or adjusting irregular values, please see
Sebastian Leupold Sunday, September 14, 2014 1:39 PM (link)

after running this script, again same problem has began: saving site settings fails every time..
VisualNet Monday, September 15, 2014 4:48 AM (link)
Sebastian Leupold
Visualnet, Sure you may contact me by email via leupold [at]
Sebastian Leupold Monday, September 15, 2014 6:26 AM (link)
Sebastian Leupold
Visualnet, I will review - there might be still an issue with existing entries in other languages.
would you mind to post the complete stack trace as issue to my codeplex page, thanks.
Sebastian Leupold Tuesday, September 16, 2014 3:40 AM (link)
Panagiotis Mylonas

You saved me!

Your script at Fixing PortalSettings issue on multilingual Websites in DNN 7.3.2 here at this page and the info at Improve Stability + Performance of DNN (AKA DotNetNuke) CMS Platform solved my issue !

Many Thanks.

P.S. I left an issue at your page
Panagiotis Mylonas Tuesday, September 30, 2014 10:49 PM (link)
mohammad mamizadeh
Dear Sebastian
Thanks for your script.
mohammad mamizadeh Wednesday, October 01, 2014 1:47 AM (link)
Daniel Valadas
Worked perfectly, thanks for this script!
Daniel Valadas Saturday, October 04, 2014 10:26 PM (link)
Keston Pollard
Hi, What if you already have the DNN 7.3.3 upgrade installed? What's the quick fix?

Keston Pollard Thursday, October 09, 2014 7:30 AM (link)
Sebastian Leupold
the fix works for DNN 7.3.3 as well and will be included in DNN 7.3.4.
you don't need to delete duplicate settings manually.
Sebastian Leupold Monday, October 13, 2014 7:58 AM (link)
Larry Daniele
Thanks, Sebastian. Another DNN 7.3.2 multi-lingual website rescued!
Larry Daniele Thursday, October 16, 2014 4:50 PM (link)

Comment Form

Only registered users may post comments.


2sic Daniel Mettler (124)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (21)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (269)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?