[mmice]

3,763,193 total still.. Seems it doesn’t repair any.
I guess it stucks on “select” query, and so just doen’t start to update.

[mmice]

Hmmm, yep, i see.
The question is where i can find reply positions in DB? Or where they should appear, if none.
Maybe i’m blind a bit, but cannot find such a field in _posts table.

[mmice]

Well, i ran:

SELECT a.ID FROM bb_posts AS a
INNER JOIN (
 SELECT menu_order, post_parent
 FROM bb_posts
 GROUP BY menu_order, post_parent
 HAVING COUNT( * ) >1
)b
 ON a.menu_order = b.menu_order
 AND a.post_parent = b.post_parent
 WHERE post_type = 'reply';

3,763,193 total, Query took 11.5215 sec
I guess it’s only SELECT and yep, it returns what is have to be fixed?
Script seems to make “bbp_update_reply_position” with that information. Where can i find the reply position in DB?

[mmice]

I really appreciate!

Yep, it’s likely php script code limitation. I already asked for admin’s to encrease php_time_limit, but it’s still to small ))

[mmice]

Is there a kinda SQL-version for Recalculate the position of each reply?
It could workout, i guess.

[mmice]

Recalculating the topic for each post … Complete!
Recalculating the forum for each post … Complete!
Recomputing latest post in every topic and forum… Complete!

Trying “replies” tab:
No data received
ERR_EMPTY_RESPONSE

Recalculate the position of each reply loads for a while and than get’s white screen.

P.S. I already wrote about that. When i try to import not millions, but just 2 replies for the test, – have the same trouble (replies tab doesn’t open), but “Recalculate the position of each reply” fixes the problem.
But it just don’t work for millions (

[mmice]

I already did that!

As i import topics and replies, i store their old id’s in post_excerpt.
And then updating parent_id’s, depending on their new ones.

Any way, – parentness is all right in frontend. Backend stucks (

[mmice]

@robkk thank’s.
yep, looks like i’m waiting for @netweb )

@netweb, – let me clarify:

• i know, that forums, topics, replies, posts, attachments are all in one DB table (_posts)
• i’m sure, i’m not mistaken in parent id’s and author id’s when importing all that
• but i do nothing to the _post_meta table, guess, – that’s my problem

So, is there any way to fix _post_meta? If not, then which thing’s should i insert there manually to get success? )

[mmice]

@robkk, so didn’t I. But in fact, – all replies are present in there right places with right authors and right post dates, i can also make new replies or edit old ones, except 1 little, but weird thing: i can’t open “replies” tab in backend ((

Maybe, i even do not need to, but the time my customer see that, – he asks, – WTF?

[mmice]

Maybe, there’s some SQL code to check my DB for consistency and to fix some relationship problems if they’re present?
I guess, for such a big number of replies it could be faster, than any php tool, and also more clear, as i’m already working through DB manually.

[mmice]

I guess, by trouble could be caused by:

• i import nothing to _post_meta – what should i import there?

[mmice]

@robkk oh, G-d! I know that ))) I have been using a bb_ prefix for my WordPress install )))
So yep, – i have all posts in bb_posts (if i used wp_ prefix, it would be wp_posts).

[mmice]

No, i have bbPress 2.5.7
Actually, first i tried to use your phPBB v3.x importer and rebuild it for phpBB 1.
But i gave up (just couldn’t understand all the points).

Anyway, – for this moment most problems are already resolved. The only question is:
Isn’t it enough to import replies to bb_posts table?

[mmice]

Raw SQL, yep.
Here it goes:

EDIT: SQL code is now here https://gist.github.com/anonymous/8d1cb71e69d52ac69f5d

That’s not all, – i still have to implement a karma system to bbpress and also import it, and still have to import private messages. If you will be so kind to point me, what i’ve missed (and that cause error i’ve been experiencing), i appreciate it so much )

[mmice]

But i can’t! And, well, what’s the matter, – from wich version of phpBB do i import my forum, as i do it manually?

[mmice]

I just ran a test, – tried to import just 2 replies (by DB), – see white page (No data received ERR_EMPTY_RESPONSE) @ the “Replies” section in admin.
After i ran “Recalculate the parent topic for each post”, “Recalculate the parent forum for each post”, “Recalculate the position of each reply” – problem get fixed.

Now i import all the 3M+ replies. I’m able to run only “Recalculate the parent topic for each post”, “Recalculate the parent forum for each post”. “Recalculate the position of each reply” fails with white page. The “Replies” section in admin is white (((

[mmice]

Still no idea?