Next issue, found a missing import field “_bbp_topic_voice_count” and i’m pretty sure, thats counted participants were ment. But in woltlap db thread tbl is no colum, so i think, i’ve could du it with a sql query like this:
SELECT COUNT(DISTINCT po.userID) as participants
FROM wbb1_thread th
INNER JOIN wbb1_post po
ON th.threadID = po.threadID
WHERE th.threadID = 2086
The sql query in phpmyadmin works as mentioned. So i copied a piece of code from another importer and customized it like this (? for parts i have no clou):
$this->field_map[] = array(
‘from_tablename’ => ‘wbb1_thread’,
‘from_fieldname’ => ‘?’,
‘join_tablename’ => ‘wbb1_post’,
‘join_type’ => ‘INNER’,
‘join_expression’ => ‘USING (?) WHERE wbb1_thread.?= wbb1_post.?’,
‘to_type’ => ‘topic’,
‘to_fieldname’ => ‘_bbp_topic_voice_count’
);
But i’ve no clou, how to bring the sql in the right way for the import, missing manuals from bbPress, to understand he possibilities.
Anybody firm in this?
Thanks for the hint. I already think about it, but did not test it. So now i tried PHP 7.4.x and it works way better, just some server settings to optimize, to pretend memory exhaustion 😉
So i had some memory issues, easy tto solve in server settings.
