Recount table column number after migration from other software

hrvoje_hr

I'm in the phase of planning migration from wpForo forum (256k posts, 14k discussions) to Flarum. Database columns seem fairly simple to convert, but I have some questions.

In Flarum Discussions table there is participant_count column. wpForo doesn't count the number of participants in the thread. What would happen if I leave participant count in all converted discussions to 0? Is there any way to recount that statistic after migration?

EDIT: I'm gonna update discussion with new tables/columns as I stumble on them. And will update the first post in case someone with same questions finds this thread.

what is the purpose of post_number_index column in discussion table? On my Flarum test production, I see that value is in most cases the same as it is in comment_count column, but in few, it is number or two higher. If I change the value "Oops! Something went wrong." message appears.

clarkwinkelmann

hrvoje_hr all the columns ending with _count will be computed text time a post is created or deleted in the discussion, so if you are not able to update them in your migration, they will be updated next time someone post in them. Same for the user _count columns.

An extension could be created to re-compute all of them, but I don't think it has been made at this time.

The post_number_index column tells which number should be used for the next post. That column is important and should contain the highest post number value (next post will be that value + 1). That column must be updated in order to not run into errors of duplicate post numbers.

The value can be higher than the number of posts, if some posts were deleted and some post numbers are now missing. It needs to be the highest number value (or bigger, it won't create issues).

Again, an extension could be written to fix discussions automatically for that as well.

FBI

hrvoje_hr

Learn the code from this script
Database scheme is outdated, but you may found useful "participant_count" from it (query and convert) 🙂

I am able to migrate from PHPBB into flarum perfectly with some modification. 2M+ posts with 200k topics

hrvoje_hr

FBI I'm going through the script to find out can I adapt it to wpForo.

So far everything was recognizable, except this Flarum table: users_discussions near the end.

As far as I can find, sometime earlier that table was part of the Flarum database, but now it doesn't exist. It's in the part of the script where it tries to convert PHPBB user posted topics in Flarums user discussions.

// Convert user posted topics to user discussions? echo "<hr>last Step Update User table<hr/>"; $result = $importDbConnection->query("SELECT id FROM users"); if ($result->num_rows > 0) { $total = $result->num_rows; $i = 1; while($row = $result->fetch_assoc()) { $comma = $i == $total ? ";" : ","; $userID = $row["id"]; $res = $importDbConnection->query("select * from users_discussions where user_id = '$userID' "); $numTopics = $res->num_rows; $res1 = $importDbConnection->query("select * from posts where user_id = '$userID' "); $numPosts = $res1->num_rows; $query = "UPDATE " . $importDBPrefix . "users SET discussions_count = '$numTopics', comment_count = '$numPosts' WHERE id = '$userID' "; $res = $importDbConnection->query($query); if($res === false) { echo "Wrong SQL: " . $query . " Error: " . $importDbConnection->error . " <br/>\n"; } } echo "Success"; }

How's that table now solved? I assume that everything from user profile Flarum now pulls directly from discussion and posts tables? @clarkwinkelmann I assume that you would know about this as well.

clarkwinkelmann

hrvoje_hr user_discussion has been renamed to discussion_user to adhere to the "Laravel" standard (alphabetical order of table names in pivot tables) https://github.com/flarum/core/blob/v0.1.0-beta.10/migrations/2018_01_15_071700_rename_users_discussions_to_discussion_user.php

It still works exactly the same, so you should be able to just swap the name.

hrvoje_hr

Ugh, how didn't I see that 😅 Thx!