MyBB Community Forums

Full Version: [D] Longip should be unsigned
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I found that with some ip mybb can't find posts or users. Because an integer return by ip2long is unsigned, but longip fields in database isn't set unsigned. It was wrong when ip2long return a big integer (eg: 3416392615 with ip 203.162.3.167, mybb insert value is 2147483647).
Haizzz, sorry for report an old bug. I have just found someone reported it. But I think MyBB team should fix this bug next release. The thing to do is only set unsigned those fields, and a script to update wrong long ip Smile
No, ip2long returned a signed integer if you are in 32 bit. If you are on 64 bit then it will return an unsigned integer. This has been reported and fixed for MyBB 1.6 already