MyBB Community Forums

Full Version: What to do about \'s after importing?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
(2017-06-09, 02:57 PM).m. Wrote: [ -> ]^ please see Escape character

Thank you for all your help! I'm going to give this a shot shortly...

Phew! That did it! Thanks again... I just ran the following query and got the posts straightened out.

UPDATE mybb_posts SET message = REPLACE(message , '\\' , '')

One last question. How would I fix this in signatures?:

shudders and says...\"Oh crap...she\'s awake!!!\"

I don't see a "mybb_signatures" table...

UPDATE mybb_users SET signature = REPLACE(signature , '\\' , '')

Would that do it?

I got brave and went ahead and tried it. Perfect! That you for the instruction. Smile
Pages: 1 2