1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 Remove Smiley -> the code is left in posts. How to remove?

Discussion in 'XenForo Questions and Support' started by markku, Dec 13, 2014.

  1. markku

    markku Well-Known Member

    If I have a custom smiley with code :customsmiley: and then delete the smiley from the ACP, posts will still include the custom code :customsmiley:.

    Is running a MySQL query the only proper solution to get rid of the :customsmiley: references then?

    Can someone offer me a query to run? For forum posts / profile posts / conversations / resources (resource manager)...

  2. Brogan

    Brogan XenForo Moderator Staff Member

    This will do it for posts:
    UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
    You will have to perform a similar query for all other content types.

    Take a backup first.
    markku likes this.

Share This Page