XF 1.4 Mass replacing text in posts

[bloop]

I recently changed domain names and we have some posts that use the old forum domain name. How would I go about doing this? Through sql queries?

I've tried using Post Content Find / Replace 1.0.0 but the amount of posts that it needed to replace was too large and it ended up freezing mysql and server.

Thanks for reading!

 

[Paul B]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

 

[bloop]

Thanks @Brogan, is there a way to do per node or thread? Would the server freeze up if I did that through phpmyadmin? Around 60k threads would need updating

I found another post of yours regarding updating prefixes, could you tell me if this would work?

UPDATE xf_post SET where node_id in (9,15,18) message = REPLACE(message,'current_content','new_content');

 

[Mike]

In theory you can do it but it's much more complex than that since the node isn't part of the post.

If you have a large forum, it may be worth closing the forum when running the query, but otherwise it may take some time, but it should work.

Please take a backup before running any queries like that. It can't necessarily be undone.

 

[bloop]

I ran the query successfully, but I noticed some (not all) threads still show the old content, but when I click edit for the post with the old content it automatically changes back to the new content name. Not sure what to do now, I thought the next thing I should do is to rebuild posts but there isnt an option for that.

What should I do?

Thanks for the help! @Mike @Brogan

 

[Paul B]

but when I click edit for the post with the old content it automatically changes back to the new content name

That sounds to me like some sort of caching is involved.

Try disabling and enabling the 'Cache BB Code output' option.

 

[bloop]

Thanks @Brogan that sorta did it. When I have bb code disabled all posts were replaced with the new content but when I enabled it again, some posts still had the old content but less than before. I'm running maxcdn as well so I'm assuming that may be causing it.

Anyhow, the amount of posts that had incorrect info was small so I just ended up manually editing each one.

Cheers

 

[rdn]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

I have some issue Brogan.
I want to replace:

Old content: ’
Correct character: '

Here's my query:

UPDATE xf_post SET message = REPLACE(message,'’',''');

But I got an error:

Static analysis:
1 errors were found during analysis.

1. Ending quote ' was expected. (near "" at position 60)

 

[rdn]

Any advice from you @Mike or @Chris D ?
Thanks!

 

[wang]

Try this.

UPDATE xf_post SET message = REPLACE(message,'’', " ' ");

But make a backup first of your post table.

 

[Paul B]

Try escaping it.

 

[rdn]

Try this.

UPDATE xf_post SET message = REPLACE(message,'’', " ' ");

But make a backup first of your post table.

But that will add space.
I just want to replace ’ with a single '.

 

[rdn]

Try escaping it.

UPDATE xf_post SET message = REPLACE(message,'’','\'');

That one?

 

[rdn]

This works for me:

UPDATE xf_post SET message = REPLACE(message,'’','''');

 

[upnet]

Is it safe to run a similar query to update the message field where user id = 42424242 on a database with 3 million+ posts? We want to remove all instances of "replace 7" in a certain users posting history.

UPDATE xf_post SET message = REPLACE(message,'replace 7','') WHERE user_id = 42424242

 

[Paul B]

Yes, that's fine.

Take a backup first just in case.

 

[upnet]

Worked well, thanks.

 

[karabaja]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Thank you! This worked very well for single character replacment in posts after migration from vB to XF.

Could you please write query for replacment in thread titles and usernames?