Jump to content


Photo

Rebuild post content remove break from post content


When you perform "Rebuild post content" from ACP after upgrading from 3.1.4. then after rebuild the complete topic and post massivelly showing.

it means it remove the <br> between lines.

for example:

This is topic post line 1
and
This is topic post line 2

after rebuilding:

This is topic post line 1andThis is topic post line 2

look like CKEditor does not support old IP.board editor posts where have span style things save.

also, it remove the break, space between content. look like CKEditor bug.

Status: Fixed
Version: 3.3.0
Fixed In: 3.3.1


14 Comments

Note: it happen with contents that posted "HTML Enable: Auto Line Break Mode" in 3.1.4. along with without HTML posted contents.
I can confirm this, and it's causing tickets.
If I rebuild with this will it restore the line breaks? Or do I need to go do that manually now?
Unfortunately you'll need to manually restore them.
Yay for fixing 70k posts...

Yay for fixing 70k posts...

No backup? it would be easy to restore only the old posts from it.

Yay for fixing 70k posts


Restore old database to localhost. edit topic on localhost, copy and past on main forum.

i almost done 10,000 topics. Not posts. because member visitors and peoples read only topics not every post.
That download doesn't seem to fix the issue Matt.

To be specific, I rolled back my DB to just after the upgrade from 2.3.6 to 3.3 but before I rebuilt the posts, then put this file in place of the old one and ran the rebuild.

What happened is that it is currently processing post 160,000-odd and my forum only has 110,000 posts :( It's still going and, assuming it works by order of pid ascending, I checked a few of the first 500 posts at random in case it was just repeatedly doing those ones and it doesn't seem to have done anything at all - it's just taking up resources and looping over and over forever.

Any suggestions? I do have a ticket (I imagine a lot of people do) with an ID of 793221.
Ah, I compared them and you've left a bad line in:

'where'    => 'p.pid > 20108',// . $start,

I'll change that to what it should be and presumably the other change further down the rebuild file will fix the issue :)
Looks like Matt uploaded the file with his debug code on here, we have already fixed it for the release.

I can't delete his attachment because of an error but I've re-uploaded below the correct file:
[attachment=38357:rebuild.php]

Path is "~/admin/applications/core/modules_admin/tools/"
Cheers - I can confirm that this works fine and that I've fixed my posts table.

Upgrading from 2.3.6 was well overdue and I have a lot of happy visitors now! Thanks :)
thanks for ruining me another 300,000 posts with a non working fix...
Re-re-patching my 3.3.0...

Is 3.3.1 anytime soon now ?! :mad:
It's much much worse for us, we only have a backup from about 4 or 5 months back, and this buggy script just caused us1300k posts that went haywire...