Bug? Page name not working

Dec 4, 2013 at 11:11 AM
I have a situation where a website workin Ok with 2 lanaguges (fr-Fr,en-GB) was updated to enabled the dutch lanaguge (nl-NL)

After this the fr-FR (Default) is working, the nl-NL is working, but although the en-GB is selectable it doesn't work!!

the page name displayed when you select en-GBN is always the lanaguge last looked at i.e. it does refresh and doesn't update.

Anyone else seem this bug?...and is there some work around?.

Regards,
Dave.
Dec 4, 2013 at 11:23 AM
Ok...I got that slightly wrong...

1 - the fr-Fr wasworking OK
2 - Enabled nl-NL - working Ok
3 - Enabled en-GB - not working.

There are no records in the DB for en-GB and when you edit en-GB it updated the last language you edited, as if you've not switched languages with the dropdown!
Developer
Dec 4, 2013 at 1:50 PM
Hi David,

I remember this problem on an older version.

Witch version of PageLocalization and DNN are you using ?

Regards,
Sacha
Dec 4, 2013 at 2:03 PM
hi Sacha,

It's PageLocalization v6.1 and 6.2.6 of DNN.

Assuming the PL versioning is correct, it should be the latest.....Is it the DNN version causing an issue, you think???

Dave.
Dec 4, 2013 at 2:07 PM
My thought is to re-create the missing DB records for en-GB....is there a SPROC I should call to do this??
Developer
Dec 4, 2013 at 4:03 PM
David,

There is

Apollo_TabLocalizationFillDefaults
@LocalPortalID INT ,
@LocalCreatedByUserId INT

witch call

Apollo_TabLocalizationFillDefaultsSingle

@Locale NVARCHAR(15) ,
@PortalID INT ,
@CreatedByUserId INT

Normally this is callled each time you go to the admin module.

Maybe a error occurs in the SP.

Regards,
Sacha
Dec 4, 2013 at 4:09 PM
Ok thx Sacha, I'll check it out and get back to you.
Dec 4, 2013 at 4:54 PM
OK the portal localization table is corrupt.
I don't know how but I have an invalid entry in there for the culture.

SELECT TOP 1000 [PortalID]
  ,[CultureCode]
FROM [dbo].[PortalLocalization]
where PortalID = 6

PortalID CultureCode

6
6 en-US
6 fr-FR
6 nl-NL

The en-US is now deactivated, but the empty entry should be "en-GB"

After going into the DNN>Admin>Languages and changing the default language to "en-GB" and then back to "fr-FR" I get this..

PortalID CultureCode

6
6 en-GB
6 en-US
6 fr-FR
6 nl-NL

The Page Localization then starts to work!!


So it appears there is a bug in DNN somewhere that creates a empty culture in the portal localization table, maybe on portal template import/export.

the fix is to simply set the default culture of the site to the missing language and back again and it starts working OK.

Thanks for you help Sacha,

Dave.
Developer
Dec 4, 2013 at 5:05 PM
Hi,

It's something i already seen when you update the site settings without the culturecode in the url.

(for example when you use localization extensions)

Regards,
Sacha