Error message is located on left side under profile picture.  I followed a posting and delete the "status" field under profile management, however the problem still persist.  If i need to delete "status" column from database, which table should i delete it from.

DotNetNuke.Services.Exceptions.ModuleLoadException: The column name "Status" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument. The column 'Status' was specified multiple times for 'pu'. ---> System.Data.SqlClient.SqlException: The column name "Status" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument. The column 'Status' was specified multiple times for 'pu'. 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() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Active.Modules.Social.Data.MembersDB.MembersList(Int32 PortalId, Int32 RowIndex, Int32 MaxRows, Int32 CurrentUserId, Boolean FriendsOnly, Boolean FriendStatus, String Alpha, String Fields, String Query, Int32 QueryType, Int32 Sort, Int32 GroupId, Int32 RoleId, CurrentUserTypes CurrentUserType, Int32 SortColumn, String SortDirection, Boolean IsAdmin, Boolean OnlineOnly) at Active.Modules.Social.Controls.MembersList.BindMembersList(Int32 pg) at Active.Modules.Social.Controls.MembersList.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

PLEASE create a backup of your database before running any SQL scripts you find on this or any website.

You can run something like this to see which properties have been deleted, but are still in the database:



Then if you find the duplicated property that is causing the issue:



replacing 00 with the PropertyDefinitionID from the first script.