Posted by Avaz Mano on December 6, 2011 at 7:51am
3 followers
| Project: | Drupal for Facebook |
| Version: | 6.x-3.x-dev |
| Component: | Facebook Connect |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
An account is created for the first user with a 64bit ID that registers. But any user with a 64bit ID after that, is unable to register and is instead logged in as the first user.
I've checked fb_user, fb_user_app and they are already bigint(20)
I've looked at the tables and it seems the correct ID was not inserted for the first user that registers and instead fbu has 2147483647
I read somewhere that the query needs to be updated from %d to %s for the fbu insert so I tried changing line 811 in fb_user.module to
db_query("INSERT INTO {fb_user} (uid, fbu) VALUES (%d, %s)", $account->uid, $fbu);With the change the correct ID was inserted but I couldn't login and everytime I refreshed a duplicate user was created.
Is anyone else having this issue? Any suggestions?
Comments
#1
Where did you read about the %s trick?
#2
Does this work better?
#3
Looks like that does work. Seems to be working great so far.
I read about the %s trick here http://drupal.org/node/560316. I will test some more. Thanks a bunch, this had me up all last night.
#4
I'm not sure why this problem is not more widespread. Is there something about php and/or mysql configuration that makes this a non-issue for some installs?
Here's a patch that covers more database tables.
#5
I think you just need to update your drupal core. Which version are you using?
(Marking this as fixed, not because I checked anything in. I don't plan to. I think this has been fixed in core.)
#6
Could be I'm using Drupal 6.12. Guess I should update.
Thanks a lot for the additional patch.
#7
Well, I don't recommend the patch, and have no plans to check it in. You should upgrade drupal.
#8
Automatically closed -- issue fixed for 2 weeks with no activity.