Register | Log In
Download Contact
Community > Community Exchange

Welcome to the Community Exchange

Welcome to the Community Exchange, a place where community members can exchange questions and answers related to DotNetNuke. If you would like more info about the Community Exchange, please visit this page in our Wiki. 

Ask a Question

Deleting Active Social Roles

I have uninstalled Active Social from my website, however, the roles created by the groups remain. I have been trying to delete the roles (20-30 roles) but keep getting the following error. 

Is there a easy way other to remove the role from individual member's account and then delete the roles? I have 7000 members and each one of them belonged to more than 1-2 group. 

Thank you. 

The Error:

anage
Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK__UserRoles__RoleI__108C44B2". The conflict occurred in database "web_comdb_", table "dbo.UserRoles", column 'RoleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK__UserRoles__RoleI__108C44B2". The conflict occurred in database "web_comdb_", table "dbo.UserRoles", column 'RoleID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.DeleteRole(Int32 roleId) at DotNetNuke.Security.Membership.DNNRoleProvider.DeleteRole(RoleInfo role) at DotNetNuke.Security.Roles.Internal.RoleControllerImpl.DeleteRole(RoleInfo role) at DotNetNuke.Modules.Admin.Security.EditRoles.OnDeleteClick(Object sender, EventArgs e) --- End of inner exception stack trace ---
Active Social
DNN social
asked 11/19/2012
Frozen DNN29
Frozen DNN
edited 11/19/2012
Frozen DNN29
Frozen DNN

2 Answers

In DNN 7, I get the following error when I attempt to edit a user profile.  I had AS on the site but deleted it shortly thereafter when it became integrated with DNN.  Any help is appreciated.  David

 

Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Could not load file or assembly 'Active.Modules.Social' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Active.Modules.Social' or one of its dependencies. The system cannot find the file specified. at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throw , Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, Boolean loadTypeFromPartialName, ObjectHandleOnStack type) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throw , Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeType.GetType(String typeName, Boolean throw , Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throw , Boolean ignoreCase) at DotNetNuke.UI.WebControls.EditControlFactory.CreateEditControl(EditorInfo editorInfo) at DotNetNuke.UI.WebControls.FieldEditorControl.BuildEditor(EditorInfo editInfo) at DotNetNuke.UI.WebControls.FieldEditorControl.BuildDiv(EditorInfo editInfo) at DotNetNuke.UI.WebControls.FieldEditorControl.CreateEditor() at DotNetNuke.UI.WebControls.FieldEditorControl.DataBind() at DotNetNuke.UI.WebControls.PropertyEditorControl.AddEditorRow(FieldEditorControl editor, WebControl container) at DotNetNuke.UI.WebControls.PropertyEditorControl.AddEditorRow(WebControl container, String name, IEditorInfoAdapter adapter) at DotNetNuke.UI.WebControls.CollectionEditorControl.AddEditorRow(Object obj) at DotNetNuke.UI.WebControls.PropertyEditorControl.CreateEditor() at DotNetNuke.UI.WebControls.ProfileEditorControl.CreateEditor() at DotNetNuke.UI.WebControls.PropertyEditorControl.DataBind() at DesktopModules.Admin.Security.DNNProfile.DataBind() at DotNetNuke.Modules.Admin.Users.ManageUsers.ShowPanel() at DotNetNuke.Modules.Admin.Users.ManageUsers.BindData() at DotNetNuke.Modules.Admin.Users.ManageUsers.OnLoad(EventArgs e) --- End of inner exception stack trace ---
answered 3 months ago Laura Petry 2
Laura Petry

please remove all users from a role prior to deleting a role.
answered 5 months ago Sebastian Leupold 697
Sebastian Leupold

  • So you are asking me to remove 7000 users from one role and then more 3500 from another role and then 2000 something from anther role manually?

    I was wondering whether there is a script where I can say "delete or remove user =" * or all" from role="2""

    Is that possible? If it is can you please tell share the script?

    Thanks. - Frozen DNN 5 months ago

Your Answer

In order to provide an answer to this question, you must Login

I am flagging this question because...
10 inform moderator flags remaining

I am deleting this question because...

I am flagging this answer because...
10 inform moderator flags remaining

Flagging a Post

You have already flagged this post. Clicking "Remove Flag" below will remove your flag, thus reducing the count by one as well.

I am deleting this answer because...

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP