BuddyPress.org

I doubt it’s a problem with prepare() itself, since that method is used on nearly every query in BuddyPress and I have never heard of this problem before.

It could be the case that $loggedin_userid and $possible_friend_userid are improperly cast. Try switching %d with %s in check_is_friend() and see what happens.