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.
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.