Can't add more than one user to a group

Permalink
I created a group, then added a user to it. When I try to add a second user to the group I get the following error:

mysql error: [1062: Duplicate entry '3' for key 2] in EXECUTE("insert into UserGroups (uID, gID, ugEntered) values (3, 3, '2011-01-06 12:06:48')")

I checked the UserGroups table in the database and that user is not there, therefore not duplicate. I ran an optimize and repair on the database, cleared the cache in Concrete, and tried again. I got the same error. I then tried to run the command in phpMyAdmin, received the same error.

Help please.

kevin001
 
kevin001 replied on at Permalink Reply
kevin001
Disregard, I checked the gID and for some reason it was marked as Unique instead of Index.