I installed Dynamic Registration on my site (parstars.com) and accidentally created a second Email profile field.  This causes an error on my Active Social Friends tab and Find Friends (memberlist).  I deleted the extra email profile field, then ran the following to remove it from the DB:

 

Under Host/SQL:

Select top 10 * from PRofilePropertyDefinition

Where Deleted <> 0

 

IF you see you field there then run this:

DELETE from PRofilePropertyDefinition

Where Deleted <> 0

 

I also restarted the application.

 

I still have an error on those pages though.  Dynamic Registration folks said it might need to have a schedule run to restart the Active Social aspect and suggested I contact you guys.   Their words: “or if it the table is generated (as our Dynamic User Directory module is) as a scheduled task under host/schedule that you will need to kick off the scheduler again.”

 

What schedule might I have to run in order to fix this?  I don’t see anything in there, and it has been about 24 hours since I fixed the DB item.

 

This is the error my admin login sees on the friends tab:

 

otNetNuke.Services.Exceptions.ModuleLoadException: Column names in each table must be unique. Column name 'Email' in table '#ProfileResult' is specified more than once. ---> System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Email' in table '#ProfileResult' is specified more than once. 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(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at Active.Modules.Social.Data.MembersDB.Members_List(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, String SortColumn, String SortDirection) at Active.Modules.Social.Data.MembersDB.Members_List(Int32 PortalId, Int32 RowIndex, Int32 MaxRows, Int32 CurrentUserId, Boolean FriendsOnly, Boolean FriendStatus, String Alpha, String Fields, String Query, Int32 Sort, Int32 RoleId, CurrentUserTypes CurrentUserType, String SortColumn, String SortDirection) at Active.Modules.Social.Controls.MembersList.BindMembers(Int32 pg) at Active.Modules.Social.Controls.MembersList.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Any help on this issue?

It still hasn't fixed itself in any scheduler kicking off.

I just realized this also doesn't allow me to manage my memberlist, either.

This is the exact same type of issue I am having:

http://www.activemodules.com/active...r-upgrade/

How do I get a ticket open with Will in order to fix this problem? I can't help members on the site because I can't access members at all, no friends listing, etc.

Hi Donald, that other issue is indeed fixed by scripts like those. I believe you may still have the Profile Property in the table though.

Please run this

SELECT * FROM ProfilePropertyDefinition

And double check that there is nothing with a PropertyName 'Email' it doesn't matter if it is currently deleted or not, it should not exist in that table.

There is an email propertyname in that table.

How do I remove that if it shouldn't be there?

DELETE FROM ProfilePropertyDefinition WHERE PropertyName = 'Email'

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

That did the trick, thank you SO much!!