Error adding items to journal

Oct 13, 2012 at 4:34 PM

DNN 6.2.4 + AF 5.0.1

Add new Post and Reply to Post are not added to journal. In event viewer I see:

 

AssemblyVersion: 6.2.4

PortalID: 0

PortalName: Nexxxxxxxxxxxx

UserID: 222

UserName: xxxxxxx

ActiveTabID: 62

ActiveTabName: Forum

RawURL: /Forum/tabid/62/afv/post/aff/5/language/it-IT/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://localhost/Forum/tabid/62/afv/post/aff/5/language/it-IT/Default.aspx

UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: d869472c-51e1-49de-852b-812c60458ba5

InnerException: Object reference not set to an instance of an object.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: DotNetNuke.Modules.ActiveForums.Social.AddTopicToJournal

StackTrace:

Message: System.NullReferenceException:Object reference not set to an instance of an object.. in DotNetNuke.Modules.ActiveForums.Social.AddTopicToJournal(Int32 PortalId, Int32 ModuleId, Int32 ForumId, Int32 TopicId, Int32 UserId, String URL, String Subject, String Summary, String Body, Int32 SecurityOption, String ReadRoles, Int32 SocialGroupId) in DotNetNuke.Modules.ActiveForums.af_post.SaveTopic()

Source:

Server Name: xxxx

 

Before open an issue what may be the problem?

Oct 13, 2012 at 8:18 PM

Mmmm loking for some info with profiler i've notice that there is a call to the store:

exec dbo.Journal_GetByKey @PortalId=0,@ObjectKey=N'5:94474'

executing this store in management studio return no row.

previous this exec the profiler not show nothing that add to journal. The trace is:

 

........

UPDATE dbo.activeforums_UserProfiles SET TopicCount = ISNULL((Select Count(t.TopicId) from dbo.............
exec dbo.activeforums_Subscriptions_Subscribers @PortalId=0,@ForumId=5,@TopicId=94474,@SubType=1
exec dbo.Journal_GetByKey @PortalId=0,@ObjectKey=N'5:94474'

.......

Oct 20, 2012 at 9:15 PM

The module is throwing an exception in

foreach (string s in roles.Split(';'))
			{
				if ((s == "-1") | (s == "-3"))
				{
					if (! (ji.SecuritySet.Contains("E,")))
					{
						ji.SecuritySet += "E,";
					}
				}
				else
				{
					ji.SecuritySet += "R" + s + ",";
				}

			}

because SecuritySet is null for some reason

Oct 21, 2012 at 1:14 PM
I found that is related to script conversion. Tomorrow I'll search the problem