Date Time Settings showing wrong setting after upgrade

Jan_Dam

Hi,

I have just upgraded our prodution servers to the latest version of the portal.
But now it show the wrong date time setting, under user setting.

I have done the same on our test servers, but on them everything is fine.

Under installation i have set default date/time to "DAN", as in danish, but in the portal i only have "English" under user settings.

What have i done wrong? And how do get to show the right setting?
I have tryed to reinstall the portal, but i get the same result.

john_doyle

Hi @Jan_Dam
Check the SettingsItem table in the database. The LanguageCode entry should contain a comma-separated list of language codes with no white spaces.

SELECT *<br>&nbsp; FROM [SettingsItem]<br>&nbsp;WHERE [Key]='LanguageCode'

If the information in the table is incorrect you can update it under Admin Settings > Setting Items

If the information is correct, I would recommend truncating the UserPreferences table and restarting the cache builder service and IIS.

TRUNCATE TABLE UserPreferences;

john_doyle

@Jan_Dam I got mixed up with the language codes, but what I said still holds. You can add the DAN code to the LanguageCodeDateTime setting. If you only had ENU in that setting and replace it with DAN, then you will have to truncate the UserPreferences table in order to reset the default settings for all users.

john_doyle

Hi @Jan_Dam
Check the SettingsItem table in the database. The LanguageCode entry should contain a comma-separated list of language codes with no white spaces.

SELECT *<br>&nbsp; FROM [SettingsItem]<br>&nbsp;WHERE [Key]='LanguageCode'

If the information in the table is incorrect you can update it under Admin Settings > Setting Items

If the information is correct, I would recommend truncating the UserPreferences table and restarting the cache builder service and IIS.

TRUNCATE TABLE UserPreferences;

Jan_Dam

Hi John,

That LanguageCode has the right value, ENU,DAN, and i can choose between DAN and ENU.

But the LanguageCodeDateTime seems to be wrong, that value is only ENU.

Can i change that to DAN? Or at least add DAN.

Best regards
Jan

john_doyle

@Jan_Dam I got mixed up with the language codes, but what I said still holds. You can add the DAN code to the LanguageCodeDateTime setting. If you only had ENU in that setting and replace it with DAN, then you will have to truncate the UserPreferences table in order to reset the default settings for all users.

Jan_Dam

I needed to restart the 2 web serveres, after i changed the entry in languagecodedatetime and truncated the userpreferences table.

But now i got the right setting, and everything is working.

Thank you.

Best regards 
Jan