Can't save Facebook User Id into database

error message?

When you post here, wrap the error message in <code>...</code> I can't see what you've posted.

Hi, I'm having the same issue: when I click on "Connect with Facebook" I get an error message: "user warning: Duplicate entry '0-2' for key 1 query: INSERT INTO users_roles (uid, rid) VALUES (0, 2) in /drupal/sites/all/modules/fb/fb_user.module on line 236."

It looks like that the code sees that there is no uid associated and will default to uid 0?

I'm getting this same message!

This only happens when I activate the "Register Users" module, and it only just started happening with the latest 3.x release. Any ideas?

Have the same problem as described. Can't find any error message though.

This is what's happening on my site.

1.
I start of whit an install with only user #1. Since I only want to use Facebook Connect as login method I disable the possibility for visitors to create new user. It seems to me that this is how it's set up on drupalforfacebook.com as well. I also set up my Facebook App, let a few hours pass and set Drupal for Facebook to create new users. I then log out.

2.
On my front page I click the Facebook Connect button and enter details for a facebook user and then allow the app access to my info. The front page is reloaded an I'm logged in. If I click "My Account" I can see from the URL that I'm user number two (#2). I log out again.

3.
On the my front page I click the "Connect with Facebook" button again and enter details for another Facebook User. This user is being logged in and everything seems to be working. But when I click the "My Account" link the URL says user #2. The username is the same numbers@facebook as for the first loged in user and I hold any permissions the first logged in user would have (Organic Groups moderator and so on). For all purposes I'm logged in as user #2 but with another users Facebook credentials. This repeats for ALL facebook users I try. Doesn't matter if its "real" users or developer ones.

4.
If I delete the only existing number@facebook user on the site and log in as another one this user will be created. But step 3 is repeated again.

Hope this information helps to solve this issue.

Regards

Sorry for bump but as this stops my site form functioning all together I'm setting this to high. Sorry if wrong of me.

Honestly? No update on this for two days?
Sorry for bugging but this halts our project.
IF I thought that I could fork the code to fix this I would have done but I rather get an official update rather then have a temporary fix.

I got the recommendation to upgrade to fix another issue (with logins) and now I have this. Ifg you need more info than I have written previously I'm happy to give it to you if I can find it. As of now we can not use the app at all.

Regards,
Fredrik

fredskronk, you're describing something completely different from what this thread is about. Please submit a new issue to track this.

When you describe the new issue, please clarify... in step 2 when you "log out" are you logging out of facebook.com or your drupal site?

After step 2 try navigating both in the drupal site and facebook.com and prove that you are in fact logged out.

Bit late for the solution but I had the same problem (not in drupal but for a facebook app), turns out I was using int(255) which cannot store facebook id. Switched it to bigint and everything worked fine. Not a drupal user so it may not be the solution in the context of this problem.

No response in one year. Closing.