× Joomla Facebook Connect support forum

facebook userid 2147483647

playak
Offline

Active Subscriptions:

None

14 years 5 months ago #2224 by playak

facebook userid 2147483647 was created by playak

I got a lot of users being mapped to facebook user id 2147483647. this
number is the maximum value of a mysql INT(11) field. i assume this happened
because modern facebook IDs can be very long. to solve it, i changed the
type of the fb_user_id in the use map table to BIGINT(20).

i hope it will help...

please repair this error for the next release.

cheers,
jeroen

The topic has been locked.

alzander
Offline

Support Specialist

14 years 5 months ago #2230 by alzander

Replied by alzander on topic facebook userid 2147483647

Wow, that's great timing, and a terrible problem. Thanks for reporting it, it will definitely be in the 2.5 release.

Thank you very much for reporting it. We test with a handful of Facebook accounts, which obviously were created a while ago (hence, lower FB Ids), and would have missed this. The next version will automatically update the column (for previous users) to the larger size on installation.

The topic has been locked.

Start
Prev
1
Next
End

SourceCoast Login

facebook userid 2147483647