If i want to create views block for show FRIENDs ON LINE (using Relationships module) i have error in this line:
AND ((1271483847 - users.access) < 900)
it`s hapend becouse Relationships module rename "users" table in veiws query like this "users_user_relationships"

for fix this problem I modifide line 15 FROM: $sql = "(". time() ." - users.access) < 900";
TO: $sql = "(". time() ." - users_user_relationships.access) < 900";

Comments

broncomania’s picture

broncomania commented

thx man !! but I still get this message

User warning: Unknown column &#039;users.access&#039; in &#039;where clause&#039; query: SELECT user_relationships.rid AS rid, users_user_relationships.picture AS users_user_relationships_picture, users_user_relationships.uid AS users_user_relationships_uid, users_user_relationships.name AS users_user_relationships_name, users_user_relationships.mail AS users_user_relationships_mail FROM meshle_user_relationships user_relationships INNER JOIN meshle_users users_user_relationships ON user_relationships.requestee_id = users_user_relationships.uid INNER JOIN meshle_users users_user_relationships_1 ON user_relationships.requester_id = users_user_relationships_1.uid WHERE (user_relationships.approved = &#039;1&#039;) AND (user_relationships.rtid in (&#039;1&#039;)) AND ((1296412646 - users.access) &lt; 900) AND (users_user_relationships_1.uid = 18) LIMIT 0, 10 in _db_query() (line 148 of /home/.../public_html/includes/database.mysqli.inc).
broncomania’s picture

broncomania commented

Update: For all the others outside. Duke is right
you have to change the value in all files
views_handler_field_is_online.inc
views_handler_filter_is_online.inc
views_handler_sort_is_online.inc

Then is everything working fine.

socialnicheguru’s picture

socialnicheguru commented

will this fix get committed?

YK85’s picture

YK85 commented
Status: Active » Needs review

Can someone provide the changes as a patch to be reviewed?