I'm having a lot of trouble with the blog module. It throws the following error message. I read somewhere on the DNN forum that if I clear the cache from host settings, it would start working. I did that and it worked only for 2 hours. This is a brand new site and I need to go live by this weekend. Could someone please help with this issue?

AssemblyVersion:7.3.2

PortalID:-1

PortalName:

UserID:-1

UserName:

ActiveTabID:-1

ActiveTabName:

RawURL:

AbsoluteURL:

AbsoluteURLReferrer:

UserAgent:

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:02bc7c54-6569-4117-b869-598e9133ca66

InnerException:Conversion failed when converting the nvarchar value 'SELECT * FROM (SELECT U.UserID, U.DisplayName, U.LastModifiedOnDate, V.[Prefix],V.[FirstName],V.[MiddleName],V.[LastName],V.[Suffix],V.[Unit],V.[Street],V.[City],V.[Region],V.[Country],V.[PostalCode],V.[Telephone],V.[Cell],V.[Fax],V.[Website],V.[IM],V.[Biography],V.[PreferredTimeZone],V.[PreferredLocale],V.[Photo], ROW_NUMBER() OVER(ORDER BY U.UserID) AS RowNum FROM ( SELECT UserID, PropertyName, PropertyValue + '$$$' + CAST(Visibility AS VARCHAR(5)) + '$$$' + ExtendedVisibility + '$$$' + CONVERT(VARCHAR(20), LastUpdatedDate, 20) AS PropertyValue FROM dbo.[vw_Profile] WHERE Deleted = 0 AND (PortalID ' to data type int.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:System.Data.SqlClient.SqlConnection.

So How can this issue be resolved?

Can someone please direct me to that thread? I am having the same issue. One of my pages where the blog module resides just goes blank and gives me that message. I keep restarting the application and clearing the cache but it keeps having that error.

Beth Vest