User Manager -- partial SQL Database Error

[creativepart]

I have a member's account that I need to modify. But when I go to that member's page in the Admin>User Manager I get all of the left hand column of that page showing up normally and the Usergroup part shows normally, but the rest of the right hand side of the User Manager page shows up with a SQL Server error that reads:

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT title, usergroupid FROM vB_usergroup WHERE usergroupid IN (2, 8 8) ORDER BY title;

MySQL Error : 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 '8) ORDER BY title' at line 1
Error Number : 1064
Date : Wednesday, August 22nd 2007 @ 12:44:45 PM
Script : http://www.tdpri.com/forum/admincp/u...do=edit&u=8556
Referrer : http://www.tdpri.com/forum/admincp/user.php?do=modify
IP Address : 216.177.161.207
Username : webmaster
Classname : vb_database

This also removes the "Submit" button from the bottom of the page so I can't make changes to the parts that show up on the page as it is.

I haven't found this to happen on any other members user manager page.

[Wayne Luke]

Edit that user in PHPMyAdmin and remove the second 8 and the space before it from the membergroupids field.

[creativepart]

Great thanks. I did a search of other members and for 27 that have that double 8 in their membergroupid.

How does this happen?

Also, I could manually fix all 27 but could you be so kind as to provide a sql query I can use to do this automatically?

Lastly, I checked and out of over 15,000 members only 53 members have any membergroupid at all. The rest are all blank. What does the membergroupid signify?