YAFLogo

oldgeorge
  • oldgeorge
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
7 years ago
Hello everyone, I had an old DNN forum/portal running DNN 7 and an older version of YAF that fell victim to a massive spambot attack (over 50.000 accounts created) and I had to take it down for some time until I could resolve the issues.

Now it's back on, security issues tightened, upgraded to DNN 8.0.4 and latest YAF. However I have two issues:

a)Avatars are still not syncing with user profiles (they didn't sync before either, but now I'd like to try and fix that)

b)Deleting the spam accounts in DNN did not result in their removal from YAF. I plan to run

select * from yaf_user where [Name] not in (Select Username FROM Users) and userID>1

and run yaf_user_delete from each one. Is this the correct approach? Do I need to take something else into consideration?

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA
7 years ago

a)Avatars are still not syncing with user profiles (they didn't sync before either, but now I'd like to try and fix that)

Originally Posted by: oldgeorge 

Did you see any issues in the YAF Event log?

Did you disabled hot linking on your server?

b)Deleting the spam accounts in DNN did not result in their removal from YAF. I plan to run

Originally Posted by: oldgeorge 

Technically if you upgraded yaf after you upgraded dnn then when you delete a user in dnn it also should delete it in YAF. But is possible that the process changed in dnn. Its possible the injected Stored Procedure doesnt work anymore.

select * from yaf_user where [Name] not in (Select Username FROM Users) and userID>1

and run yaf_user_delete from each one. Is this the correct approach? Do I need to take something else into consideration?

Originally Posted by: oldgeorge 

yes if you do that manually that would be the correct way.

oldgeorge
  • oldgeorge
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
7 years ago

[

Did you see any issues in the YAF Event log?

Did you disabled hot linking on your server?

Originally Posted by: tha_watcha 

I'm seeing this:

Error while Syncing dnn userprofile with Yaf

System.NullReferenceException: Object reference not set to an instance of an object.

at DotNetNuke.Common.Utilities.UrlUtils.EncryptParameter(String value, String encryptionKey)

at YAF.DotNetNuke.Components.Utils.ProfileSyncronizer.SaveDnnAvatar(String fileId, Int32 yafUserId, Guid portalGUID, YafBoardSettings boardSettings)

at YAF.DotNetNuke.Components.Utils.ProfileSyncronizer.SyncYafProfile(Int32 yafUserId, YafUserProfile yafUserProfile, IUserData yafUserData, UserInfo dnnUserInfo, Guid portalGUID, YafBoardSettings boardSettings)

at YAF.DotNetNuke.Components.Utils.ProfileSyncronizer.UpdateUserProfile(Int32 yafUserId, YafUserProfile yafUserProfile, IUserData yafCurrentUserData, UserInfo dnnUserInfo, MembershipUser membershipUser, Int32 portalID, Guid portalGuid, YafBoardSettings boardSettings, Boolean ignoreLastUpdated)

And also this:

Error In UserCleanUpTask Task

System.Threading.ThreadAbortException: Thread was being aborted.

at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout)

at System.Threading.Thread.Sleep(Int32 millisecondsTimeout)

at YAF.Core.Tasks.UserCleanUpTask.RunOnce()

[quote=oldgeorge;70513]

Also, not sure what you mean about hot linking? Is it a particular DNN or YAF option?

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA
7 years ago
What version of YAF are you using?
oldgeorge
  • oldgeorge
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
7 years ago
YAF_DNN_223, upgraded from an early 2.0.X version
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA