Copied to clipboard

Flag this post as spam?

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


  • Pete 152 posts 176 karma points
    Jul 20, 2010 @ 10:15
    Pete
    0

    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??

  • Pete 152 posts 176 karma points
    Jul 22, 2010 @ 17:30
    Pete
    0

    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

     

     

  • Pete 152 posts 176 karma points
    Jul 22, 2010 @ 17:31
    Pete
    0

    Apologies for formatting... it doesn't seem to like pasting from excel.

Please Sign in or register to post replies

Write your reply to:

Draft