UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Rebuild Posts - just caused a bunch of HTML to show up in old posts

I recently upgraded my boards from 7.2 to 7.5.4.2, and then ran the rebuild posts option. This worked fine for the most part, but really old posts (the board started on WWWThreads 3.5) have a lot of exposed HTML tags. If I edit them and change it to allow HTML and UBB code, it fixes the issue. However, it would be slightly time consuming to do that to 300k posts :-)

Digging into the database, I find POST_BODY has lots of stuff like this:
And then POST_DEFAULT_BODY has this:

If I edit a post and set the type to both ubb and HTML, POST_BODY ends up matching POST_DEFAULT_BODY with proper HTML.

Whats the best way to clean this up on a mass scale?

Wow, you're an old timer

One thing that might work is if you have some sort of an idea of the largest POST_ID that has this problem. With that, you could do a mass update and set POST_BODY to be the same as POST_DEFAULT_BODY for all of those posts. So, say the problem stops at POST_ID 125367, you could run this query:

It should be easy enough to find the ID. Glad to see it's an easy fix, I wasn't quite sure about mass copying POST_DEFAULT_BODY into POST_BODY, so I wanted to check first.

Thanks for the quick response, support like this is why I've stuck to the software after all these years :-)

It will take awhile for the query to run, but the index is on POST_DEFAULT_BODY so it won't have to do any reindexing, so that will help.

Ok, that kinda did it, the HTML disappeared. Now I have posts with exposed UBB tags and all the breaks between paragraphs went poof. As a followup, I tried this:


That didn't seem to change much.

I do have a backup prior to the rebuild of the posts. Does it renumber posts at all, or should I be safe to just restore the posts below X ID?

The rebuild doesn't renumber posts at all, so you could just restore the posts below that certain id.

Sorry about that, I had totally forgot about how it would have the raw ubb tags, was just thinking about the html.