Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Google Sign In, "Bonk" - Duplicate entry '2319-7' for key 'PRIMARY'

edited March 2011 in Vanilla 2.0 - 2.8
After enabling the OpenID and Google Sign In plugin, we're running into problems with people logging in via Google. Once they enter in their username and then go to Google to accept the auth, we're getting a "Bonk" error message. After doing some digging I found this:

Duplicate entry '2319-7' for key 'PRIMARY'
insert GDN_UserRole
(UserID, RoleID)
values (:UserID, :RoleID)

[Sql] 'insert GDN_UserRole
(UserID, RoleID)
values (:UserID, :RoleID)'
[InputParameters] array (
':UserID' => '2319',
':RoleID' => '7',
[Options] array (
'ReturnType' => 'ID',
[PDOStatement] array (
'queryString' => 'insert GDN_UserRole
(UserID, RoleID)
values (:UserID, :RoleID)',

It seems like the plugin is again trying to add data to the GDN_UserRole table which already exists, thus resulting in the duplicate entry.

Is this a known bug?


Sign In or Register to comment.