Could not load file or assembly 'Active.Modules.Social' when editing a user profile

DNN > Troubleshooting
 Could not load file or assembly 'Active.Modules.Social' when editing a user profile
 
If you encounter the above error message when attempting to Edit User Accounts in DNN, it's because Active Social was installed at one point, and was uninstalled later, but the custom properties it adds onto DNN user accounts were not removed during that uninstallation. The SQL queries below change those custom properties from a data type that requires Active Social to parse, to simple text. It fixes this error without deleting that information.
 
Open SQL server management studio and select the database used by the DNN site that presented this error. Back it up before making any changes. Create a new SQL query using that database. Paste the following text into that query and execute it.
 

 
  1. declare @TextDataTypeID int
  2. Set @TextDataTypeID = (Select EntryID from Lists where ListName = 'DataType' and Value = 'Text')
  3.  
  4. select * from lists where ListName = 'DataType' and Text like 'Active.Modules.Social.Controls.%'
  5.  
  6. Update ProfilePropertyDefinition set DataType = @TextDataTypeID where DataType in (
  7.     select EntryID from lists where ListName = 'DataType' and Text like 'Active.Modules.Social.Controls.%'
  8. )
Once you have done this, the following query should not display any entries whatsoever:
 

 
  1. select * from lists where ListName = 'DataType' and Text like 'Active.Modules.Social.Controls.%'
After any database change, the application pool should be restarted for it to take effect. If you encounter the error again after performing these changes, contact a support technician.

Add Feedback