XF 1.5 Mass edit posts

[JackieChun]

I need to delete the following text from ALL posts on the forum. Can anyone help me with a phpMyAdmin query?

[URL='https://example.com']Link[/URL]

 

[AndyB]

Make sure you backup your database first.

UPDATE xf_post SET message = REPLACE(message, "[URL='https://example.com']Link[/URL]", '')

 

[JackieChun]

Thanks AndyB! If an extra set of eyes wants to look at the query before I run it, please feel free.

 

[Jake Bunce]

Thanks AndyB! If an extra set of eyes wants to look at the query before I run it, please feel free.

It's good.

 

[JackieChun]

I ran the query twice, and nothing happened. The text in question is still in the posts. Steps taken:

1) Choose the XenForo database in phpMyAdmin
2) Select the Query tab
3) Paste the command and press Submit Query

There was no confirmation or a message after I pressed submit.

 

[AndyB]

1) Choose the XenForo database in phpMyAdmin
2) Select the xf_post table
3) Select the SQL tab
4) Paste the command and edit as needed, press Go

 

[Jeremy]

You may be seeing a cached version of the post. If you edit a post in question, is the text you wanted to remove still there?

 

[JackieChun]

@Jeremy yes, the text is still there even when trying to edit, so it's not cached.

@AndyB When I select the xf_post table prior to selecting the SQL tab, the query box is automatically populated with the following on line 1:

SELECT * FROM `xf_post` WHERE 1

 

[AndyB]

the query box is automatically populated with the following on line 1:

SELECT * FROM `xf_post` WHERE 1

This is normal, just delete that line.

 

[JackieChun]

0 rows affected. (Query took 0.1227 sec)

 

[Paul B]

That would suggest the query does not match the content.

Double check the content you are targeting by using the bb code editor.

 

[JackieChun]

@Brogan I did use the bb code editor. The original query resulted in 1 rows affected, but that did not delete the actual text from the posts. Then I used instructions in @AndyB 's follow-up post, and that results in 0 posts affected.