Copied to clipboard

Flag this post as spam?

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


  • Michael Nielsen 82 posts 361 karma points
    Jul 11, 2012 @ 10:38
    Michael Nielsen
    0

    Backend lost property value

    I have a property that has lost it's value in the backend. The value is still present in the database and in the contentxml, but not in the field in the backend and it is not outputtet in the front end.

    This is how the property is set up

    How it looks in the backend

    And how it looks in the database

     

    Can anyone help with what's going on and how to correct it?

  • Jeroen Breuer 4866 posts 12165 karma points MVP 3x admin c-trib
    Jul 11, 2012 @ 13:02
    Jeroen Breuer
    0

    That is the xml value, but you also have a value in the database. It's probably somewhere in the cmsPropertyData table. For DAMP I use a query to get the content from the database. It might help:

    //This sql get's all the newest versions of the documents which store the DAMP xml and contain the id of the current media item.
    string sql = string.Format(@"
    select cpd.contentNodeId as nodeId, cpd.dataNText as xmlValue, cpt.Alias as propertyAlias from cmsDocument cd
            inner join cmsPropertyData cpd ON cd.nodeId = cpd.contentNodeId
            inner join cmsPropertyType cpt ON cpd.propertytypeid = cpt.id
    where cd.newest = 1
    and cd.versionId = cpd.versionId
    and cpd.dataNtext like '<DAMP fullMedia="""">%'
    and cpd.dataNtext like '%{0}%'", media.Id);

    Jeroen

  • Michael Nielsen 82 posts 361 karma points
    Jul 11, 2012 @ 15:13
    Michael Nielsen
    0

    Hi Jeroen

    I found out that I have 4 property entries in cmsPropertyData table for each node (why I do not know).

    But if I copied the value from dataInt to dataNvarchar (or dataNtext, can't remember which right now), the value reappeared in the backend, but the value does not output in frontend, not even after publishing all nodes again.

Please Sign in or register to post replies

Write your reply to:

Draft