I assumed they were populated from the db table cmsPropertyData but I am seeing certain values sporadically load as empty when viewing the document in the CMS. At the same time the front-end page loses the value too.
However, inspecting the cmsPropertyData table shows that the value has been the same for every version for quite some time. Which would indicate the value is being grabbed from the XML or cache and that one or both of those is getting out of synch??
Where are CMS values populated from?
I assumed they were populated from the db table cmsPropertyData but I am seeing certain values sporadically load as empty when viewing the document in the CMS. At the same time the front-end page loses the value too.
However, inspecting the cmsPropertyData table shows that the value has been the same for every version for quite some time. Which would indicate the value is being grabbed from the XML or cache and that one or both of those is getting out of synch??
Any more on this?
I'm now seeing updates to a cmsPropertyData item where the new value is inserted into an old row that was NULL and a new row that is NULL added.
For example, I have set this property to 10 several times in a row. Each time it saves the latest as NULL and replaces the second-to-latest with 10.
1706046 12899 5B5B71F6-5A47-467D-9859-29AD4901BC5E 411 NULL NULL NULL NULL 1700539 12899 3B2A1AAC-2D4E-4198-A4E7-450D700B3F4B 411 10 NULL NULL NULL 1685180 12899 D3C6B81D-39FA-4D0A-9CBC-FB0A25BCB576 411 10 NULL NULL NULL 1682129 12899 4D572590-9E1D-4C3D-B4E8-688522F3A065 411 10 NULL NULL NULL 1674925 12899 FFA99F83-74BB-4757-9813-B3DE5916C584 411 10 NULL NULL NULL 1621230 12899 4B5A208E-04F8-40A3-A382-F3E59BD82359 411 20 NULL NULL NULL 1621054 12899 2548A833-8A09-4220-8669-860BF54DFDE5 411 NULL NULL NULL NULL 1621043 12899 F0D0293F-BD2F-48AF-B2CB-C08DC8164D97 411 NULL NULL NULL NULL 1621032 12899 C2EC846F-BA30-4817-97DA-8E13FC9466D1 411 NULL NULL NULL NULL
becomes
1709015 12899 D53E5668-61FD-4F96-BBA8-223CCC9A8699 411 NULL NULL NULL NULL
1706046 12899 5B5B71F6-5A47-467D-9859-29AD4901BC5E 411 10 NULL NULL NULL
1700539 12899 3B2A1AAC-2D4E-4198-A4E7-450D700B3F4B 411 10 NULL NULL NULL
1685180 12899 D3C6B81D-39FA-4D0A-9CBC-FB0A25BCB576 411 10 NULL NULL NULL
1682129 12899 4D572590-9E1D-4C3D-B4E8-688522F3A065 411 10 NULL NULL NULL
1674925 12899 FFA99F83-74BB-4757-9813-B3DE5916C584 411 10 NULL NULL NULL
1621230 12899 4B5A208E-04F8-40A3-A382-F3E59BD82359 411 20 NULL NULL NULL
1621054 12899 2548A833-8A09-4220-8669-860BF54DFDE5 411 NULL NULL NULL NULL
1621043 12899 F0D0293F-BD2F-48AF-B2CB-C08DC8164D97 411 NULL NULL NULL NULL
1621032 12899 C2EC846F-BA30-4817-97DA-8E13FC9466D1 411 NULL NULL NULL NULL
Apologies for formatting... it doesn't seem to like pasting from excel.
is working on a reply...