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?
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);
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.
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?
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
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.
is working on a reply...