Thanks for the topic. I solved my issue by putting only one group per user.
For the past two months, every Sunday or so, all my groups, especially a paid member group called "armember," would disappear. I had to manually rectify it regularly.
Another question I had was: How can I desynchronize groups between WordPress and wpForo?
Hi @gilbau,
Navigate to Dashboard > wpForo > Settings > Login & Registration, and disable "Role-Usergroup Synchronization" option.
My issue is still there
I have a group named armember which have to be not synchronized whith nothing, but for example I installed the new 2.18 wpforo this morning and this evening all my armember group was to 0 members instead of 281
So I have to make export daily of my wp_usermeta wp_user and wp_wpforo_profiles to backup the good datas
I think that wpforo synchronize some datas which have not to be synchronized
Perhaps As my armember group has no wpforo group in the synchronised function, every data is erased !
And the thing which is not clear and bad i that all the wpforo cron task is not visible
I join the code I use in a cron task to solve temporarly the issue
<?php
$servername = "servername";
$username = "username";
$password = "password";
$dbname = "dbname";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
function RunSQL($conn, $sql)
{
if (!$conn) {
die("Pas de connexion.");
}
if (mysqli_multi_query($conn, $sql)) {
// Récupérer et vider les résultats des requêtes précédentes
while (mysqli_more_results($conn) && mysqli_next_result($conn)) {
if ($result = mysqli_store_result($conn)) {
mysqli_free_result($result);
}
}
echo "Record updated successfully";
} else {
echo "Erreur avec : \r\n$sql";
echo "Error updating record: " . mysqli_error($conn);
}
}
//Mettre en usermeta les 281 armember du 02 juin 2023
RunSQL($conn, "
REPLACE INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES(2383, 158, 'wp_capabilities', 'a:2:{s:22:\"armember_access_plan_2\";b:1;s:8:\"armember\";b:1;}');
REPLACE INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES(4258, 283, 'wp_capabilities', 'a:2:{s:22:\"armember_access_plan_2\";b:1;s:8:\"armember\";b:1;}');
REPLACE INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES(5068, 337, 'wp_capabilities', 'a:2:{s:22:\"armember_access_plan_2\";b:1;s:8:\"armember\";b:1;}');
");
//and more 278 members have to be added
mysqli_close($conn);
I join a pdf document with my good situation and the bad is when armember group is at 0 instead of 281
this morning I just click on the "synchronize button" and 3 of my groups "assidus" "VIP" or "confirmés" become at 0 or 19 members in the wpforo section
At the end I decided not to synchronise any more between wpforo and wordpress groups