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

XF 1.4 CORRECT ME THAT SQL

Discussion in 'XenForo Questions and Support' started by jamalfree, Jan 30, 2016.

  1. jamalfree

    jamalfree Active Member

    PHP:
    update xf_post set `message`= replace (`message` ,  '[URL='http://(y)'][IMG]http://www.xxx.net/pic/thanx/7.gif[/IMG][/URL]' , '(y)');
     
  2. Mouth

    Mouth Well-Known Member

    Code:
    update xf_post set message = replace(message, '[URL=\'http://(y)\'][IMG]http://www.xxx.net/pic/thanx/7.gif[/IMG][/URL]', '(y)');
     
    Last edited: Jan 30, 2016
  3. jamalfree

    jamalfree Active Member

    didnt work

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''message' = replace('message', '[​IMG]
     
  4. Mouth

    Mouth Well-Known Member

    Edited. Minor syntax correction. Try again.
     
    jamalfree likes this.
  5. jamalfree

    jamalfree Active Member

    Thanks mouth
     

Share This Page