hey Dennis,

Perhaps you can elaborate more details how to replicate this issue?

For example :
1. Allow us to test on your dev site with your same data on your live site.
2. Which profile type you have put `auto join group` feature.

sure can, I will make a backup and throw it on my dev site. I'll update you as soon as i have it ready. Registered users should be auto-joining the "auctions" group. I'll post more info when i have the dev site up.

Hi Alex, I just put a recent backup to the dev site. Please note I updated the domain (if you can update my support domain please)

I turned off email sending, you can do anything you wish to that dev site.

Hi there,

After long hour checking, we found out that 31 registered user is in pending state(state='4') as shown below.

SELECT count(*) FROM `iph86_social_clusters_nodes` where `state`=4 and `cluster_id`=9; (user under pending mode) 31 

SELECT count(*) FROM `iph86_social_clusters_nodes` where `state`=1 and `cluster_id`=9; (user already joined)846 

SELECT count(*) FROM `iph86_social_users`; (total of the site member) 884

846 + 31 = 877

884 - 877 = 7 (the rest of the user is under `Dealer / Business Account` profile type which do not have auto join group feature)

if you want to enable all you can just run this query below.

UPDATE `iph86_social_clusters_nodes` SET `state` = 1 where `state`=4 and `cluster_id`=9;

p/s: You can contact your database service provider for further check on this issues.

Hello Abdul, it is not the pending users I'm talking about. Registered users who have completed the activation are not added to the group I specified in the profile types. I understand how the pending users works, but once they have activated they should be added to the "auctions" group.

I finf roughly 10% do not, and I must manually approve them, even tho they are listed in the group as a member they are not activated.

here are two screenshots, showing a fully registered and activated user, who should be auto-joined to the group, yet they are not.. I have to manually activate those users. There are all registered users from yesterday, all have activated their accounts.

Thanks Arlex, don't worry about the confusion I will apply this patch and let you know if I see this issue again. I will know soon.

Hi Arlex, it appears that did not solve the issue, here are screenshots showing the same problem.

missing one screenshot

Hey Dennis,

I can't replicate in locally, can you provide us with your FTP access for your dev site?

Also, can you share with me how your user activate their user account after register? Is it activate by himself or admin activate from backend?

Hi Arlex, I do not have FTP access to this server due to security restrictions. Users active their own accounts using the emailed token.

I will look into allowing SFTP or SCP access to the dev server using a jail or chroot. Can you provide the IP address you will be originating from?

Hey Dennis,

This is my current IP address : 175.144.36.109

Is it your dev site server is same with your live site?

Hi Arlex, yes the dev server is on the same as the live site. I will hopefully have something done for you soon. Most likely I will have to send you an RSA key as I do not allow password logins.

Hey Dennis,

Keep us update once you get the RSA key.

May i know RSA key is it similar with the private key which access in SSH server?

Perhaps you can provide me some of the instruction how to access your server file directory using this RSA key.

Arlex, my appologies. It seem that patch did work. that user must have registered just before I applied the fix. There has not been any more users not joining the groups set in the profile types.

I will consider this closed, and thank you for your time!

Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.