Copied to clipboard

Flag this post as spam?

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


  • Anton Gildebrand 3 posts 22 karma points
    Feb 21, 2017 @ 14:59
    Anton Gildebrand
    0

    Can't edit some macro picker macros

    Hi!

    We're experiencing some issues with the macro picker. Some macro instances we can't edit, while other macros in the same macro picker works perfectly fine to edit. The macros that we can't edit is missing their "Edit"-icon (the pen).

    A further look into what causes this reveals that the edit-icon is missing because of that the macro object is lacking the details property. I can see that the macros that I can't edit is missing the details property as well as the macroParamsDictionary property.

    What could be causing this, and how can we solve it?

  • Anton Gildebrand 3 posts 22 karma points
    Feb 22, 2017 @ 19:12
    Anton Gildebrand
    0

    I discovered that this was because of invalid characters in the macros. I did a batch update in the database and resolved the issue. Below is the SQL statement I used to fix the issue.

    Please be careful before using the SQL statement below, be sure you know what you're doing and do make a backup first

    UPDATE cmsPropertyData
    SET dataNtext = CAST(REPLACE(CAST(dataNtext as NVarchar(max)), '/', '/') AS NText)
    WHERE dataNtext LIKE '%/%'
    
Please Sign in or register to post replies

Write your reply to:

Draft