getting error while showing a user online or offline While setting a user online or offline status with the Views module, I get this error message:


  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) &lt; 30, 1, 0) AS users_node_is_online, 1 AS expression FROM node node LEFT JOI' at line 1


How do I fix it?
I believe the field meh is referring to is provided by the user_stats module. Indeed, once installed it is possible to add that field in a views. There is also a patch for this error on the user_stats issue queue.