I am using Views 3 and dev release of user_stats:

When creating a view that tries to sort by "is_online", the following error occurs:

user warning: Unknown column 'users.is_online' in 'field list' query: SELECT (1284420040 - users.access) < 900 AS users_is_online, users.uid AS uid, users.is_online AS users_is_online_1 FROM users users WHERE (1284420040 - users.access) < 900 ORDER BY users_is_online_1 ASC in mysite/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1096.

Comments

YK85’s picture

YK85 commented

I get the same scary error. Can anyone please help?

entrigan’s picture

entrigan commented

Since is_online is just a threshold on the last access, it is possible to achieve approximately the same functionality by sorting by last access.

I suppose you could even work it so that the last access field displayed the is_online value, change the label and it should work.

chuckbar77’s picture

chuckbar77 commented
Status: Active » Closed (duplicate)

marking this duplicate of #787682: Views 3 Compatibility