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

Smiley paths need updating after import

Discussion in 'Installation, Upgrade, and Import Support' started by CyclingTribe, Nov 25, 2011.

  1. CyclingTribe

    CyclingTribe Well-Known Member

    I've noticed that some posts contain references to the old URL for smilies so need a query to update them in the POST table please ...

    Old path:
    New path:
    I'd rather someone with the proper know-how volunteered a query than hazard a guess and fudge it all up ... :eek:
  2. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
    So for that it would be:
    UPDATE xf_post SET message = REPLACE(message,'http://img.cyclechat.co.uk/public/style_emoticons/default/','http://img.cyclechat.co.uk/styles/default/xenforo/smilies/');
    Take a backup first though.
    GeeksChat likes this.
  3. CyclingTribe

    CyclingTribe Well-Known Member

    Thanks again ... maaaannnnn you're quick!!! :ROFLMAO:

    [Edit: I had to take this part out of the query (for the two instances where it is shown): http://img.cyclechat.net/ ]

Share This Page