Hello everybody.

I installed Clean DNN 4.3.0 other day and trying to modify one of the super user accounts. I clicked on "Manage Profile" and i got following error:

A critical error has occurred. Conversion from string "" to type 'Integer' is not valid.

I created new super user account but it did same thing. ordinary accounts on each portal don't have this problem but host accounts. Does anybody have same problem?

Anyway, I found the solution almost accidentaly. I am sure the DNN developers will fix this eventually.

Here is how to fix:

1. Go to Mssql database.

2. Find "users" table, find user ID of the super user account. Remember that number.

3. Find "UserProfile" table.  The table has following fields: ProfileID, UserId, propertyDefinitionID, PropertyValue, PropertyText, Visibility, and lastupdatedDate.

4. Now, we need to insert new record on the table.

   1) You can leave ProfileID blank. It's auto-increment value so don't worry about it.

   2) UserId would be one's we got from "users" table

   3) For propertyDefinitionID, we use 18. By default, 18 is for timezone.

   4) For PropertyValue, we put -300 for now. It's Eastern time. We can change this later. so just put -300 for now.

   5) <NULL> for PropertyText

   6) 0 for Visibility (although i don't know what it does.)

   7) For LastUpdatedDate, i just copy&paste from previous record. you can put "6/26/2006 6:16:03 PM" if you like.

Now, go to superuser account and click on "Manage Profile"! woooohoooo it's fixed!

I am so noob to DNN. Can anybody tell me how I can fix this problem in sexy way? lol (not like,, my way,,it's dumb caz i have to do this everytime i create super user account.)