DNN: 6.0.1 (Upgraded very carefully from DNN 4.9.5 - no mysterious error until i decide to use Enable Localized Content)
Scenario: This DNN installation is hosted under a dedicated server {Windows Server 2008 R2, SQL Server 2005} and has about 5 primary sites.
Blog Module version: 4.1.1 (Latest version @
http://dnnblog.codeplex.com/)
Languages installed on site: en-US and fr-CA
Default site language is: fr-CA (en-US is fallback for default language)
I enabled Content Localization under Host Settings, then went to this portal in question and under
Admin > Languages, clicked on Enable Localized Content. Right after clicking on it waited patiently for it to complete. Unfortunately percentage counter had no progress other than displaying 0 %.
Then decided to check Admin > Log Viewer and many errors logged. Not sure, it is about core Blog or any other blog software installed on this dnn instance.
AssemblyVersion: 6.0.1
PortalID: 8
PortalName: Hello World
UserID: 1
UserName: host
ActiveTabID: 256
ActiveTabName: Languages
RawURL: /helloworld440/Admin/Languages/tabid/256/ctl/EnableContent/mid/3875/Default.aspx?RadUrid=cffe31e1-d034-4006-9056-1b2b48cad42a
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://dev.id.com/helloworld440/Admin/Languages/tabid/256/ctl/EnableContent/mid/3875/Default.aspx
UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 8cdd60a8-f512-4a29-82cd-774eb3c88ce3
InnerException: Unexpected end of file has occurred. The following elements are not closed: blogEntry, entries, blog, blogs. Line 5, position 378.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Xml.XmlTextReaderImpl.Throw
StackTrace:
Message: System.Xml.XmlException: Unexpected end of file has occurred. The following elements are not closed: blogEntry, entries, blog, blogs. Line 5, position 378. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ThrowUnclosedElements() at System.Xml.XmlTextReaderImpl.ParseElementContent() at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace) at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc) at System.Xml.XmlDocument.Load(XmlReader reader) at System.Xml.XmlDocument.LoadXml(String xml) at DotNetNuke.Common.Globals.GetContent(String Content, String ContentType) at DotNetNuke.Modules.Blog.Business.InterfaceController.ImportModule(Int32 ModuleID, String Content, String Version, Int32 UserID)
Source:
Server Name: WIN-*
The second error is:
AssemblyVersion: 6.0.1
PortalID: 8
PortalName: helloworld
UserID: 1
UserName: host
ActiveTabID: 256
ActiveTabName: Languages
RawURL: /helloworld/Admin/Languages/tabid/256/ctl/EnableContent/mid/3875/Default.aspx?RadUrid=cffe31e1-d034-4006-9056-1b2b48cad42a
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://dev.id.com/helloworld/Admin/Languages/tabid/256/ctl/EnableContent/mid/3875/Default.aspx
UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1f6b9cb2-827f-4bce-85dd-14150b832944
InnerException: The stored procedure 'dbo.Blog_ListComments' doesn't exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message: System.InvalidOperationException: The stored procedure 'dbo.Blog_ListComments' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.ListComments(Int32 EntryID, Boolean ShowNonApproved) at DotNetNuke.Modules.Blog.Business.CommentController.ListComments(Int32 EntryID, Boolean ShowNonApproved) at DotNetNuke.Modules.Blog.Business.InterfaceController.ExportModule(Int32 ModuleID)
Source:
Server Name: WIN-*
Please advise.