Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • [email protected] 14 posts 114 karma points
    Dec 08, 2016 @ 09:07
    shay@ideomobile.com
    0

    Saving existing member with new property fail's

    (Umbraco version 7.5.0 assembly: 1.0.6073.15895)

    Hi, I add a new property to my 'customer' member.

    When saving a new member instance everything is OK.

    When saving an existing member instance the "save" fails and throws an exception:

    enter image description here

    why?

  • [email protected] 14 posts 114 karma points
    Dec 11, 2016 @ 09:33
    shay@ideomobile.com
    100

    the only solution i found was to add these rows manually from the DB

    INSERT INTO UmbracoCampusME.[dbo].[cmsPropertyData](contentNodeId,versionId,propertytypeid,dataInt,dataDate,dataNvarchar,dataNtext,dataDecimal)
    SELECT 
    CmsC.nodeid [contentNodeId],
    CV.versionid [versionId],
    CmsPT.id [propertytypeid],
    NULL [dataInt],
    NULL [dataDate],
    '' [dataNvarchar],
    NULL [dataNtext],
    NULL dataDecimal
    FROM UmbracoCampusME.[dbo].[cmsMember] CmsM 
        INNER JOIN UmbracoCampusME.[dbo].[cmsPropertyType] CmsPT ON CmsPT.Name like '%FIELD_NAME%'
        INNER JOIN UmbracoCampusME.[dbo].[cmsContent] CmsC ON CmsC.[nodeId] = CmsM.[nodeId] AND CmsC.[contentType] = CmsPT.[contentTypeId]
        INNER JOIN dbo.cmsContentVersion  CV on CmsC.nodeid = CV.ContentId
        LEFT JOIN UmbracoCampusME.[dbo].[cmsPropertyData] CmsPD ON CmsPD.[contentNodeId]= CmsM.[nodeId] AND CmsPD.[propertytypeid]=CmsPT.[ID]           
    
  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies