Normally when you go to admin->user accounts->manage profile properties you can add a profile field, choosing a data type for it. For some reason the drop down doesn't appear in my installation. Please see here:

I've tried to get around this by adding a field on a different installation of DNN (it all works fine there) and copying the resulting entry from that installation's ProfilePropertyDefinition table to my installation's table. As a result the field now appears in the list of fields in "admin->user accounts->manage profile properties" and properly as a date field, but when I go to edit the profile of any user I get this module load exception:

UserName: koomaadmin
ActiveTabID: 42
ActiveTabName: User Accounts
RawURL: /koomadnn/Admin/UserAccounts/tabid/42/ctl/Profile/UserID/2/Default.aspx
AbsoluteURL: /KoomaDNN/Default.aspx
AbsoluteURLReferrer: http://localhost/koomadnn/Admin/UserAccounts/tabid/42/ctl/Profile/UserID/2/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 36cd16a4-3a38-44e2-bb69-3dcb55301457
InnerException: Object reference not set to an instance of an object.
FileName: C:\Inetpub\wwwroot\Kooma_DNN\Library\Controls\PropertyEditor\Edit Controls\DateEditControl.vb
FileLineNumber: 112
FileColumnNumber: 17
Method: DotNetNuke.UI.WebControls.DateEditControl.get_Format
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.UI.WebControls.DateEditControl.get_Format() in C:\Inetpub\wwwroot\Kooma_DNN\Library\Controls\PropertyEditor\Edit Controls\DateEditControl.vb:line 112 at DotNetNuke.UI.WebControls.DateEditControl.get_StringValue() in C:\Inetpub\wwwroot\Kooma_DNN\Library\Controls\PropertyEditor\Edit Controls\DateEditControl.vb:line 145 at DotNetNuke.UI.WebControls.DateEditControl.OnPreRender(EventArgs e) in C:\Inetpub\wwwroot\Kooma_DNN\Library\Controls\PropertyEditor\Edit Controls\DateEditControl.vb:line 195 at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Can anyone advise please?

Not that I'm aware of. Relevant sections of my web config:

<system.web>

        <authentication mode="Forms">
            <forms name=".DOTNETNUKE" protection="All" timeout="60" cookieless="UseCookies"/>
        </authentication>

        <membership defaultProvider="AspNetSqlMembershipProvider" userIsOnlineTimeWindow="15">
            <providers>
                <clear/>
                <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="SiteSqlServer" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="false" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" requiresUniqueEmail="false" passwordFormat="Encrypted" applicationName="DotNetNuke" description="Stores and retrieves membership data from the local Microsoft SQL Server database"/>
            </providers>
        </membership>

</system.web>

<dotnetnuke>

    <profiles defaultProvider="DNNProfileProvider">
            <providers>
                <clear/>
                <add name="DNNProfileProvider" type="DotNetNuke.Security.Profile.DNNProfileProvider, DotNetNuke.Provider.DNNProvider" providerPath="~\Providers\MembershipProviders\DNNMembershipProvider\"/>
            </providers>
        </profiles>
 </dotnetnuke>

Sorry for nagging, but can anyone help me with this? At least identify the tables and/or config files that are involved in creating the custom profile fields? I know that the ProfilePropertyDefinition takes part in this, but.. anything else? How is the list of data types built? Is it an enumeration contained somewhere?