Hi,
I was trying to add a simple filter to the user_relationships_browser view because i wanted to show (like in Facebook) only the online friends.

I have set a filter this way:

User -> Is Online -> true
User is related to "Requestee"

I get this weird error:

user warning: Unknown column 'users.access' in 'field list' query: SELECT user_relationships.rid AS rid, user_relationship_types_user_relationships.plural_name AS user_relationship_types_user_relationships_plural_name, users_user_relationships.name AS users_user_relationships_name, users_user_relationships.uid AS users_user_relationships_uid, user_relationships.updated_at AS user_relationships_updated_at, (1266691119 - users.access) < 900 AS users_user_relationships_is_online FROM user_relationships user_relationships LEFT JOIN users users_user_relationships ON user_relationships.requestee_id = users_user_relationships.uid LEFT JOIN users users_user_relationships_1 ON user_relationships.requester_id = users_user_relationships_1.uid LEFT JOIN user_relationship_types user_relationship_types_user_relationships ON user_relationships.rtid = user_relationship_types_user_relationships.rtid WHERE (user_relationships.approved = '1') AND (user_relationships.requester_id = 1) ORDER BY user_relationship_types_user_relationships_plural_name ASC LIMIT 0, 30 in /var/www/drupal6/modules/views/includes/view.inc on line 765.

This function is vital to my community. What to do? Thanks in advance

CommentFileSizeAuthor
#4 online.txt4.97 KBbaff

Comments

Jj-1’s picture

Jj-1 commented

subscribe

autoberater’s picture

autoberater commented

I get this error, too. I tried this way : http://drupal.org/node/367536
But it doesnt work for me.
So if anybody get this fixed it would be great!

junro’s picture

junro commented

subscribe

baff’s picture

baff commented
StatusFileSize
new online.txt4.97 KB

Here is the view which works for me. I do not understand very well - I just found out by trial and error -
so please do not rely on this, just test it. The view provides a block of the current users's friends online.

PS: As far as I can remember the online filter used in this view is from user stat module.
But of course you can use the user's last login date for testing, so you don't need to install user stat module.

YK85’s picture

YK85 commented
Status: Active » Closed (duplicate)

this is now easily possible with #866400: Views filter patch for current user
marking this as duplicate