Users have been registering on my site, but the registration doesn't complete. So their entry is in the #_community_register table, but nothing in the users table. They received an email which says:

Thank you for registering at PlayShakespeare.com :: The Ultimate Free Shakespeare Resource. Your account details are as follows:

Once you have completed the rest of registration process, you will receive another confirmation email.

Hi Ron,

I just test it and seems working fine, I created "tester" user and I could activate it and could login very well, Please you check on Joomla user manager, you can see "tester" account there, the status is active and last login already stored.

Note : your backend access is not working, for next time please provide us the correct backend access.

thank you

Hi Dimas,

Thanks for checking. But I have a few users that are just in the JomSocial registration table. I tried to use the token in the URL to activated the account, but go an Invalid Token error. How can I rescue those users into the Joomla users table?

Hi Ron,

I think your user in Joomla table already deleted, once it deleted you cant revert it back. The main information account is on Joomla users, jomsocial tables only for relationship with jomsocial system.

thank you

So there should be a corresponding entry in the Joomla users table for every entry in the JomSocial registration table? If so, how would the entry just "disappear" from the Joomla users table?

yes you right, I also dont know why the records already deleted.. maybe you deleted accidently from Joomla user manager