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.
- declare @TextDataTypeID int
- Set @TextDataTypeID = (Select EntryID from Lists where ListName = 'DataType' and Value = 'Text')
-
- select * from lists where ListName = 'DataType' and Text like 'Active.Modules.Social.Controls.%'
-
- Update ProfilePropertyDefinition set DataType = @TextDataTypeID where DataType in (
- select EntryID from lists where ListName = 'DataType' and Text like 'Active.Modules.Social.Controls.%'
- )
Once you have done this, the following query should not display any entries whatsoever:
- 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.
Article ID: 1909, Created: October 11, 2013 at 3:05 PM, Modified: August 25, 2014 at 2:37 PM