Hi,
I have setup a site using DNN 5 now upgraded to DNN 5.1 and for some reason the default language is missing from the site settings menu.
I also want to change the default language from English US to English UK. I can’t seem to figure out how to do this on the new version of DNN.
Any help please.

Regards

Roger

HI,

Yes so is mine but mine is empty with nothing in the drop down.

Now thats an interesting question. I am sure that when I first installed it the default language was English US. Withpreviouse versions of DNN the English UK has already been installed.

When I goto Host > Languages and select the pencil to the left of the default language under extension settings i can see language (set to English United States) and below this I have fallback language. This I have set to both English US and English UK.

All this said and done I still have no language in the admin > site settings >advanced options ...

Should I have to install languages now as a part of DNN 5 setup? If so where do I get them from?

I have just been trying to figure out why I dont have the default language available and have found the following error when I try and update the site settings.

ModuleId: 355
ModuleDefId: 14
FriendlyName: Site Settings
ModuleControlSource: DesktopModules/Admin/Portals/SiteSettings.ascx
AssemblyVersion: 5.0.1
PortalID: 0
PortalName: Digital Trading Creative Ltd
UserID: 1
UserName: roger
ActiveTabID: 41
ActiveTabName: Site Settings
RawURL: /Admin/SiteSettings/tabid/41/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.digitaltradingcreative.c...fault.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: b65693a7-5938-4122-b347-79204b940041
InnerException: Cannot insert the value NULL into column 'DefaultLanguage', table 'dtc.dbo.Portals'; column does not allow nulls. UPDATE fails. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'DefaultLanguage', table 'dtc.dbo.Portals'; column does not allow nulls. UPDATE fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'DefaultLanguage', table 'dtc.dbo.Portals'; column does not allow nulls. UPDATE fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 UserTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory) at DotNetNuke.Entities.Portals.PortalController.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 UserTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory) at DotNetNuke.Modules.Admin.Portals.SiteSettings.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: JAN-005

I will continue my seach to find out what is happening and I will post my findings.

Hi.  I am having the same problem changing my background.  I've attempted to play with the languages with no success.  I found this script to run (posted below) to update the languages, but I am still learning DNN and am unsure how to run a script within the program.  If you could post instructions, I would greatly appreciate it.

Thanks,
Kipling

SCRIPT:

IF NOT EXISTS (SELECT * FROM {objectQualifier}[{objectQualifier}Packages] WHERE [Name] = 'DefaultLanguage')
INSERT INTO {objectQualifier}[{objectQualifier}Packages]
           ([PortalID]
           ,[Name]
           ,[FriendlyName]
           ,[Description]
           ,[PackageType]
           ,[Version]
           ,[License]
           ,[Manifest]
           ,[Owner]
           ,[Organization]
           ,[Url]
           ,[Email]
           ,[ReleaseNotes]
           ,[IsSystemPackage]
           ,[CreatedByUserID]
           ,[CreatedOnDate]
           ,[LastModifiedByUserID]
           ,[LastModifiedOnDate])
     VALUES
(0,
N'DefaultLanguage',
N'Default Language',
N'The US Language Pack is included as the default language with DotNetNuke.',
N'CoreLanguagePack',
'1.0.0',
N'DotNetNuke® - http://www.dotnetnuke.com

Copyright (c) 2002-2008

by DotNetNuke Corporation



Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
documentation files (the "Software"), to deal in the Software without restriction, including without limitation
the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and
to permit persons to whom the Software is furnished to do so, subject to the following conditions:



The above copyright notice and this permission notice shall be included in all copies or substantial portions
of the Software.



THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.',
NULL,
N'DotNetNuke',
N'DotNetNuke Corporation',
'www.dotnetnuke.com',
'support@dotnetnuke.com',
N'There are no release notes for this version.',
1,
-1,
GETDATE(),
-1,
GETDATE());
GO

IF NOT EXISTS (SELECT * FROM {objectQualifier}[{objectQualifier}Languages] WHERE [CultureCode]='en-US')
INSERT INTO {objectQualifier}[{objectQualifier}Languages]
           ([CultureCode]
           ,[CultureName]
           ,[FallbackCulture]
           ,[CreatedByUserID]
           ,[CreatedOnDate]
           ,[LastModifiedByUserID]
           ,[LastModifiedOnDate])
     VALUES
('en-US',
'English (United States)',
NULL,
-1,
GETDATE(),
-1,
GETDATE())
GO

INSERT INTO {objectQualifier}[{objectQualifier}LanguagePacks]
           ([PackageID]
           ,[DependentPackageID]
           ,[LanguageID]
           ,[CreatedByUserID]
           ,[CreatedOnDate]
           ,[LastModifiedByUserID]
           ,[LastModifiedOnDate])
SELECT
PackageId,
-2,
1,
-1,
GETDATE(),
-1,
GETDATE()
FROM {objectQualifier}[{objectQualifier}Packages]
WHERE [Name] = 'DefaultLanguage'
GO

INSERT INTO {objectQualifier}[{objectQualifier}PortalLanguages]
([PortalID], [LanguageID], [CreatedByUserID], [CreatedOnDate], [LastModifiedByUserID], [LastModifiedOnDate])
SELECT
0,
LanguageID,
-1,
GETDATE(),
-1,
GETDATE()
FROM
{objectQualifier}[{objectQualifier}Languages]
WHERE [CultureCode]='en-US'
GO

Hi.  I am having the same problem changing my background.  I've attempted to play with the languages with no success.  I found this script to run (posted below) to update the languages, but I am still learning DNN and am unsure how to run a script within the program.  If you could post instructions, I would greatly appreciate it.

Thanks,
Kipling

SCRIPT:

IF NOT EXISTS (SELECT * FROM {objectQualifier}[{objectQualifier}Packages] WHERE [Name] = 'DefaultLanguage')
INSERT INTO {objectQualifier}[{objectQualifier}Packages]
           ([PortalID]
           ,[Name]
           ,[FriendlyName]
           ,[Description]
           ,[PackageType]
           ,[Version]
           ,[License]
           ,[Manifest]
           ,[Owner]
           ,[Organization]
           ,[Url]
           ,[Email]
           ,[ReleaseNotes]
           ,[IsSystemPackage]
           ,[CreatedByUserID]
           ,[CreatedOnDate]
           ,[LastModifiedByUserID]
           ,[LastModifiedOnDate])
     VALUES
(0,
N'DefaultLanguage',
N'Default Language',
N'The US Language Pack is included as the default language with DotNetNuke.',
N'CoreLanguagePack',
'1.0.0',
N'DotNetNuke® - http://www.dotnetnuke.com

Copyright (c) 2002-2008

by DotNetNuke Corporation



Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
documentation files (the "Software"), to deal in the Software without restriction, including without limitation
the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and
to permit persons to whom the Software is furnished to do so, subject to the following conditions:



The above copyright notice and this permission notice shall be included in all copies or substantial portions
of the Software.



THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.',
NULL,
N'DotNetNuke',
N'DotNetNuke Corporation',
'www.dotnetnuke.com',
'support@dotnetnuke.com',
N'There are no release notes for this version.',
1,
-1,
GETDATE(),
-1,
GETDATE());
GO

IF NOT EXISTS (SELECT * FROM {objectQualifier}[{objectQualifier}Languages] WHERE [CultureCode]='en-US')
INSERT INTO {objectQualifier}[{objectQualifier}Languages]
           ([CultureCode]
           ,[CultureName]
           ,[FallbackCulture]
           ,[CreatedByUserID]
           ,[CreatedOnDate]
           ,[LastModifiedByUserID]
           ,[LastModifiedOnDate])
     VALUES
('en-US',
'English (United States)',
NULL,
-1,
GETDATE(),
-1,
GETDATE())
GO

INSERT INTO {objectQualifier}[{objectQualifier}LanguagePacks]
           ([PackageID]
           ,[DependentPackageID]
           ,[LanguageID]
           ,[CreatedByUserID]
           ,[CreatedOnDate]
           ,[LastModifiedByUserID]
           ,[LastModifiedOnDate])
SELECT
PackageId,
-2,
1,
-1,
GETDATE(),
-1,
GETDATE()
FROM {objectQualifier}[{objectQualifier}Packages]
WHERE [Name] = 'DefaultLanguage'
GO

INSERT INTO {objectQualifier}[{objectQualifier}PortalLanguages]
([PortalID], [LanguageID], [CreatedByUserID], [CreatedOnDate], [LastModifiedByUserID], [LastModifiedOnDate])
SELECT
0,
LanguageID,
-1,
GETDATE(),
-1,
GETDATE()
FROM
{objectQualifier}[{objectQualifier}Languages]
WHERE [CultureCode]='en-US'
GO