If, you were to click save on your member type in the back office it will create those missing properties...however, I would warn you that this can lead down a rocky road as I have recently found out when in a similar situation with a site I upgraded that had over 45,000 members!

I have plans to blog about this at some point in the future but it could be way off, however, I just found the following in my notes for when I do come to write the post:

Whatever you do don't follow the instructions in the warning!!!! Just hit save on your member type and the missing props will be generated. if you add a property as per the instruction you will kill the back office and won't be able to access the member type due to a duplicate property on the member type.

You have been warned!!!

From memory, what I think happened was that the member properties are created as expected BUT the corresponding property data is NOT which is what leads to all of the problems I encountered so DO try this locally first and backup backup backup.

In case it helps you please also see the following script that I eventually assembled to get myself out of the hole I found myself in:

-- umbracoMemberComments
INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1214, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

-- umbracoMemberFailedPasswordAttempts
    INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1215, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

-- umbracoMemberApproved
        INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1216, 1, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

    -- umbracoMemberLockedOut
        INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1217, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

    -- umbracoMemberLastLockoutDate
            INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1218, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

    -- umbracoMemberLastLogin
            INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1219, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

    -- umbracoMemberLastPasswordChangeDate
            INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1220, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

    -- umbracoMemberPasswordRetrievalAnswer
            INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1221, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

    -- umbracoMemberPasswordRetrievalQuestion
            INSERT INTO [dbo].[cmsPropertyData]
           ([contentNodeId]
           ,[versionId]
           ,[propertytypeid]
           ,[dataInt]
           ,[dataDecimal]
           ,[dataDate]
           ,[dataNvarchar]
           ,[dataNtext])
SELECT [contentNodeId],[versionId], 1222, null, null, null, null, null
    FROM [dbo].[cmsMember]
        INNER JOIN [dbo].[cmsPropertyData]
        ON [dbo].[cmsMember].[nodeId]=[dbo].[cmsPropertyData].[contentNodeId]
    GROUP BY [contentNodeId], [versionId]

You will notice each subquery has an ID, that ID corresponds to the id in the database in the [cmsPropertyType] table for the relevant property.

I hope this helps save you from at least some of the pain I experienced in this process.

Cheers, Simon

...and one other thing...even after fixing this I think I then discovered nobody could login still because the umbracoMemberApproved flag was false by default so I then had to run another script to update those values.

Hi Simon,

and thank you for quick response.

I'm aware of this problem that UmbracoMemberApproved is set to false by default. And I was fine with that Umbraco has added these new properties automaticcaly by itself. But I don't understand, why Umbraco 7.5 don't do it anymore?

Thanks for SQL statements. I'll try them on the test site first.

Kind regards Tomasz

Hi,

I'm also facing the same issue after upgrade from 6.1.6 to 7.12.3.

Was wondering if there was any resolution to this?

Thanks,
Pramod

is working on a reply...