Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbuserlist
WHERE userlist.userid = 5798
AND userlist.relationid IN
(
SELECT relationid
FROM vbuserlist
WHERE userlist.userid = 3
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
)
AND userlist.type = 'buddy'
AND userlist.friend = 'yes';

MySQL Error : Unknown column 'userlist.userid' in 'where clause'
Error Number : 1054
Request Date : Saturday, December 17th 2011 @ 11:15:18 PM
Error Date : Saturday, December 17th 2011 @ 11:15:18 PM
Script : ******************
Referrer : ****************
IP Address : *************
Username : ***********
Classname : vB_Database
MySQL Version : 5.1.56-log

Please advise. Thanks.

why can't u give a option wat ever we want to enable through Admin cp

I have a similar problem witch db :( on 4.1.8

Awesome !

Now a Contacts option list would be nice too. :)
Maybe viewable only by the logged in user looking at their own profile...it does not need to be viewable by everyone else. ;)

I wonder if the Mutual Friends could be listed within the Friends Tab? Maybe friends on the left and mutual friends on the right.
Contacts could be a third row. :cool:

I've released new version 1.2 that suppose to fix that.
There was a little mistake in the query..
my server ignored that so I coudn't know about it.
I have fixed the query, please check if it works now

I will consider that in the next version :)

What do you mean? "Mutual Contacts"?

About the other thing, I pretty sure that it can't be done that way but I will check it.

hi, after install I can't see new tab in my profil, because I haven't mutual friend or a other problem? thx

Installed and it is working perfectly now :)

The mutual friends block not visible on your own profile..
from the simple fact that you don't have mutual friends with yourself :p

The mutual friends block is not visible in following cases:

1. You view your own profile
2. You have no mutual friends with the user that you are viewing his profile (contact users doesn't counts as friends)
3. You are viewing the user profile as a guest

Be sure that you actually have mutual friends with the user that you view his profile.
remember that mutual friends are friends that you have in common with the user you are viewing his profile.

Installed today's update and all is working (as it was before)

4.1.9

Thanks :)

Well Mutual Contacts could be another option.
I was thinking in terms of each user seeing a list of their own Contacts.
The Contacts seem to be a void that vB missed...or maybe I missed the contact list.