Social Group Transfer Issue

[theparentpack]

I recently tried to transfer a group to a member. I keep getting the message:
User does not exist

But she does exist, and even shows up in the member list. What can I do to fix this?

[Jake Bunce]

Does it work when you specify a different user?

Maybe that specific user has weird characters in her name. You can check this by examining her user record in the database using a program like phpmyadmin.

You can also try manually querying the database to transfer the group:

http://www.vbulletin.com/forum/showthread.php?t=270380

[theparentpack]

The users name is: Hayleigh & Anika's Mom, I guess the and sign as well as the apostrophe is what is causing this?

So I see this is the manual query you mentioned, my question now is what do I do with it? Where do I go to do this?

UPDATE socialgroup
SET creatoruserid = X
WHERE creatoruserid = Y

[theparentpack]

ok, I see what you mean by querying the database. When I query socialgroup.createuserid I get this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`creatoruserid` LIMIT 0, 30' at line 1