User Profile tables are not removed from SQL when deleting in Administration > Users > Manage Profile Types
I have been trying to debug other issues related to User Profiles, and creating/deleting Profiles, but the tables and foreign key relationships are not being removed in my SQL database even after deleting the Profiles from the Sitefinity Admin control panel.
Hi Dave,
Would it be possible to clarify what foreign key relationships are not removed when a user is deleted? I have performed multiple tests on my end and every time when a user is deleted all the records from the user related tables are removed.
Regards,
Kaloyan
Telerik
Hi Kaloyan,
I'm actually referring to deleting the entire User Profile itself. I would assume that the table and foreign relationships associated with that User Profile would be removed as well.
Thanks,
Dave
I am getting the same thing. To reproduce it.
1. Create a UserProfile (Administrator > Users > Manage Profile Types > Create Profile Type
2. Save a profile type called <whatever>
Sitefinity then creates a [dbo].[whatever] table and and entry in [dbo].[sf_user_profile]
3. Delete the profile type <whatever> and the table and entry in [sf_user_profile] remain. You cannot reuse that profile name.
What am I missing.
Steve
Hello all,
I have tested and confirmed the behavior in question. This is a bug and I have logged it accordingly. You can follow the bug's progress as well as vote for it in order to increase its priority in our Portal. We will do our best to fix this behavior in our future releases.
Please excuse us for any inconvenience caused.
Regards,
Ivan D. Dimitrov
Telerik