Hi Will,

Does this happen for every user or just a bot like this error shows? Also, is this coming from a custom view or the default journal summary?

The entries found in the event log all are the result of bots visiting the activity page (which is the default journal summary).

I noticed that it also occurs on profile view page, also when bots are visiting the page.

hope this helps.

Marc,
Will keep an eye out for this one, but since it is coming from bots I would suggest ignoring them right now. Things like this are very hard to troubleshoot. If you see something come from a user, please let us know and we can dig deeper.

It indeed are bots only till now. If I spot a regular user I'll let you know.

Hi Will,

Somehow I do have this entry again, but now also for users (I am the user). I just have added a second instance with vanity URLs enabled ( http://www.activemodules.com/activeforums/support/vanity-url-on-second-af-instance/ ) and deleted two old posts and reposted them with the vanity urls enabled.

In this forum instance I have the social integration enabled for job posts (Have created a new journal type for this and created two applications – one for topics and one for replies). Both belong to the same journal type. Both keys have been entered in the control panel of the second instance.

So when I deleted the two posts and added them once again (using same topic & content – copy/paste) I noticed that the AS journal went blank again. I have had this in the past but have never been able to pin point what might be causing this behaviour.

Do you have any suggestions for me on how to proceed to get my journal entries back (and hopefully ditch the below presented error from the eventlog)?

Thanks in advance,
Marc


AssemblyVersion: 5.6.2
PortalID: 1
PortalName: Domain
UserID: -1
UserName:
ActiveTabID: 272
ActiveTabName: Activity
RawURL: /activity.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.domain.com/activity.aspx
UserAgent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/534.24 (KHTML, like Gecko) Chrome/11.0.696.68 Safari/534.24
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 265eca46-438b-4987-8b8e-e439d26a2d5b
InnerException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at Active.Modules.Social.JournalController.Journal_List(Int32 PortalId, UserProfile SocialUser, Int32 ProfileId, Int32 GroupId, Int32 JournalTypeId, Int32 RowIndex, Int32 MaxRows, String FilterTypes, Int32 JournalMode, String JournalQuery)
Source:
Server Name: N/A

Marc,

In the journal type editor, Access Control tab, you can add an addition Application and get an additional key. I would do this for both the reply and create journal types. Use the additional keys for the new instance of AF.

Ben, I'm experiencing the same issue. Are you saying that we should be using a different App Key (topic/reply) for each instance of AF in the portal?

Ben ( & CSmith) ,

I believe this is exactly what I have done in the first place. I created a new journal type and two new app keys - one for forum postings and the other for the replies.

I will give it another go though and keep you posted.