Sebastian Leupold wrote:
can you please check, wether there is a single record per language in portalLocalization table.
Hello Sebastian,
Many thanks for your persistence :)
Is there anything peculiar in the SELECT found below?
E.g. it is expected to have a row with 'blank' CultureCode (the 2nd. row in the result set)?
What's about the NULLs HomeTabId, or the duplicated UserTabId and RegisterTabId values? Is this normal?
Note: fr-FR was apparently running fine. The problems started when trying to add es-ES
To test what happens, I've delete the row with blank CultureCode.
I've got the same error when I've edited the es-ES language:
DotNetNuke.Services.Exceptions.ModuleLoadException: Sequence contains more than one element ---> System.InvalidOperationException: Sequence contains more than one element at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source) at DotNetNuke.Entities.Modules.ModuleController.AddModulePermission(ModuleInfo& objModule, Int32 portalId, String roleName, PermissionInfo permission, String permissionKey) in C:\Builds\Maintenance\WorkingDirectory\Library\Entities\Modules\ModuleController.vb:line 108 at DotNetNuke.Entities.Modules.ModuleController.LocalizeModuleInternal(ModuleInfo sourceModule) in C:\Builds\Maintenance\WorkingDirectory\Library\Entities\Modules\ModuleController.vb:line 161 at DotNetNuke.Entities.Modules.ModuleController.LocalizeModule(ModuleInfo sourceModule, Locale locale) in C:\Builds\Maintenance\WorkingDirectory\Library\Entities\Modules\ModuleController.vb:line 1331 at DotNetNuke.Entities.Tabs.TabController.CreateLocalizedCopy(TabInfo originalTab, Locale locale) in C:\Builds\Maintenance\WorkingDirectory\Library\Entities\Tabs\TabController.vb:line 1154 at DotNetNuke.Modules.Admin.Languages.EditLanguage.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
select PortalID,CultureCode,HomeTabId,UserTabId,AdminTabId,SplashTabId,RegisterTabId
from PortalLocalization order by CreatedOnDate
PortalID CultureCode HomeTabId UserTabId AdminTabId SplashTabId RegisterTabId CreatedOnDate
----------- ----------- ----------- ----------- ----------- ----------- ------------- -----------------------
0 en-US NULL 181 38 NULL 181 2010-02-09 13:23:49.860
0 36 191 38 NULL 191 2010-12-03 12:46:51.337
0 fr-FR 196 215 38 196 213 2010-12-09 17:04:00.233
0 es-ES NULL 181 38 NULL 181 2011-02-28 13:44:45.090
In the Languages table (select LanguageID,CultureCode from Languages), I have:
LanguageID CultureCode
----------- -----------
1 en-US
2 fr-FR
5 es-ES
In the PortalLanguages I have:
select PortalLanguageID,PortalID,LanguageID,CreatedOnDate,IsPublished from PortalLanguages
PortalLanguageID PortalID LanguageID CreatedOnDate IsPublished
---------------- ----------- ----------- ----------------------- -----------
1 0 1 2009-09-14 22:27:42.020 1
4 0 2 2010-12-13 07:09:21.793 1
7 0 5 2011-02-28 14:24:48.847 0
Thanks,
Horacio.-