Yesterday I migrated my SMF to wpForo. All seemed ok. I have migrated 851 users and if I lookup the users in Wordpress, they're all there. If I look them up in the wpForo member list, I get 9 empty pages. So, no user is being displayed.
Hi @plantje,
Please do the following steps:
- in wpForo > Overview admin page click the [Synch User Profiles] button
- In wpForo > Overview admin page scroll down and click the [Delete All Caches] button
In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.
Thanks for getting back to me! Done that, but unfortunately no result. (I already did this multiple times by the way based on the suggestion I got from Gemini)
And today I was working on this again and noticed that the list of users is also not available in the forum itself. I can search for a user and find it, but I cannot see a list of users and browse through it
Thought it would be nice to update you that I have fixed it.
Turned out the query that was run to retrieve the member list was creating a cross join or a Carthesian product. and the host (One.com) is not too happy with that.
Google Gemini instructed me to add a folder wp-content/mu-plugins with the file wpforo-db-fix.php and the content:
/** * Forceer SQL_BIG_SELECTS voor wpForo ledenlijst bij One.com */
add_action('init', function() {
global $wpdb;
$wpdb->query("SET SESSION sql_big_selects=1");
});
Now it is working again! Really happy with this! A little bit less happy with the fact that I have to purchase an add on to allow users to send private messages, but that is a different matter 😉