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

XF 1.3 Database Query Needed

Discussion in 'Installation, Upgrade, and Import Support' started by wickedstangs, Jul 28, 2014.

  1. wickedstangs

    wickedstangs Well-Known Member

    Did the SMF to Xenforo move and need a database query for Images..

    All the images moved with [img width=449 height=480] and need it to be
    Code:
    [img]
     
  2. wickedstangs

    wickedstangs Well-Known Member

    Would it be something like this????
    Code:
    UPDATE my_db_name.xf_post
    SET my_db_name.xf_post.message
    = REPLACE (my_db_name.xf_post.message ,'[imgXXXXX]',' ')
    WHERE my_db_name.xf_post.message like '[img]';
     
  3. AndyB

    AndyB Well-Known Member

  4. borbole

    borbole Well-Known Member

    It would be best to use the mod linked by Andy above. But if you would rather run the query, try this:

    Code:
    UPDATE xf_post
    SET message = REPLACE(message,'[img width=449 height=480]','[img]');
     
    wickedstangs likes this.

Share This Page