Posted By Ben - DotNetNuke on 26 Jan 2012 03:08 PM
Before you do anything, create a backup of your database.
After you have done that, make sure you create a backup of your database.
After you have done that, try running a script like this:
DELETE FROM ProfilePropertyDefinition WHERE PropertyDefinitionID = '##'
replacing the ## with the actual number of the row you want to delete.
After you have deleted everything you want to delete, go to Host > Host Settings and click Restart Application
THis worked wonderfully. I had to run the script for each one, reset the application then reset IIS, and it worked perfectly. Thanks a ton!!