I am trying to save my custom profile properties to the DB but they don't seem to appear. Here is what I did:
Log in as admin & create a new profile property of type text, size 30 chars.
Create a function on a module that writes a value into this profile property using code behind.
Check the DB for the value and it doesn't exist in there. The definition however is there.
I used this code to check on the database:
SELECT PropertyCategory, PropertyName, *
FROM DNN_UserProfile up
INNER JOIN DNN_ProfilePropertyDefinition ppd
ON up.PropertyDefinitionID = ppd.PropertyDefinitionID
WHERE up.UserID = @UserID
If I try to get the profile property value from my vb code it works fine. But once the application resets my values are gone. It seems that they are only written to the cache and not moved to the database.
Any ideas on this one?