XF 2.2 Mysql strings to replace characters

[Black Tiger]

I need 3 mysql strings to replace things.
First one is like this:

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

but this gives an error in the used syntax at "> it says. While there is only one ' in the string there.

The second one is the same, but then for < which needs to be replace to a < character.

The third one is trickier. I need the " be changed to the " character.

Maybe some others can benefit from this too as with import of forums, these characters are not converted.

 

[Paul B]

Are you using phpMyAdmin?

Ensure the delimiter is not set as a ; as that will conflict with the string in the query.


Just delete it from the field or use another character if you want to run multiple queries.

Before:


Queries (note I am using | as the delimiter between queries):


After:

 

[Black Tiger]

Yes, using phpmyadmin.

Just delete it from the field or use another character if you want to run multiple queries.

Ahaaa... didn't know that.

Worked like a charm. Great, thanks!

I encountered also that some characters like éé and óó were changed by ?? when importing SMF. I have to do these manually because the ?? is always the same, but the characters the ' is put above are different like here in my example so I presume this can't be fixed by a query.

 

[beerForo]

There's also this

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

 

[Black Tiger]

Thank you but...

Allows an administrator to do a regular expression

I'm always very bad with regexp, I normally don't use that.